목록 생성 1

===============================================MemberVo.java====================================================
public class MemberVo {
	private int No;
	private String Id;
	private String Password;
	private String UserName;
	private int Grade;
	private Date JoinDate;
	
	public MemberVo() {
		// TODO Auto-generated constructor stub
	}
	@Override
	public String toString() {
		return "MemberVo [No=" + No + ", Id=" + Id + ", Password=" + Password + ", UserName=" + UserName + ", Grade="
				+ Grade + ", JoinDate=" + JoinDate + "]";
	}
	public int getNo() {
		return No;
	}
	public void setNo(int no) {
		No = no;
	}
	public String getId() {
		return Id;
	}
	public void setId(String id) {
		Id = id;
	}
	public String getPassword() {
		return Password;
	}
	public void setPassword(String password) {
		Password = password;
	}
	public String getUserName() {
		return UserName;
	}
	public void setUserName(String userName) {
		UserName = userName;
	}
	public int getGrade() {
		return Grade;
	}
	public void setGrade(int grade) {
		Grade = grade;
	}
	public Date getJoinDate() {
		return JoinDate;
	}
	public void setJoinDate(Date joinDate) {
		JoinDate = joinDate;
	}
	public MemberVo(int no, String id, String password, String userName, int grade, Date joinDate) {
	
		No = no;
		Id = id;
		Password = password;
		UserName = userName;
		Grade = grade;
		JoinDate = joinDate;
	}
	public MemberVo(int no, String id, String userName, int grade, Date joinDate) {
		
		No = no;
		Id = id;
		
		UserName = userName;
		Grade = grade;
		JoinDate = joinDate;
	}
}
============================================MemberService.java===================================================================
public List getMemberList(String field, String query, int page, int rowNum, String order, String desc){
	List list = new ArrayList<>();

	String sql ="SELECT * FROM member WHERE "+field+" LIKE ? ORDER BY "+order+" "+ desc+" limit ?, ?";

	String dbURL = "jdbc:mysql://localhost:3306/feane";
	String dbID = "root";
	String dbPassword = "1111";
	try {
		Class.forName("com.mysql.jdbc.Driver");
	Connection conn;
	conn = DriverManager.getConnection(dbURL, dbID, dbPassword);
	PreparedStatement st = conn.prepareStatement(sql);
	st.setString(1, "%"+query+"%");
	st.setInt(2, (page-1)*rowNum);
	st.setInt(3, rowNum);
	ResultSet rs=st.executeQuery();
	
	//0,10,20,->(page-1)*10
    
	while(rs.next()){
		int no= rs.getInt("No") ;
		String id= rs.getString("ID") ;
		String password= rs.getString("Password") ;
		String userName = rs.getString("UserName") ;
		int grade = rs.getInt("Grade") ;
		Date joinDate = rs.getDate("JoinDate");
		
		MemberVo member = new MemberVo(no, id, userName, grade, joinDate);
		list.add(member);
		System.out.println("member:"+list);
	}
		rs.close();
        st.close();
        conn.close();
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
		return list;
	}
========================================header.jsp===================================================================
						
							
								
Member
								
							
						
==============================================@WebServlet("/member")====================================================
package com.MemberList;

@WebServlet("/member")
public class MemberList extends HttpServlet{
@Override
public void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
	//List list = new ArrayList<>();

	String field_ = req.getParameter("f");
	String query_ = req.getParameter("q");
	String page_ = req.getParameter("p");
	String rowNum_ = req.getParameter("r");
	String order_ = req.getParameter("order");
	String desc_ = req.getParameter("desc");

	String order = "JoinDate";
	if(order_ !=null && !order_.equals(""))
		order = order_;
	
	String desc = "DESC";
	if(desc_ !=null && !desc_.equals(""))
		desc = desc_;
	
	String field = "UserName";
	if(field_ !=null && !field_.equals(""))
		field = field_;
	
	String query = "";
	if(query_ !=null && !query_.equals(""))
		query = query_;
	
	int page = 1;
	if(page_ !=null && !page_.equals(""))
		page = Integer.parseInt(page_);
	
	int rowNum = 15;
	if(rowNum_ !=null && !rowNum_.equals(""))
		rowNum = Integer.parseInt(rowNum_);

	System.out.println("/member 실행");
	
	MemberService service = new MemberService();
	List list = service.getMemberList(field,query,page,rowNum,order,desc);
	int count = service.getMemberCount(field, query);

	System.out.println("count:"+count);
	req.setAttribute("list", list);
	req.setAttribute("count", count);
	
	System.out.println("getMemberList:"+list);
	req.getRequestDispatcher("/member_list.jsp").forward(req, resp);
}
}