8月23号 jsp分页查询

创建一个user类，包括3个属性，创建简单的连接数据库的类。创建接口userMag，并通过userMagImpl实现：

public List getUser(String s) {
        Connection ct = null;
        Statement sm = null;
        ResultSet rs = null;
        List users = new ArrayList();
        try {
            ct = DBOperator.getConnection();
            sm = ct.createStatement();
            int pageNow = 1;
            if (s != null) {
                pageNow = Integer.parseInt(s);
            }
            int pageSize = 3;//每页显示几条记录
            rs = sm.executeQuery("select  *  from user  limit " + ((pageNow - 1) * pageSize) + "," + pageSize + "");
            while (rs.next()) {
                User u = new User();
                u.setUserid(rs.getString(1));
                u.setPassword(rs.getString(2));
                u.setUsername(rs.getString(3));
                users.add(u);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBOperator.close(rs, sm, ct);
        }
        return users;
    }

    @Override
    public int getPage(String s) {
        Connection ct = null;
        Statement sm = null;
        ResultSet rs = null;
        //查询总页数
        int pageCount = 0;//当前为第几页
        int pageSize = 3;//每页显示几条记录
        int rowCount = 0;//总共有多少条记录
        try {
            ct = DBOperator.getConnection();
            sm = ct.createStatement();
            rs = sm.executeQuery("select count(*) from user");
            if (rs.next()) {
                rowCount = rs.getInt(1);
                if (rowCount % pageSize == 0) {
                    pageCount = rowCount / pageSize;
                } else {
                    pageCount = rowCount / pageSize + 1;
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBOperator.close(rs, sm, ct);
        }
        return pageCount;
    }

​关于jsp页面的设置：

​其中的TransServlet是为了实现跳转的功能：

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String id = request.getParameter("transpage");
        if (id != null) {
            request.getRequestDispatcher("/index.jsp?pageNow=" + id).forward(request, response);
        }
    }