Combo box and Ms-access

[rittik]

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…

[Thendral]

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");
%>

[peter_budo]

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

[Thendral]

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.

[jwenting]

JSP is a display technology, it is NOT meant to contain business logic.