分页的代码

###page

public class PageBean<T> {
private int totalCount ; //数据总条数据
private int totalPage ;  //总页数
private int currPage ;   //当前页
private int rows ;        //每页显示数据条数
private List<T> list ;    //数据列表

生成get和set方法，及to string（）方法

###userserviceimp

public PageBean<User> findUserByPage(String currPage, String rows) {
        //1.处理参数
        int cp = Integer.parseInt(currPage);
        int rs = Integer.parseInt(rows);
        if(cp <=0) {
            cp = 1;
        }
        //2.调用dao查询总记录数
        int totalCount = dao.findTotalCount();
        //3.调用dao查询List集合
        //计算开始的记录索引
        int start = (cp - 1) * rs;
        List<User> list = dao.findByPage(start,rs);

    //4.计算总页码
    int totalPage = (int) Math.ceil(totalCount*1.0/rs);

    //5.创建空的PageBean对象
    PageBean<User> pb = new PageBean<User>();

    //6.设置分页数据

    pb.setCurrPage(cp);
    pb.setRows(rs);
    pb.setTotalCount(totalCount);
    pb.setList(list);
    pb.setTotalPage(totalPage);

    return pb;
}
}

##SQL

	@Override
	    public int findTotalCount() {
	        String sql = "select count(*) from user ";
	        return template.queryForObject(sql, Integer.class);
	    }

    @Override
    public List<User> findByPage(int start, int rs) {
        String sql = "select * from user limit ?,?";
        return template.query(sql,new BeanPropertyRowMapper<User>(User.class),start,rs);
    }
}

###servlet

	 //1.获取参数
        String currPage = request.getParameter("currPage");//当前页码
        String rows = request.getParameter("rs");//每页显示条数
        if(currPage == null || "".equals(currPage)){
            currPage = "1";
        }

        if(rows == null || "".equals(rows)){
            rows = "5";
        }

    //2.调用service查询
    UserService service = new UserServiceImp();
    PageBean<User> pb = service.findUserByPage(currPage,rows);
    System.out.println(pb);
    //3.将PageBean存入request
    request.setAttribute("pb",pb);
    //4.转发到list.jsp
    request.getRequestDispatcher("/list.jsp").forward(request,response);
}