retrieve the resultset data from listbox

[Priyanka Dande]

Hi all,

i have retrieve the data in listbox from my database already and now again i want to select the data from this listbox and query on it , is it possible?

For Ex i have listbox as follows

			<h4>Models For Selected Pattern:</h4>
			</br>
			<select Name="drop_model" multiple="true">
			<%
	                
	try
	{
      
	  Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url,username,userPassword);
	  Statement stmt = conn.createStatement();
	  String strQuery ="select DISTINCT MODEL from AGGREGATE_WEIGHT where VARIANT='"+str1+"'"; 
	  ResultSet res = stmt.executeQuery(strQuery);
	  %>
	        	<%
		           
				  //out.println("Hi"); 
	                 while(res.next()) 
		            {
		              
						%>
						<option value=<%=res.getString(1)%>><%=res.getString(1)%></option>
						<%
					}
                     					
	}
	catch(Exception e)
	{
	
	System.out.println(e.getMessage());
	
	}
	 %>

In this listbox some values are retrieved from database as

<option value="xyz">xyz</option>
<option value="pqr">pqr</option>
<option value="abc">abc</option>
<option value="lmn">lmn</option>

i want to select this values from listbox and query on them, kindly guide me for this i am not able to do this

thanks

[Balagopal Kannampallil]

Priyanka,

Writing business logic in JSP is no longer entertained as per the latest standards. Try to move the java code into a servlet and just use the jsp be used for view purposes.