ssm+maven+pageHelper搭建maven项目实现快速分页

时间：2023-03-09 15:57:50
ssm+maven+pageHelper搭建maven项目实现快速分页

ssm+maven+pageHelper搭建maven项目实现快速分页

PageHelper分页使用:

插件的环境引入：

1.pom文件中引入分页插件的资源位置：

<dependency>

            <groupId>com.github.pagehelper</groupId>

            <artifactId>pagehelper</artifactId>

            <version>4.1.6</version>

</dependency>

2.在mybatis的spring配置文件中引入插件：

<!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource" />

        <!-- 自动扫描mapping.xml文件 -->

        <property name="mapperLocations" value="classpath:com/ithaha/mapper/*.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>

项目结构如下：

ssm+maven+pageHelper搭建maven项目实现快速分页

pom.xml :

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0

          http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>com.dengwei</groupId>

    <artifactId>demo2</artifactId>

    <packaging>pom</packaging>

    <version>1.0-SNAPSHOT</version>

    <properties>

            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

            <!-- spring版本号 -->

            <spring.version>4.2.5.RELEASE</spring.version>

            <!-- mybatis版本号 -->

            <mybatis.version>3.2.8</mybatis.version>

            <!-- mysql驱动版本号 -->

            <mysql-driver.version>5.1.29</mysql-driver.version>

            <!-- log4j日志包版本号 -->

            <slf4j.version>1.7.18</slf4j.version>

            <log4j.version>1.2.17</log4j.version>

        </properties>

        <dependencies>

            <!-- 添加jstl依赖 -->

            <dependency>

                <groupId>jstl</groupId>

                <artifactId>jstl</artifactId>

                <version>1.2</version>

            </dependency>

            <dependency>

                <groupId>javax</groupId>

                <artifactId>javaee-api</artifactId>

                <version>7.0</version>

            </dependency>

            <!-- 添加junit4依赖 -->

            <dependency>

                <groupId>junit</groupId>

                <artifactId>junit</artifactId>

                <version>4.11</version>

                <!-- 指定范围，在测试时才会加载 -->

                <scope>test</scope>

            </dependency>

            <!-- 添加spring核心依赖 -->

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-core</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-web</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-oxm</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-tx</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-jdbc</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-webmvc</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-context</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-context-support</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-aop</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <dependency>

                <groupId>org.springframework</groupId>

                <artifactId>spring-test</artifactId>

                <version>${spring.version}</version>

            </dependency>

            <!-- 添加mybatis依赖 -->

            <dependency>

                <groupId>org.mybatis</groupId>

                <artifactId>mybatis</artifactId>

                <version>${mybatis.version}</version>

            </dependency>

            <!-- 添加mybatis/spring整合包依赖 -->

            <dependency>

                <groupId>org.mybatis</groupId>

                <artifactId>mybatis-spring</artifactId>

                <version>1.2.2</version>

            </dependency>

            <!-- 添加mysql驱动依赖 -->

            <dependency>

                <groupId>mysql</groupId>

                <artifactId>mysql-connector-java</artifactId>

                <version>${mysql-driver.version}</version>

            </dependency>

            <!-- 添加数据库连接池依赖 -->

            <dependency>

                <groupId>commons-dbcp</groupId>

                <artifactId>commons-dbcp</artifactId>

                <version>1.2.2</version>

            </dependency>

            <!-- 添加fastjson -->

            <dependency>

                <groupId>com.alibaba</groupId>

                <artifactId>fastjson</artifactId>

                <version>1.1.41</version>

            </dependency>

            <!-- 添加日志相关jar包 -->

            <dependency>

                <groupId>log4j</groupId>

                <artifactId>log4j</artifactId>

                <version>${log4j.version}</version>

            </dependency>

            <dependency>

                <groupId>org.slf4j</groupId>

                <artifactId>slf4j-api</artifactId>

                <version>${slf4j.version}</version>

            </dependency>

            <dependency>

                <groupId>org.slf4j</groupId>

                <artifactId>slf4j-log4j12</artifactId>

                <version>${slf4j.version}</version>

            </dependency>

            <!-- log end -->

            <!-- 映入JSON -->

            <dependency>

                <groupId>org.codehaus.jackson</groupId>

                <artifactId>jackson-mapper-asl</artifactId>

                <version>1.9.13</version>

            </dependency>

            <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->

            <dependency>

                <groupId>com.fasterxml.jackson.core</groupId>

                <artifactId>jackson-core</artifactId>

                <version>2.8.0</version>

            </dependency>

            <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->

            <dependency>

                <groupId>com.fasterxml.jackson.core</groupId>

                <artifactId>jackson-databind</artifactId>

                <version>2.8.0</version>

            </dependency>

            <dependency>

                <groupId>commons-fileupload</groupId>

                <artifactId>commons-fileupload</artifactId>

                <version>1.3.1</version>

            </dependency>

            <dependency>

                <groupId>commons-io</groupId>

                <artifactId>commons-io</artifactId>

                <version>2.4</version>

            </dependency>

            <dependency>

                <groupId>commons-codec</groupId>

                <artifactId>commons-codec</artifactId>

                <version>1.9</version>

            </dependency>

            <dependency>

                <groupId>junit</groupId>

                <artifactId>junit</artifactId>

                <version>4.12</version>

                <scope>compile</scope>

            </dependency>

            <!--分页插件-->

            <dependency>

                <groupId>com.github.pagehelper</groupId>

                <artifactId>pagehelper</artifactId>

                <version>4.1.6</version>

            </dependency>

            <dependency>

                <groupId>org.aspectj</groupId>

                <artifactId>aspectjweaver</artifactId>

                <version>1.8.7</version>

            </dependency>

        </dependencies>

</project>

springConfig.xm:

 <?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:tx="http://www.springframework.org/schema/tx"

        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/tx

                             http://www.springframework.org/schema/tx/spring-tx.xsd

                             http://www.springframework.org/schema/mvc

                             http://www.springframework.org/schema/mvc/spring-mvc.xsd">

     <!--开启注解-->

     <mvc:annotation-driven/>

     <!-- 自动扫描 -->

     <context:component-scan base-package="com.dengwei.controller,com.dengwei.service.impl"/>

     <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

         <property name="locations">

             <list>

                 <value>classpath*:jdbc.properties</value>

             </list>

         </property>

     </bean>

     <!-- 配置数据源 -->

     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

           destroy-method="close">

         <property name="driverClassName" value="${driverClasss}"/>

         <property name="url" value="${jdbcUrl}"/>

         <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>

     <!-- mybatis和spring完美整合，不需要mybatis的配置映射文件 -->

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

         <property name="dataSource" ref="dataSource"/>

         <!-- 自动扫描mapping.xml文件 -->

         <property name="mapperLocations" value="classpath:mapping/*Mapper.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="com.dengwei.dao"/>

         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>

     </bean>

     <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->

     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

         <property name="dataSource" ref="dataSource"/>

     </bean>

     <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->

     <tx:annotation-driven transaction-manager="transactionManager"/>

 </beans>

jdbc.properties :

 driverClasss=com.mysql.jdbc.Driver

 jdbcUrl=jdbc:mysql://localhost:3306/testsql

 username=root

 password=admin

 #定义初始连接数

 initialSize=0

 #定义最大连接数

 maxActive=20

 #定义最大空闲

 maxIdle=20

 #定义最小空闲

 minIdle=1

 #定义最长等待时间

 maxWait=60000

log4j.properties :

 log4j.rootLogger=INFO,Console,File

 #控制台日志

 log4j.appender.Console=org.apache.log4j.ConsoleAppender

 log4j.appender.Console.Target=System.out

 log4j.appender.Console.layout=org.apache.log4j.PatternLayout

 log4j.appender.Console.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n

 #普通文件日志

 log4j.appender.File=org.apache.log4j.RollingFileAppender

 log4j.appender.File.File=logs/ssm.log

 log4j.appender.File.MaxFileSize=10MB

 #输出日志，如果换成DEBUG表示输出DEBUG以上级别日志

 log4j.appender.File.Threshold=ALL

 log4j.appender.File.layout=org.apache.log4j.PatternLayout

 log4j.appender.File.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n

web.xml :

注意：在idea我的web.xml中有爆红的，但是不影响程序运行。

 <?xml version="1.0" encoding="UTF-8"?>

 <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"

          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

          version="3.1">

     <!--添加过滤器-->

     <filter>

         <filter-name>characterEncodingFilter</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>

         <init-param>

             <param-name>forceEncoding</param-name>

             <param-value>true</param-value>

         </init-param>

     </filter>

     <filter-mapping>

         <filter-name>characterEncodingFilter</filter-name>

         <url-pattern>/*</url-pattern>

     </filter-mapping>

     <!--配置spring-->

     <servlet>

         <servlet-name>dispatcherServlet</servlet-name>

         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

         <init-param>

             <param-name>contextConfigLocation</param-name>

             <param-value>classpath:springConfig.xml</param-value>

         </init-param>

     </servlet>

     <servlet-mapping>

         <servlet-name>dispatcherServlet</servlet-name>

         <url-pattern>/</url-pattern>

     </servlet-mapping>

     <!--自定义首页-->

     <!--  <welcome-file-list>

           <welcome-file>/first/page</welcome-file>

       </welcome-file-list>-->

     <!--读取静态文件-->

     <servlet-mapping>

         <servlet-name>default</servlet-name>

         <url-pattern>*.js</url-pattern>

         <url-pattern>*.css</url-pattern>

         <url-pattern>*.woff</url-pattern>

         <url-pattern>*.woff2</url-pattern>

         <url-pattern>*.ttf</url-pattern>

         <url-pattern>*.png</url-pattern>

         <url-pattern>*.jpg</url-pattern>

         <url-pattern>*.ogg</url-pattern>

         <url-pattern>*.mp4</url-pattern>

     </servlet-mapping>

 </web-app>

下面我们看一下分页的实现，这里我只贴了Cotroller层的代码：

ssm+maven+pageHelper搭建maven项目实现快速分页

 controller：

package com.dengwei.controller;

import com.dengwei.model.ProductAndResource;

import com.dengwei.service.IProductService;

import com.github.pagehelper.PageHelper;

import com.github.pagehelper.PageInfo;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller

@RequestMapping("/list")

public class ProductController {

    @Autowired

    private IProductService productService;

    @RequestMapping("/product")

    @ResponseBody

    public PageInfo<ProductAndResource> productList(Integer currentPage, Integer pageSize){

            //  PageHelper.startPage(currentPage,currentPage);必须在上面才能实现分页

             PageHelper.startPage(currentPage,pageSize);

        List<ProductAndResource> list = productService.queryProductInfo();

            PageInfo  pageInfo= new PageInfo(list);

           return  pageInfo; 
} 
}

最终返回给前端的是PageInfo对象：

3.PageInfo类说明

 public class PageInfo<T> implements Serializable {

     private static final long serialVersionUID = 1L;

     //当前页

     private int pageNum;

     //每页的数量

     private int pageSize;

     //当前页的数量

     private int size;  

     //由于startRow和endRow不常用，这里说个具体的用法

     //可以在页面中"显示startRow到endRow 共size条数据"  

     //当前页面第一个元素在数据库中的行号

     private int startRow;

     //当前页面最后一个元素在数据库中的行号

     private int endRow;

     //总记录数

     private long total;

     //总页数

     private int pages;

     //结果集

     private List<T> list;  

     //前一页

     private int prePage;

     //下一页

     private int nextPage;  

     //是否为第一页

     private boolean isFirstPage = false;

     //是否为最后一页

     private boolean isLastPage = false;

     //是否有前一页

     private boolean hasPreviousPage = false;

     //是否有下一页

     private boolean hasNextPage = false;

     //导航页码数

     private int navigatePages;

     //所有导航页号

     private int[] navigatepageNums;

     //导航条上的第一页

     private int navigateFirstPage;

     //导航条上的最后一页

     private int navigateLastPage;  

     public PageInfo() {

     }  

     /**

      * 包装Page对象

      *

      * @param list

      */

     public PageInfo(List<T> list) {

         this(list, 8);

     }  

     /**

      * 包装Page对象

      *

      * @param list          page结果

      * @param navigatePages 页码数量

      */

     public PageInfo(List<T> list, int navigatePages) {

         if (list instanceof Page) {

             Page page = (Page) list;

             this.pageNum = page.getPageNum();

             this.pageSize = page.getPageSize();  

             this.pages = page.getPages();

             this.list = page;

             this.size = page.size();

             this.total = page.getTotal();

             //由于结果是>startRow的，所以实际的需要+1

             if (this.size == 0) {

                 this.startRow = 0;

                 this.endRow = 0;

             } else {

                 this.startRow = page.getStartRow() + 1;

                 //计算实际的endRow（最后一页的时候特殊）

                 this.endRow = this.startRow - 1 + this.size;

             }

         } else if (list instanceof Collection) {

             this.pageNum = 1;

             this.pageSize = list.size();  

             this.pages = this.pageSize > 0 ? 1 : 0;

             this.list = list;

             this.size = list.size();

             this.total = list.size();

             this.startRow = 0;

             this.endRow = list.size() > 0 ? list.size() - 1 : 0;

         }

         if (list instanceof Collection) {

             this.navigatePages = navigatePages;

             //计算导航页

             calcNavigatepageNums();

             //计算前后页，第一页，最后一页

             calcPage();

             //判断页面边界

             judgePageBoudary();

         }

     }  

 .......

 }

二、上述在方法是在方法内部针对当前方法进行分页，如果想针对指定以某个单词结尾的所有方法分页，可以使用拦截器：

1：上面的配置不变（导入依赖、spring配置文件中引入插件）

2：   编写拦截器（规定以paging结尾的方法就是分页的方法，拦截controller层中以paging为结尾的方法）

依赖：

 <dependency>

                <groupId>org.aspectj</groupId>

                <artifactId>aspectjweaver</artifactId>

                <version>1.8.7</version>

            </dependency>
PageInterceptor ：
@Aspect

@Component

public class PageInterceptor {

    @Around("execution(* com.ithaha.controller..*.*Paging(..))")

    public Object process(ProceedingJoinPoint point) throws Throwable {

        Object[] args = point.getArgs();

        if(args.length<2) {

            //规定原方法的参数最后两个是当前页和每页条数

            throw new Exception("参数不够分页");

        }

        PageHelper.startPage((Integer)args[args.length-2],(Integer)args[args.length-1]);

        List list = (List) point.proceed();

        PageInfo pageInfo = new PageInfo(list);

        return pageInfo;

    }

}

只要你想分页，只需满足：1.方法名字以paging结尾 .2.方法参数最后两个是当前页和每页条数

相关文章