站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题求助关于在servlet中怎样获取 在下拉表单中 用户究竟是选择的哪个选项阿?

求助关于在servlet中怎样获取 在下拉表单中 用户究竟是选择的哪个选项阿?

摘要: 求助关于在servlet中怎样获取 在下拉表单中 用户究竟是选择的哪个选项阿?


public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
response.setContentType("text/html");
out=response.getWriter();
out.println("<head>");
out.println("query page</head><body>");
out.println("you can select your information through checking the checkbox!");
out.println("<form method=/"post/">");
out.println("<select name=/"infm/"");
out.println("<input type=/"submit/" value=/"submit/" >");
out.println("</form></body>");
}




public void setOption() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
con=DriverManager.getConnection("jdbc:oracle:thin:@10.232.226.220:1521:oraedu","edu12","xxx");
Statement st=con.createStatement();
rs=st.executeQuery("select * from emp");
ResultSetMetaData rsMd = rs.getMetaData();
for (int i = 1; i <= rsMd.getColumnCount(); i++) {
out.println("<option value="+rsMd.getColumnName(i)+">"+rsMd.getColumnName(i));
}

} catch (SQLException e) {
e.printStackTrace();
}finally{
if(con!=null){
try {
con.close();
con=null;
} catch (SQLException e) {
e.printStackTrace();
}
}

}

}
这个是代码!
谢谢各位了


提交页面代码:
<form action="servlet">
<select name="sel">
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
</select>
<input type="submit">
</form>

在servlet里接收:
String selectValue=request.getParameter("sel");


这样改就可以了public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
response.setContentType("text/html");
String infm = request.getParameter("infm");
infm = (infm==null)?"":infm;
out=response.getWriter();
out.println("<head>");
out.println("query page</head><body>");
out.println("you can select your information through checking the checkbox!");
out.println("<form method=/"post/">");
out.println("<select name=/"infm/"");
out.println("<input type=/"submit/" value=/"submit/" >");
out.println("</form></body>");
}




public void setOption(String infm) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
try {
con=DriverManager.getConnection("jdbc:oracle:thin:@10.232.226.220:1521:oraedu","edu12","xxx");
Statement st=con.createStatement();
rs=st.executeQuery("select * from emp");
ResultSetMetaData rsMd = rs.getMetaData();
for (int i = 1; i <= rsMd.getColumnCount(); i++) {
String optionValue = rsMd.getColumnName(i);
if(optionValue!=null && optionValue.equals(infm))
out.println("<option value="+optionValue+" selected>"+optionValue);//被选中的那个
else
out.println("<option value="+optionValue+">"+optionValue);
}

} catch (SQLException e) {
e.printStackTrace();
}finally{
if(con!=null){
try {
con.close();
con=null;
} catch (SQLException e) {
e.printStackTrace();
}
}

}

}



万分感谢楼上二位大侠
我先试试哈
呵呵


过了 呵呵


↑返回目录
前一篇: JFreechart的问题?
后一篇: 如果线程安全,JSP被翻译成Servlet后,为什么会产生2个对象?第一个对象有何用处?