struts1.2 从jsp页面传递数据到action的问题!!求解~~
在jsp页面显示两个下拉列表,选中值后查询,如何在action中得到所选的值,并从数据库查询
action代码如下,得不到getParameter("name")的值,jsp页面需要改动吗?
public class Search_disAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
Search_disForm search_disForm = (Search_disForm) form;
ArrayList<String> result=new ArrayList<String>();
try{
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=db_struts","sa","1234");
String name=request.getParameter("name");
String sql=" select con_id,con_name,total_in,total_out,total,date from tb_kucun where dis_name LIKE '"+name+"' and date in (select max(date) from tb_kucun group by con_name ) order by con_id";
Statement connection=con.createStatement();
ResultSet rs_result=connection.executeQuery(sql);
while(rs_result.next()){
result.add(rs_result.getString("con_id"));
result.add(rs_result.getString("con_name"));
result.add(rs_result.getString("total_in"));
result.add(rs_result.getString("total_out"));
result.add(rs_result.getString("total"));
result.add(rs_result.getString("date"));
}
if(rs_result!=null){
rs_result.close();
}
if(con!=null){
con=null;
} }catch (SQLException e) {}
request.setAttribute("result", result);
return mapping.findForward("success");
// TODO Auto-generated catch block
}}[/size]