aspose file tools*
The moose likes JDBC and the fly likes How to check query within PreparedStatement object Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to check query within PreparedStatement object" Watch "How to check query within PreparedStatement object" New topic
Author

How to check query within PreparedStatement object

Vijay Arora
Greenhorn

Joined: Jun 25, 2007
Posts: 19
PreparedStatement pst=connection.prepareStatement("Select * from table where name=? and age=?");
pst.setString(1,"VIJAY");
pst.setInt(2,20);
ResultSet rs=pst.executeQuery();

Is there any method to print the query string replaced by name and age values.


vijay arora
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39828
    
  28
Please check your displayed name against the JavaRanch naming policy and amend it accordingly. It requires first name-space-last name.
suresh charan
Greenhorn

Joined: Jun 15, 2006
Posts: 8
Have a look at the following article

http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html?page=1
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to check query within PreparedStatement object