• SpringMVC-SSM整合/分页插件PageHelper案例

    目录

    一、Spring+Mybatis+SpringMVC

    1.1 依赖配置

    1.2 Web.xml

    1.3 SpringMVC.xml

    1.4 Spring.xml

    1.5 mybatis-config.xml

    1.6 log4j.xml

    1.7 jdbc.properties

    二、分页插件PageHelper

    2.1 配置

    2.2 使用

    2.3 Demo

    一、Spring+Mybatis+SpringMVC

            项目结构：

    1.1 依赖配置

    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0modelVersion>
    6.  
    7.     <groupId>org.examplegroupId>
    8.     <artifactId>SSM_2022artifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10. ------------------------------------------------------------------------------------
    11.     <properties>
    12.         <maven.compiler.source>8maven.compiler.source>
    13.         <maven.compiler.target>8maven.compiler.target>
    14.         <spring.version>5.3.1spring.version>
    15.     properties>
    16.  
    17.     <packaging>warpackaging>
    18.     <dependencies>
    19.     <dependency>
    20.         <groupId>org.springframeworkgroupId>
    21.         <artifactId>spring-contextartifactId>
    22.         <version>${spring.version}version>
    23.     dependency>
    24.     <dependency>
    25.         <groupId>org.springframeworkgroupId>
    26.         <artifactId>spring-beansartifactId>
    27.         <version>${spring.version}version>
    28.     dependency>
    29.     
    30.     <dependency>
    31.         <groupId>org.springframeworkgroupId>
    32.         <artifactId>spring-webartifactId>
    33.         <version>${spring.version}version>
    34.     dependency>
    35.     <dependency>
    36.         <groupId>org.springframeworkgroupId>
    37.         <artifactId>spring-webmvcartifactId>
    38.         <version>${spring.version}version>
    39.     dependency>
    40.     <dependency>
    41.         <groupId>org.springframeworkgroupId>
    42.         <artifactId>spring-jdbcartifactId>
    43.         <version>${spring.version}version>
    44.     dependency>
    45.     <dependency>
    46.         <groupId>org.springframeworkgroupId>
    47.         <artifactId>spring-aspectsartifactId>
    48.         <version>${spring.version}version>
    49.     dependency>
    50.     <dependency>
    51.         <groupId>org.springframeworkgroupId>
    52.         <artifactId>spring-testartifactId>
    53.         <version>${spring.version}version>
    54.     dependency>
    55.     
    56.     <dependency>
    57.         <groupId>org.mybatisgroupId>
    58.         <artifactId>mybatisartifactId>
    59.         <version>3.5.7version>
    60.     dependency>
    61.     
    62.     <dependency>
    63.         <groupId>org.mybatisgroupId>
    64.         <artifactId>mybatis-springartifactId>
    65.         <version>2.0.6version>
    66.     dependency>
    67.     
    68.     <dependency>
    69.         <groupId>com.alibabagroupId>
    70.         <artifactId>druidartifactId>
    71.         <version>1.0.9version>
    72.     dependency>
    73.     
    74.     <dependency>
    75.         <groupId>junitgroupId>
    76.         <artifactId>junitartifactId>
    77.         <version>4.12version>
    78.         <scope>testscope>
    79.     dependency>
    80.     
    81.     <dependency>
    82.         <groupId>mysqlgroupId>
    83.         <artifactId>mysql-connector-javaartifactId>
    84.         <version>8.0.16version>
    85.     dependency>
    86.     
    87.     <dependency>
    88.         <groupId>log4jgroupId>
    89.         <artifactId>log4jartifactId>
    90.         <version>1.2.17version>
    91.     dependency>
    92.     
    93.         <dependency>
    94.             <groupId>com.github.pagehelpergroupId>
    95.             <artifactId>pagehelperartifactId>
    96.             <version>5.2.0version>
    97.         dependency>
    98.         
    99.         <dependency>
    100.             <groupId>ch.qos.logbackgroupId>
    101.             <artifactId>logback-classicartifactId>
    102.             <version>1.2.3version>
    103.         dependency>
    104.         
    105.         <dependency>
    106.             <groupId>javax.servletgroupId>
    107.             <artifactId>javax.servlet-apiartifactId>
    108.             <version>3.1.0version>
    109.             <scope>providedscope>
    110.         dependency>
    111.         <dependency>
    112.             <groupId>com.fasterxml.jackson.coregroupId>
    113.             <artifactId>jackson-databindartifactId>
    114.             <version>2.12.1version>
    115.         dependency>
    116.         <dependency>
    117.             <groupId>commons-fileuploadgroupId>
    118.             <artifactId>commons-fileuploadartifactId>
    119.             <version>1.3.1version>
    120.         dependency>
    121.         
    122.         <dependency>
    123.             <groupId>org.thymeleafgroupId>
    124.             <artifactId>thymeleaf-spring5artifactId>
    125.             <version>3.0.12.RELEASEversion>
    126.         dependency>
    127.     dependencies>
    128.  
    129. project>

    1.2 Web.xml

            Spring提供了监听器ContextLoaderListener，实现ServletContextListener接口，可监听 ServletContext的状态，在web服务器启动时读取Spring的配置文件，创建Spring的IOC容器。Spring的IOC容器的创建必须早于SpringMVC的IOC容器的创建。

    2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
    5.          version="4.0">
    6.     
    7.     <filter>
    8.         <filter-name>CharacterEncodingFilterfilter-name>
    9.         <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    10.         <init-param>
    11.             <param-name>encodingparam-name>
    12.             <param-value>UTF-8param-value>
    13.         init-param>
    14.         <init-param>
    15.             <param-name>forceEncodingparam-name>
    16.             <param-value>trueparam-value>
    17.         init-param>
    18.     filter>
    19.     <filter-mapping>
    20.         <filter-name>CharacterEncodingFilterfilter-name>
    21.         <url-pattern>/*url-pattern>
    22.     filter-mapping>
    23.     
    24.     <filter>
    25.         <filter-name>HiddenHttpMethodFilterfilter-name>
    26.         <filter-class>org.springframework.web.filter.HiddenHttpMethodFilterfilter-class>
    27.     filter>
    28.     <filter-mapping>
    29.         <filter-name>HiddenHttpMethodFilterfilter-name>
    30.         <url-pattern>/*url-pattern>
    31.     filter-mapping>
    32.     
    33.     <servlet>
    34.         <servlet-name>DispatcherServletservlet-name>
    35.         <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    36.         
    37.         <init-param>
    38.             <param-name>contextConfigLocationparam-name>
    39.             <param-value>classpath:SpringMVC.xmlparam-value>
    40.         init-param>
    41.         <load-on-startup>1load-on-startup>
    42.     servlet>
    43.     <servlet-mapping>
    44.         <servlet-name>DispatcherServletservlet-name>
    45.         <url-pattern>/url-pattern>
    46.     servlet-mapping>
    47.  
    48.     
    49.     <listener>
    50.         <listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    51.     listener>
    52.     
    53.     <context-param>
    54.         <param-name>contextConfigLocationparam-name>
    55.         <param-value>classpath:Spring.xmlparam-value>
    56.     context-param>
    57. web-app>

    1.3 SpringMVC.xml

    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    6.  
    7.     
    8.     <context:component-scan base-package="ssm.controller"/>
    9.     
    10.     <bean id="viewResolver"
    11.           class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
    12.         <property name="order" value="1"/>
    13.         <property name="characterEncoding" value="UTF-8"/>
    14.         <property name="templateEngine">
    15.             <bean class="org.thymeleaf.spring5.SpringTemplateEngine">
    16.                 <property name="templateResolver">
    17.                     <bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
    18.                         
    19.                         <property name="prefix" value="/WEB-INF/templates/"/>
    20.                         
    21.                         <property name="suffix" value=".html"/>
    22.                         <property name="templateMode" value="HTML5"/>
    23.                         <property name="characterEncoding" value="UTF-8" />
    24.                     bean>
    25.                 property>
    26.             bean>
    27.         property>
    28.     bean>
    29.  
    30.     
    31.     <mvc:default-servlet-handler />
    32.     
    33.     <mvc:annotation-driven />
    34.     
    35.     <mvc:view-controller path="/" view-name="index"/>
    36.     
    37.     <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>
    38. beans>

    1.4 Spring.xml

     

    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    6. http://www.springframework.org/schema/beans/spring-beans.xsd
    7. http://www.springframework.org/schema/context
    8. https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    9.     
    10.     <context:component-scan base-package="ssm">
    11.         <context:exclude-filter type="annotation"
    12.                                 expression="org.springframework.stereotype.Controller"/>
    13.     context:component-scan>
    14.     
    15.     <context:property-placeholder location="classpath:jdbc.properties"/>
    16.     
    17.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    18.         <property name="driverClassName" value="${jdbc.driver}"/>
    19.         <property name="url" value="${jdbc.url}"/>
    20.         <property name="username" value="${jdbc.username}"/>
    21.         <property name="password" value="${jdbc.password}"/>
    22.     bean>
    23.  
    24.     
    25.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    26.         <property name="dataSource" ref="dataSource"/>
    27.     bean>
    28.     
    29.     <tx:annotation-driven transaction-manager="transactionManager"/>
    30.  
    31.     
    32.     <bean class="org.mybatis.spring.SqlSessionFactoryBean">
    33.         
    34.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
    35.         
    36.         <property name="dataSource" ref="dataSource"/>
    37.         
    38.         <property name="typeAliasesPackage" value="ssm.pojo"/>
    39.         
    40.         
    41.     bean>
    42.     
    43.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    44.         <property name="basePackage" value="ssm.mapper"/>
    45.     bean>
    46. beans>

    1.5 mybatis-config.xml

            有一些参数已经在spring配置文件里进行配置了。

    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.     <settings>
    7.         
    8.         <setting name="mapUnderscoreToCamelCase" value="true"/>
    9.     settings>
    10.     <plugins>
    11.         
    12.         <plugin interceptor="com.github.pagehelper.PageInterceptor"/>
    13.     plugins>
    14. configuration>

    1.6 log4j.xml

    2. log4j:configuration SYSTEM "log4j.dtd">
    3. <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    4.     <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
    5.         <param name="Encoding" value="UTF-8"/>
    6.         <layout class="org.apache.log4j.PatternLayout">
    7.             <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS}
    8. %m (%F:%L) \n"/>
    9.         layout>
    10.     appender>
    11.     <logger name="java.sql">
    12.         <level value="debug"/>
    13.     logger>
    14.     <logger name="org.apache.ibatis">
    15.         <level value="info"/>
    16.     logger>
    17.     <root>
    18.         <level value="debug"/>
    19.         <appender-ref ref="STDOUT"/>
    20.     root>
    21. log4j:configuration>

    1.7 jdbc.properties

    1. jdbc.username=root
    2. jdbc.password=310333
    3. jdbc.url=jdbc:mysql://localhost:3306/ssm_demodb?serverTimezone=UTC
    4. jdbc.driver=com.mysql.cj.jdbc.Driver

    二、分页插件PageHelper

    2.1 配置

            依赖：

    1. <dependency>
    2.     <groupId>com.github.pagehelpergroupId>
    3.     <artifactId>pagehelperartifactId>
    4.     <version>5.2.0version>
    5. dependency>

            在MyBatis的核心配置文件中配置插件：

    1. <plugins>
    3.     <plugin interceptor="com.github.pagehelper.PageInterceptor">plugin>
    4. plugins>

    2.2 使用

            1.在查询功能之前使用PageHelper.startPage(int pageNum, int pageSize)开启分页功能

            pageNum：当前页的页码

            pageSize：每页显示的条数 

            2.在查询获取list集合之后，使用PageInfo pageInfo = new PageInfo<>(List list, int navigatePages)获取分页相关数据  。

            list：分页之后的数据

            navigatePages：导航分页的页码数

             3.分页相关数据

    list：查询到的数据

    pageNum：当前页的页码

    pageSize：每页显示的条数

    size：当前页显示的真实条数

    total：总记录数

    pages：总页数

    prePage：上一页的页码

    nextPage：下一页的页码

    isFirstPage/isLastPage：是否为第一页/最后一页

    hasPreviousPage/hasNextPage：是否存在上一页/下一页

    navigatePages：导航分页的页码数

    navigatepageNums：导航分页的页码，[1,2,3,4,5]

    2.3 Demo

            数据库表：

    1. CREATE TABLE `t_emp` (
    2. `emp_id` int(11) NOT NULL AUTO_INCREMENT,
    3. `emp_name` varchar(20) DEFAULT NULL,
    4. `age` int(11) DEFAULT NULL,
    5. `sex` char(1) DEFAULT NULL,
    6. `email` varchar(50) DEFAULT NULL,
    7. PRIMARY KEY (`emp_id`)
    8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            pojo：

    1. package ssm.pojo;
    2.  
    3. public class Employee {
    4.     private Integer empId;
    5.     private String empName;
    6.     private Integer age;
    7.     private String sex;
    8.     private String email;
    9.     public Employee() {
    10.     }
    11.     public Employee(Integer empId, String empName, Integer age, String sex,
    12.                     String email) {
    13.         this.empId = empId;
    14.         this.empName = empName;
    15.         this.age = age;
    16.         this.sex = sex;
    17.         this.email = email;
    18.     }
    19.     public Integer getEmpId() {
    20.         return empId;
    21.     }
    22.     public void setEmpId(Integer empId) {
    23.         this.empId = empId;
    24.     }
    25.     public String getEmpName() {
    26.         return empName;
    27.     }
    28.     public void setEmpName(String empName) {
    29.         this.empName = empName;
    30.     }
    31.     public Integer getAge() {
    32.         return age;
    33.     }
    34.     public void setAge(Integer age) {
    35.         this.age = age;
    36.     }
    37.     public String getSex() {
    38.         return sex;
    39.  
    40.     }
    41.  
    42.     public void setSex(String sex) {
    43.         this.sex = sex;
    44.     }
    45.     public String getEmail() {
    46.         return email;
    47.     }
    48.     public void setEmail(String email) {
    49.         this.email = email;
    50.     }
    51. }

            Controller：

    1. @Controller
    2. public class EmployeeController {
    3.     @Autowired
    4.     private EmployeeService employeeService;
    5.  
    6.     /*查询所有员工信息（分页）*/
    7.     @RequestMapping(value = "/employee/page/{pageNum}",method = RequestMethod.GET)
    8.     public String getEmployeePage(@PathVariable("pageNum") Integer pageNum,Model model){
    9.         PageInfo page=employeeService.getEmployeePage(pageNum);//获取分页数据
    10.         model.addAttribute("page",page);//将分页数据保存到域中
    11.         return "employee_list";//转至员工列表页面
    12.     }
    13. }

             Service：

    1. public class EmployeeServiceImpl implements EmployeeService {
    2.     @Autowired
    3.     private EmployeeMapper employeeMapper;
    4.  
    5.     //获取所有员工信息
    6.     @Override
    7.     public List getAllEmployee() {
    8.         return employeeMapper.getAllEmployee();
    9.     }
    10.  
    11.     //获取所有员工信息的分页信息
    12.     @Override
    13.     public PageInfo getEmployeePage(Integer pageNum) {
    14.         //开启分页功能，每页显示4条数据
    15.         PageHelper.startPage(pageNum,4);
    16.         //查询所有员工信息
    17.         List list=employeeMapper.getAllEmployee();
    18.         //获取分页相关数据
    19.         return new PageInfo(list,5); //导航页显示5页
    20.     }
    21. }

            Mapper：

    1. public interface EmployeeMapper {
    2.     List getAllEmployee();
    3. }
    1. <mapper namespace="ssm.mapper.EmployeeMapper">
    2.     <select id="getAllEmployee" resultType="Employee">
    3.         select * from t_emp
    4.     select>
    5. mapper>

            employee_list页面（index页面自行设置）：

    1. html>
    2. <html lang="en" xmlns:th="http://www.thymeleaf.org">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>员工列表title>
    6. head>
    7. <body>
    8. <div align="center">
    9.     <table border="1" cellspacing="0" >
    10.         <tr>
    11.             <th colspan="6">员工信息th>
    12.         tr>
    13.         <tr>
    14.             <th>流水号th>
    15.             <th>姓名th>
    16.             <th>年龄th>
    17.             <th>性别th>
    18.             <th>邮箱th>
    19.             <th>操作th>
    20.         tr>
    21.         
    22.         
    23.         <tr th:each="employee,status : ${page.list}"> 
    24.             <td th:text="${status.count}">td>
    25.             <td th:text="${employee.empName}">td>
    26.             <td th:text="${employee.age}">td>
    27.             <td th:text="${employee.sex}">td>
    28.             <td th:text="${employee.email}">td>
    29.             <td>
    30.                 <a href="">删除a>
    31.                 <a href="">修改a>
    32.             td>
    33.         tr>
    34.     table>
    35. div>
    36. <div align="center">
    37.     <a th:if="${page.hasPreviousPage}" th:href="@{/employee/page/1}">首页a>
    38.     <a th:if="${page.hasPreviousPage}" th:href="@{'/employee/page/'+${page.prePage}}">上一页a>
    39.     <span th:each="num:${page.navigatepageNums}">
    40.         
    41.         <a th:if="${page.pageNum!=num}" th:href="@{'/employee/page/'+${num}}" th:text="${num}">a>
    42.         
    43.         <span th:if="${page.pageNum==num}" style="color:red " th:text="'['+${num}+']'">span>
    44.     span>
    45.     <a th:if="${page.hasNextPage}" th:href="@{'/employee/page/'+${page.nextPage}}">下一页a>
    46.     <a th:if="${page.hasNextPage}" th:href="@{'/employee/page/'+${page.pages}}">末页a>
    47. div>
    48. body>
    49. html>

            效果：

     

  • 相关阅读:
    C语言文件操作
    SpringBoot 入门
    【推荐系统】推荐系统基础算法-基于矩阵分解的推荐方法、隐语义模型
    利用IBERT IP核实现GTX收发器硬件误码率测试实例
    多模态模型
    React 入门：组件实例三大属性之refs
    YOLOv5小目标检测（方法与评价）
    python 数字类型
    Python中json.loads()无法解析单引号字符串问题的两种解决方法
    kubernetes集成GPU原理
  • 原文地址：https://blog.csdn.net/weixin_62427168/article/details/126082035