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 set multiple values in PrepareStatement while using "IN" in the query
Joined: Apr 25, 2006
Aug 01, 2007 06:00:00
For the foll prepared stmt
ps=Connection.prepareStatement(select * from EMPLOYEE
where emp_name IN ? );
Suppose i have 3 names to find "black", "brown" and "green"
what shd I pass to setString method
Joined: Dec 20, 2006
Aug 01, 2007 11:33:00
The JavAranch article
Batching Select Statements in JDBC
by Jeanne Boyarsky proposes some approaches to handle this.
OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: How to set multiple values in PrepareStatement while using "IN" in the query
Posting to bump up my count...
Text box value is not being completely filled with request attribute
The x900 effect ?
Cant use object from another class
WA #1.....word association
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013