GeeCON Prague 2014*
The moose likes Servlets and the fly likes multiple search/sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "multiple search/sql" Watch "multiple search/sql" New topic
Author

multiple search/sql

eric clark
Greenhorn

Joined: Jan 18, 2001
Posts: 16
hithere. just stuck on some jsp/sql coding. i did a database with pictures. and a jsp form with 5 fields, where 1 has to be filled, 5 can be filled, now i wanna search the db with criterias from the fields. some1 could explain me how this works?
im also stuck on the sql for this..
thx eric
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
Well we'd need to know a little more about the structure of your data. Is it in a single table (sounds like it)? Are the fields in the form applicable to separate database fields or are they "keywords" from a single field?
You obviously need to generate some sort of SELECT statement, but for any more answers we need a little more detail in the question.


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
eric clark
Greenhorn

Joined: Jan 18, 2001
Posts: 16
thanx, managed it btw, with getting some sql book
grtx eric
Frank InTheHouse
Greenhorn

Joined: Feb 19, 2001
Posts: 3
Check this out:
http://www.jspinsider.com/beans/snippets/database/HashTables.txt
 
GeeCON Prague 2014
 
subject: multiple search/sql