How to give search query if we select one than one value from combo box

[sv krishnaveni]

In search....

i have one field like type: with type1,type2,type3 as options in combo box
i have selected 2 values type1,type2....then how to query the database to get result based on type1,type2 values..
[ July 10, 2008: Message edited by: Kittu ]

[Amit Ghorpade]

Hi Kittu welcome to Javaranch,
Firstly your name does not follow the Javaranch Naming Policy please change ithere

then tell exactly what are you trying to do,what are you searching, I think you want to query a database using the user input, if yes then what is the problem.
[ July 10, 2008: Message edited by: Amit Ghorpade ]

[Bear Bibeault]

"krishnaveni_sv", please check your private messages for an important administrative matter. Again.

[Bear Bibeault]

Also, there is no such things as a "combo box" in HTML. Please read this for more information.

[arunkumar subramanian]

By combo box, you mean <select> box?

String[] strings = request.getParameterValues("<select box name>");
 
In the Database statement pass the values as String
 
StringBuffer buffer = new StringBuffer();
for (int i = 0; i < strings.length; i++)
{
   buffer.append("'" + strings + "'");
   if (i < strings.length)
   {
      buffer.append(",");
   }
}
 
String SQL = "Select * from employee where job in (" + buffer.toString() + ")";
... Make database calls ...

Statement can be replaced by PreparedStatement, but not sure.

Hope this helps.
[ July 10, 2008: Message edited by: arunkumar subramanian ]

[Scott Selikoff]

Arunkumar, please note your code is not safe for SQL injections. In particular the input String "'); DELETE FROM Users; SELECT * FROM widgets WHERE ID IN ('1" might cause you some problems (or variations on it)
[ July 10, 2008: Message edited by: Scott Selikoff ]