一.新建web项目
二.写实体类
pojo的包下的People.java
package com.bjsxt.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 + "]";
}
}
三.导入相关jar包
四.在src下新建全局配置文件
mybatis.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.bjsxt.pojo"/>
</typeAliases>
<environments default="default">
<environment id="default">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
<property name="username" value="root"/>
<property name="password" value="smallming"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/bjsxt/mapper/PeopleMapper.xml"/>
</mappers>
</configuration>
五.新建mapper包
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.bjsxt.mapper.PeopleMapper">
<select id="selByPage" resultType="people" parameterType="map">
select * from people limit #{pageStart},#{pageSize}
</select>
<select id="selCount" resultType="long">
select count(*) from people
</select>
</mapper>
六.为了代码简洁,新建PageInfo类
PageInfo.java
package com.bjsxt.pojo;
import java.util.List;
public class PageInfo {
//每页显示个数
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;
}
}
七.新建service包
PeopleService.java
package com.bjsxt.service;
import java.io.IOException;
import com.bjsxt.pojo.PageInfo;
public interface PeopleService {
/**
* 分页显示
* @param pageSize
* @param pageNumber
* @return
*/
PageInfo showPage(int pageSize,int pageNumber) throws IOException;
}
八.新建service.impl包
PeopleServiceImpl.java
package com.bjsxt.service.impl;
import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
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.bjsxt.pojo.PageInfo;
import com.bjsxt.service.PeopleService;
public class PeopleServiceImpl implements PeopleService {
@Override
public PageInfo showPage(int pageSize, int pageNumber) throws IOException {
InputStream is = Resources.getResourceAsStream("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
SqlSession session = factory.openSession();
PageInfo pi = new PageInfo();
pi.setPageNumber(pageNumber);
pi.setPageSize(pageSize);
Map<String,Object> map =new HashMap<>();
map.put("pageStart",pageSize*(pageNumber-1));
map.put("pageSize", pageSize);
pi.setList(session.selectList("com.bjsxt.mapper.PeopleMapper.selByPage",map));
//总条数
long count = session.selectOne("com.bjsxt.mapper.PeopleMapper.selCount");
pi.setTotal(count%pageSize==0?count/pageSize:count/pageSize+1);
return pi;
}
}
九.新建servlet包
ShowPageServlet.java
package com.bjsxt.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.bjsxt.pojo.PageInfo;
import com.bjsxt.service.PeopleService;
import com.bjsxt.service.impl.PeopleServiceImpl;
@WebServlet("/page")
public class ShowPageServlet extends HttpServlet{
private PeopleService peopleService = new PeopleServiceImpl();
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
//第一次访问的验证,如果没有传递参数,设置默认值
String pageSizeStr = req.getParameter("pageSize");
int pageSize = 2;//默认
if(pageSizeStr!=null&&!pageSizeStr.equals("")){
pageSize = Integer.parseInt(pageSizeStr);
}
String pageNumberStr = req.getParameter("pageNumber");
int pageNumber = 1;//默认
if(pageNumberStr!=null&&!pageNumberStr.equals("")){
pageNumber = Integer.parseInt(pageNumberStr);
}
PageInfo pi = peopleService.showPage(pageSize, pageNumber);
req.setAttribute("PageInfo", pi);
req.getRequestDispatcher("index.jsp").forward(req, resp);
}
}
十.新建index.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="${PageInfo.list }" var="pi">
<tr>
<td>${pi.id }</td>
<td>${pi.name }</td>
<td>${pi.age }</td>
</tr>
</c:forEach>
</table>
<a href="page?pageNumber=${PageInfo.pageNumber-1 }&pageSize=${PageInfo.pageSize}" <c:if test="${PageInfo.pageNumber<=1 }"> onclick="javascript:return false;" </c:if> >上一页</a>
<a href="page?pageNumber=${PageInfo.pageNumber+1 }&pageSize=${PageInfo.pageSize}" <c:if test="${PageInfo.pageNumber>=PageInfo.total }"> onclick="javascript:return false;" </c:if> >下一页</a>
</body>
</html>