SSM使用PageHelper分页
1.准备表和数据
CREATE TABLE `goods` (
`goods_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
`goods_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
`goods_type` varchar(255) DEFAULT NULL COMMENT '商品分类',
`goods_price` double(255,0) DEFAULT NULL COMMENT '商品单价',
`goods_count` int(11) DEFAULT NULL COMMENT '商品数量',
PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2. 新建Maven工程
3. 配置
db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/ssm?characterEncoding=utf8&useSSL=true
username=root
password=123456
initialSize=5
maxActive=20
maxIdle=20
minIdle=1
maxWait=60000
log4j.properties
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.err
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:\mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=DEBUG, stdout
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:db.properties" />
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"></property>
</bean>
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations"
value="classpath:pers/zhang/dao/*.xml"></property>
<!-- 配置分页插件 -->
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageHelper">
<property name="properties">
<value>
dialect=mysql
reasonable=true
</value>
</property>
</bean>
</array>
</property>
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="pers.zhang.dao" />
</bean>
<!-- 事务管理-->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<context:component-scan base-package="pers.zhang" />
<!-- 定义跳转的文件的前后缀 ,视图模式配置 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
</beans>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<!-- 1.配置加载Spring文件的监听器 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<!-- 2.编码过滤器 -->
<filter>
<filter-name>encoding</filter-name>
<filter-class>
org.springframework.web.filter.CharacterEncodingFilter
</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/</url-pattern>
</filter-mapping>
<!-- 3.配置SpringMVC前端核心控制器 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>
org.springframework.web.servlet.DispatcherServlet
</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<!-- 4.服务器启动后立即加载SpringMVC配置文件 -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
</web-app>
4. 编码
po:Goods.java
package pers.zhang.po;
public class Goods {
private Integer goods_id;
private String goods_name;
private String goods_type;
private Double goods_price;
private Integer goods_count;
public Integer getGoods_id() {
return goods_id;
}
public void setGoods_id(Integer goods_id) {
this.goods_id = goods_id;
}
public String getGoods_name() {
return goods_name;
}
public void setGoods_name(String goods_name) {
this.goods_name = goods_name;
}
public String getGoods_type() {
return goods_type;
}
public void setGoods_type(String goods_type) {
this.goods_type = goods_type;
}
public Double getGoods_price() {
return goods_price;
}
public void setGoods_price(Double goods_price) {
this.goods_price = goods_price;
}
public Integer getGoods_count() {
return goods_count;
}
public void setGoods_count(Integer goods_count) {
this.goods_count = goods_count;
}
}
controller层:GoodsController.java
package pers.zhang.controller;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import pers.zhang.po.Goods;
import pers.zhang.service.GoodsService;
@Controller
public class GoodsController {
@Resource(name="goodsService")
private GoodsService goodsService;
@RequestMapping("goods.do")
public String userList(@RequestParam(required=true,defaultValue="1") Integer page,
Model model){
//PageHelper.startPage(page, pageSize);这段代码表示,程序开始分页了,
//page默认值是1,pageSize默认是10,意思是从第1页开始,每页显示10条记录。
PageHelper.startPage(page, 3);
//查询
List<Goods> goods = goodsService.queryAll();
//创建PageInfo对象,保存查询出的结果,PageInfo是pageHelper中的对象
PageInfo<Goods> p=new PageInfo<Goods>(goods);
model.addAttribute("page", p);
model.addAttribute("goods", goods);
//返回页面
return "show";
}
}
service层:GoodsService.java
package pers.zhang.service;
import java.util.List;
import pers.zhang.po.Goods;
public interface GoodsService {
List<Goods> queryAll();//查询所有
}
GoodsServiceImpl.java
package pers.zhang.service;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import pers.zhang.dao.GoodsDao;
import pers.zhang.po.Goods;
@Service("goodsService")
public class GoodsServiceImpl implements GoodsService{
@Resource
private GoodsDao goodsDao;
public List<Goods> queryAll() {
return goodsDao.queryAll();
}
}
dao层:GoodsDao.java
package pers.zhang.dao;
import java.util.List;
import pers.zhang.po.Goods;
public interface GoodsDao {
List<Goods> queryAll();
}
GoodsDao.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">
<!-- namespace的值是dao层接口的全路径 -->
<mapper namespace="pers.zhang.dao.GoodsDao">
<!-- 配置实体类与数据表映射关系
type:实体类全路径
id:名字
-->
<resultMap type="pers.zhang.po.Goods" id="goodsMap">
<!--
id标签:配置唯一字段,一般是主键
property:与实体类属性名一致
column:与数据表字段名一致
-->
<id property="goods_id" column="goods_id"/>
<!-- result标签配置非唯一字段 -->
<result property="goods_name" column="goods_name"/>
<result property="goods_type" column="goods_type"/>
<result property="goods_price" column="goods_price"/>
<result property="goods_count" column="goods_count"/>
</resultMap>
<!-- 定义表中字段 -->
<sql id="key">GOODS_ID,GOODS_NAME,GOODS_TYPE,GOODS_PRICE,GOODS_COUNT</sql>
<!-- 查询语句,查询所有
resultMap:与上边的resultMap标签的id属性值一致,将查出的数据按照配置的对应关系,封装到实体类中
-->
<select id="queryAll" resultMap="goodsMap">
SELECT <include refid="key"/> FROM GOODS
</select>
</mapper>
5. 页面
show.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>
<html>
<head>
<meta charset="UTF-8">
<title>商品列表</title>
</head>
<body>
<div align="center">
<table border="1" cellspacing="0">
<caption>商品列表</caption>
<tbody>
<tr>
<td>商品编号</td>
<td>商品名称</td>
<td>商品类型</td>
<td>商品价格</td>
<td>剩余数量</td>
</tr>
<c:forEach items="${goods }" var="good">
<tr>
<td>${good.goods_id }</td>
<td>${good.goods_name }</td>
<td>${good.goods_type }</td>
<td>${good.goods_price }</td>
<td>${good.goods_count }</td>
</tr>
</c:forEach>
</tbody>
</table>
<p>一共${page.pages}页</p>
<a href="goods.do?page=${page.firstPage}">第一页</a> <a
href="goods.do?page=${page.nextPage}">下一页</a> <a
href="goods.do?page=${page.prePage}">上一页</a> <a
href="goods.do?page=${page.lastPage}">最后页</a>
</div>
</body>
</html>
6. 测试