get data from database

[rakhi sinha]

I want to retrieve values from database to drop down box in servlet .I want database values in place of a and b.

out.println("sadasd");
out.println ("<select name=\"select5\">");
out.println("<option> a </option>");
out.println("<option> b </option>");
out.println("</select>");

[Tim Moores]

Once you have retrieved the values from the DB you can use them however you like, including using them in a servlet. What do you have so far, and where are you stuck making progress?

[rakhi sinha]

Tim Moores wrote:Once you have retrieved the values from the DB you can use them however you like, including using them in a servlet. What do you have so far, and where are you stuck making progress?

I am using this code but drop down box is empty.

out.println("<td>");
out.println("bdfghd");
out.println("<select name=\"select5\">"); 
out.println( "<OPTION value=0 selected>None </OPTION>");
 st=con.createStatement(); 
 rs=st.executeQuery("Select abc from pp" ); 
 while(rs.next())
 {  out.println(" <option value=+ out.println(rs.getString(abc));+ ></option>");  
 }   
out.println("</select>");
out.println("</td>");

[Tim Moores]

The out.println statement looks completely messed up. It seems that you're printing a Java statement to the HTML output. I think you're missing some double quotes in there, and you shouldn't repeat the "out.println" part.

Also, you've checked that the ResultSet is not empty, yes?

[rakhi sinha]

Tim Moores wrote:The out.println statement looks completely messed up. It seems that you're printing a Java statement to the HTML output. I think you're missing some double quotes in there, and you shouldn't repeat the "out.println" part.

Also, you've checked that the ResultSet is not empty, yes?

I have checked the resultset....it is not empty.
I am usingfollowing loop.
while(rs.next())
{
out.println(" <option value="+ rs.getString("NO")+" ></option>");

}

[Tim Moores]

So it's working now?

[rakhi sinha]

Tim Moores wrote:So it's working now?

yes it is working now..