File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How to check query within PreparedStatement object
Joined: Jun 25, 2007
Feb 28, 2008 21:52:00
pst=connection.prepareStatement("Select * from table where name=? and age=?");
Is there any method to print the query
replaced by name and age values.
Joined: Oct 13, 2005
Feb 29, 2008 01:11:00
Please check your displayed name against the JavaRanch naming policy and amend it accordingly. It requires first name-space-last name.
Joined: Jun 15, 2006
Mar 06, 2008 21:28:00
Have a look at the following article
I agree. Here's the link:
subject: How to check query within PreparedStatement object
Regarding time taken by query
Too few paramters
Exception executing servlet with database connectivity
inserting a sequence value to the table
PreparedStatement and 'null' value in WHERE clause
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013