If I just have simple form having one textfield and list, how can i access the selected element in list?
<html>
<body>
<form name="clientform" method="post" action="database.jsp">
<Table><TR><TD> ID </TD>
<TD><input type = "text" name = "client_id"> </TD> </TR>
<TR><TD> Desired Skills </TD>
<TR> <TD> Skill Set </TD><TD><SELECT NAME="skill">
<OPTION VALUE="">
<OPTION VALUE="os">OS
<OPTION VALUE="rdbms">RDBMS
<OPTION VALUE="gui">GUI
<OPTION VALUE="lang">Languages
</SELECT> </TD></TR>
</Table align = "center">
<Table>
<TR><TD><input type = "radio" name="rowfunction" value="addrow" CHECKED>Add Client</TD>
</TR>
<TR><TD> <INPUT TYPE=Submit name="submit" value="submit"> </TD>
<TD><INPUT TYPE=Reset name="Reset" value="reset"> </TD>
</table>
</form>
</Body>
</Html>
//////////////////////////////////////////////////////////////////////
below is my jsp code. I am not giving complete code just part of it.
//////////////////////////////////////////////////////////////////////
if (rowfunction.equals("addrow")) {
String query = "INSERT INTO client ( client_id, skill) " +
"VALUES ( " +
"'" + request.getParameter("client_id") + "', " +
"'" + request.getParameter("skill"));
try {
statement.executeUpdate(query);
}
catch (SQLException se) {}
}
else { }
I know by applying above code it shows me only client_id value not the selected value in the list.
Thanks in advance,
Ash
