Search algorithm for searchin the records in a database using Java

[Chirag, Mehta]

I want some Search algorithm for searchin the records in a database using Java.
Can u pls help me out.
The requirement is that I have to display certain records based on the selected criteria. For example depending upon the city I have to find the Location in that city.(This is the simple case.) But depending on such searches I have to write a generic componenent for it. so can anyone help me out.

[Angela Poynton]

I think you may find the JDBC forum more useful!!

[Paul Stevens]

The SQL handles the search of the database. Just dynamically build your query based on the data entered. If it is entered, add it to your where clause.

[Jamie Robertson]

//create the string that will retrieve all the records
StringBuffer sql = "SELECT column1,column2 FROM table1 where 1=1";
//add on the where clauses as necessary...
//JCheckBox has criteria to add to search
if (jcheckbox1.isSelected())  {
sql.append(" AND column1 < 2000 ");
}
//a JTextField has a search criteria(it's not blank)
if (!(jtextfield1.getText().equals(""))){
sql.append( " AND column2 = " + jtextfield1.getText());
}
if ....
//execute the SQL

I've used the above method on searches that MAY be narrowed down by user inputs. I think that's what you are asking.
Jamie

[Ken Bates]

Test
energy information administration