Java + SQL inside XML

[artmt]

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]

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();