本案例的开发环境为：mysql + idea + jdk1.8 + Tomcat9
2.目录结构 3.数据库的表设计
package JavaBean;
import java.util.List;
public class pageBean {
private int pageNumber;
private int pageSize;
private int totalCount;
private int totalPage;
private List
4.2 userDao
public class userDao {
//所有用户数量
public int selectUserCount() throws SQLException {
QueryRunner r = new QueryRunner(DBUtil.getDs());
String sql = "select count(*) from user";
return r.query(sql, new ScalarHandler()).intValue();
}
//分页显示用户信息
public List selectUserList(int pageNo, int pageSize) throws SQLException {
QueryRunner r = new QueryRunner(DBUtil.getDs());
String sql = "select * from user limit ?,?";
return r.query(sql, new BeanListHandler(UserBean.class), (pageNo-1)*pageSize,pageSize );
}
}
4.3 UserService
public class UserService {
private static userDao userDao = new userDao();
public static pageBean getUserPage(int pageNumber) {
pageBean p = new pageBean();
p.setPageNumber(pageNumber);
int pageSize = 3;
int totalCount = 0;
try {
totalCount = userDao.selectUserCount();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
p.SetPageSizeAndTotalCount(pageSize, totalCount);
List list=null;
try {
list = userDao.selectUserList( pageNumber, pageSize);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
p.setList(list);
return p;
}
}
4.4 UserListServlet
@WebServlet(name = "UserListServlet",urlPatterns = "/UserListServlet")
public class UserListServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int pageNumber = 1;
if(request.getParameter("pageNumber") != null) {
try {
pageNumber=Integer.parseInt(request.getParameter("pageNumber") ) ;
}
catch (Exception e)
{
}
}
if(pageNumber<=0)
pageNumber=1;
pageBean p = UserService.getUserPage(pageNumber);
if(p.getTotalPage()==0)
{
p.setTotalPage(1);
p.setPageNumber(1);
}
else {
if(pageNumber>=p.getTotalPage()+1)
{
p = UserService.getUserPage(pageNumber);
}
}
request.setAttribute("p", p);
request.getRequestDispatcher("/userList.jsp").forward(request, response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
}
4.4 page.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
disabled href="${param.url }?pageNumber=1${param.param }" >首页
disabled href="${pageContext.request.contextPath }${param.url }?pageNumber=${p.pageNumber-1}${param.param }" >上一页
[${p.pageNumber }/${p.totalPage }]
[${p.totalCount }]
disabled href="${param.url }?pageNumber=${p.pageNumber+1}${param.param }" >下一页
disabled href="${param.url }?pageNumber=${p.totalPage}${param.param }" >尾页
GO
4.5 userList.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
Title
5.运行效果
