how can I extract all the values of one field from the database table (ex : all the names from the field NAME) and put them in a combo box in run time in the dynamically generated page…

and secondly, if all the values are available in the combo box, how can I select one value at a time from the combo box and store that value in a variable during run time…

how can I extract all the values of one field from the database table (ex : all the names from the field NAME) and put them in a combo box in run time in the dynamically generated page…

and secondly, if all the values are available in the combo box, how can I select one value at a time from the combo box and store that value in a variable during run time…

hai..

I just give you the code for displaying and storing the values in the run time(part of code).


<%
//query for selecting the values from the database
pstmt1=con.createStatement();
rs=pstmt1.executeQuery("select * from test.emp");
%>

<!-- Displaying the values in the combo box -->
<form name="form1" method="post" action="">
<center>
<p>Select the Employee Id from the Combo box
<select name="eid" id="eid" onchange="filename.jsp">
<%
while(rs.next())
{
%>
<OPTION VALUE="<%=rs.getString("empid")%>"><%=rs.getString("empid")%></OPTION>
<%
}
%>
</select>
</p>
<p>
<input name="Submit" type="submit" id="submit" value="Submit">
</p>
</center>
</form>

<!-- Storing the value in the id variable during run time-->
<%
id=request.getParameter("eid");
%>

NEVER try to connect to database from JSP!
If you need data from DB use servlet and then pass them to your JSP...

NEVER try to connect to database from JSP!
If you need data from DB use servlet and then pass them to your JSP...

Hai..

I am also beginner for Jsp.
Can you please tell me the reason(for not connecting the DB from JSP) so that i can understand the concept well.

Thanking you.

This article has been dead for over six months. Start a new discussion instead.