aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatment - Search Page" Watch "PreparedStatment - Search Page" New topic
Author

PreparedStatment - Search Page

arunkumar subramanian
Ranch Hand

Joined: Jun 10, 2008
Posts: 32
Hi

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30758
    
156

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
Greenhorn

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



hope this helps!
Ryan Webb


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

Joined: May 26, 2003
Posts: 30758
    
156

Ryan,
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PreparedStatment - Search Page