Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / December 2005

Tip: Looking for answers? Try searching our database.

Java + SQL inside XML

Thread view: 
artmt@hotmail.com - 01 Dec 2005 23:07 GMT
I have a SQL query inside XML document which is being read by JSP
application.
Is it possible to reference a Java method inside the SQL string?

Something that looks like this:

SELECT * FROM dual WHERE user = request.getRemoteUser()

If this is possible what is the correct syntax?

Thanks
-Art
Roedy Green - 01 Dec 2005 23:17 GMT
>SELECT * FROM dual WHERE user = request.getRemoteUser()
>
>If this is possible what is the correct syntax?

you create a prepared statement, then fill in the variables with
values gleaned from java calls.

// With PreparedStatement, you leave ? where you come back later to
fill in the data.
// Update vendortimestamp field if the new value is bigger.
// Demonstrates use of the GREATEST function.
PreparedStatement stmt = conn.prepareStatement( "UPDATE vendors SET
vendorTimestamp=GREATEST(vendorTimestamp, ?), WHERE vendorId=?" );
stmt.setLong( 1, aPossiblyBiggerTimestamp );
stmt.setInt( 2, desiredVendorId );
stmt.executeUpdate();
Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.