File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes PreparedStatment - Search Page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatment - Search Page" Watch "PreparedStatment - Search Page" New topic

PreparedStatment - Search Page

arunkumar subramanian
Ranch Hand

Joined: Jun 10, 2008
Posts: 32

I have a search page with some text boxes (empno, ename, designation, deptno) where the user can enter some values to search. How to create a prepared statement for this search?

[edited to add line break]
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29261

You would need to use some if statements to append just the entered fields in the query.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ryan Webb

Joined: Dec 09, 2009
Posts: 28
try this.

hope this helps!
Ryan Webb

frustrated to learn c/c++/objective-c
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29261

That won't work. SQL requires "and" rather than "," to separate commas.

The reason I didn't suggest this is it implies all of the fields were entered. If any are optional, Arunkumar needs to write logic to concatenate the relevant parts of the where clause.
subject: PreparedStatment - Search Page
Similar Threads
Order by query..
Urgent: Setting values for the bind parameters of a RowSet query
running the result from the end
Problem with ContainsKey(obj key) in HashMap
can a batch have multiple prepared statements