五、Mybatis分页处理及简单实现

MyBatis使用mysql实现分页：

实体类：

People.java:

package com.tao.pojo;

public class People {
	
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "People [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
}

PageBean.java:

package com.tao.pojo;

import java.util.List;

public class PageBean {
	private int pageSize;	//每页条数
	private int pageNumber;	//当前第几页
	private long total;		//总页数
	private List<?> list;	//分页显示数据
	
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public int getPageNumber() {
		return pageNumber;
	}
	public void setPageNumber(int pageNumber) {
		this.pageNumber = pageNumber;
	}
	public long getTotal() {
		return total;
	}
	public void setTotal(long total) {
		this.total = total;
	}
	public List<?> getList() {
		return list;
	}
	public void setList(List<?> list) {
		this.list = list;
	}
	
	
}

PeopleMapper.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.tao.mapper.PeopleMapper">
	
	<!-- 分页查询 -->
	<select id="selectByPage" resultType="People" parameterType="map">
		select * from people limit #{pageStart},#{pageSize}
	</select>
	
	<!-- 查询总记录数 -->
	<select id="selectTotalPeople" resultType="long">
		select count(*) from people
	</select>
	
</mapper>

PeopleService接口：

package com.tao.service;

import java.io.IOException;
import java.util.List;

import com.tao.pojo.PageBean;
import com.tao.pojo.People;

public interface PeopleService {
	
	/**
	 * 分页显示
	 * @param pageSize
	 * @param pageNumber
	 * @return
	 * @throws IOException 
	 */
	PageBean showPage(int pageSize,int pageNumber) throws IOException;

}

PeopleServiceImpl实现类：

package com.tao.service.impl;

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.tao.pojo.PageBean;
import com.tao.pojo.People;
import com.tao.service.PeopleService;

public class PeopleServiceImpl implements PeopleService{

	@Override
	public PageBean showPage(int pageSize, int pageNumber) throws IOException {
		InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
		SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		SqlSession session = sessionFactory.openSession();
		
		PageBean p = new PageBean();
		p.setPageNumber(pageNumber);
		p.setPageSize(pageSize);
		
		Map<String, Object> pageMap = new HashMap<>();
		pageMap.put("pageStart", pageSize*(pageNumber-1));
		pageMap.put("pageSize", pageSize);
		p.setList(session.selectList("com.tao.mapper.PeopleMapper.selectByPage", pageMap));
		
		long count = session.selectOne("com.tao.mapper.PeopleMapper.selectTotalPeople");
		p.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1);
		return p;
	}

}

ShowPageServlet 控制层:

package com.tao.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.tao.pojo.PageBean;
import com.tao.service.PeopleService;
import com.tao.service.impl.PeopleServiceImpl;

@WebServlet("/page")
public class ShowPageServlet extends HttpServlet{

	private static final long serialVersionUID = 1L;
	
	private PeopleService peopleService = new PeopleServiceImpl();
	
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		int pageNumber = 1;
		int pageSize = 2;
		String pageSizeStr = req.getParameter("pageSize");
		String pageNumberStr = req.getParameter("pageNumber");
		
		if(pageSizeStr!=null && !pageSizeStr.equals("")){
			pageSize = Integer.parseInt(pageSizeStr);
		}
		if(pageNumberStr!=null && !pageNumberStr.equals("")){
			pageNumber = Integer.parseInt(pageNumberStr);
		}
		
		PageBean p = peopleService.showPage(pageSize, pageNumber);
		req.setAttribute("pageBean", p);
		req.getRequestDispatcher("/page.jsp").forward(req, resp);
		
	}
	
}

page.jsp页面：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table border="1">
		<tr>
			<th>编号</th>
			<th>姓名</th>
			<th>年龄</th>
		</tr>
		
		<c:forEach items="${pageBean.list}" var="p">
			<tr>
				<td>${p.id }</td>
				<td>${p.name }</td>
				<td>${p.age }</td>
			</tr>
		</c:forEach>
	</table>
	<a href="page?pageNumber=${pageBean.pageNumber-1 }&pageSize=${pageBean.pageSize}" <c:if test="${pageBean.pageNumber<=1 }">  onclick="javascript:return false;" </c:if> >上一页</a>
	<a href="page?pageNumber=${pageBean.pageNumber+1 }&pageSize=${pageBean.pageSize}" <c:if test="${pageBean.pageNumber>=pageBean.total }">  onclick="javascript:return false;" </c:if> >下一页</a>
</body>
</html>

页面效果：