building a dynamic Query String

[prabhu kandanur]

hi

building a dynamic Query String "using java code examples"
where can i get
-prabhu

[M. Gagnon]

Could you perhaps mean a PreparedStatement? For example:

String query = "SELECT * FROM sometable WHERE sometable.somefield = ?";
PreparedStatement stmt = conn.prepareStatement(query);

The question mark represents a value that is set at runtime. You set the value with a call to a setter method on the Statement object:

// Could be setInt(), setDate(), setBoolean(), etc.
stmt.setString( 1, getValueForSQL() );
rs = stmt.executeQuery();