enrolselectaction.java

JAVA注册表 详细列表 系统设计 源码

/*
 * 创建日期 2002-1-1
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package action;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import user.User;

import db.DbUtil;

public class enrolSelectAction extends Action {
	String name;
	String sex;
	
	
	
	public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {
		  name=request.getParameter("name");
		  sex=new String(request.getParameter("pp").getBytes("iso-8859-1"));		  
		  ArrayList userList=new ArrayList();
	Connection conn=(Connection) DbUtil.getConn();
    String sql="select id,name,password,email,card_number,sex,home_town,good_at,h_m_call,h_m_name,h_m_phone,jian_yi from inf where name like '%"+name+"%' and sex like '%"+sex+"%'";
    Statement ss=conn.createStatement();
    ResultSet rs=ss.executeQuery(sql);
    
    
    while(rs.next()){
    	
    	User user=new User();
    	 user.setId(rs.getString(1));
    	 user.setName(rs.getString(2));
    	 user.setPassword(rs.getString(3));
    	 user.setEmail(rs.getString(4));
    	 user.setCard_number(rs.getString(5));
    	 user.setSex(rs.getString(6));
    	 user.setHome_town(rs.getString(7));
    	 user.setGood_at(rs.getString(8));
    	 user.setH_m_call(rs.getString(9));
    	 user.setH_m_name(rs.getString(10));
    	 user.setH_m_phone(rs.getString(11));
    	 user.setJian_yi(rs.getString(12));	
    	 userList.add(user);
    	 
    }
    
    request.setAttribute("userList",userList );
    
    
    return mapping.findForward("success");

}
}