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
JDBC and Relational Databases
How to check query within PreparedStatement object
Joined: Jun 25, 2007
Feb 28, 2008 21:52:00
PreparedStatement 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
PreparedStatement and 'null' value in WHERE clause
Regarding time taken by query
Exception executing servlet with database connectivity
inserting a sequence value to the table
Too few paramters
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015