userlist.java

jsp超市管理系统系统,是用经典的MVC设计模式开发的非常适合初学者学习。

package com.myservlet.user;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;	
import javax.servlet.http.*;
import com.dbconn.*;
import com.mybean.*;


public class UserList extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = -6352549985627985189L;

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException{
		performTask(req, resp);
	}

	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException{
		performTask(req, resp);
	}

	private void performTask(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException{
				
		String pageNo = req.getParameter("page");
		if (pageNo == null){
			pageNo = "1";
		}
		int	intPageNo = Integer.parseInt(pageNo);

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");  		
		PreparedStatement ps = null;
		ResultSet rs = null;
				   		 
		try{
			String sql = Pages.limitQuery2(((intPageNo - 1) * Pages.PAGE_SIZE + 1), (intPageNo * Pages.PAGE_SIZE));
			System.out.println(sql);
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
				
			Collection col = new ArrayList();
					
			while(rs.next()){					
				User user= new User();	
					
				user.setId(rs.getString("id"));
				user.setName(rs.getString("name"));
				user.setSex(rs.getString("sex"));
				user.setPhone(rs.getInt("phone"));
				user.setPay(rs.getInt("pay"));
				user.setRemark(rs.getString("remark"));
				user.setStatus(rs.getString("status"));
				user.setPwd(rs.getString("pwd"));
					
				col.add(user);
			}			
			req.setAttribute("col", col);				
		}
		catch(SQLException e){
			System.out.println(e);
		}
		finally{
			try{
				rs.close();
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("oracle", conn);
		}
							
		String strSql = "SELECT count(*) FROM consumer";
		int allRecords = Pages.allRecords(strSql);	//所有记录数
			
		Pages pages = new Pages(intPageNo, allRecords, "UserList?id=2", req);	
		String page = pages.allString();	//获取返回分页操作字符串
		String totals=String.valueOf(pages.getTotals());
		req.setAttribute("page", page);
		req.setAttribute("totals", totals);

		RequestDispatcher reqDispatcher = req.getRequestDispatcher("user/userList.jsp");	//将结果返回到指定页面
		reqDispatcher.forward(req, resp);	
	}
}