• MyBatis与Spring的集成

    目录

    一、mybatis与spring集成

            1.1 IDEA中创建Maven项目

    1.2 集成mybatis&&spring（ssm整合）

            1.2.2 建立配置文件

            1.2.3 逆向自动生成代码

     二、aop整合分页插件PageHelper

    上诉配置要生效，

    代理注释一定要打开：

    一、mybatis与spring集成

            1.1 IDEA中创建Maven项目

                    1.1.1 右键New一个module ---> 选择Maven

                    

    1.1.2 选择自己自己的jdk版本 ---> 勾选Create from archetype --->

    英文输入法输入webapp 找到：org.apache.maven.archetypes:maven-archetype-webapp

    1.1.3 设置要建立的项目名 ---> 建立项目的位置 ---> Next

    1.1.4 

    1、选择自己Maven的安装目录，记得要选择bin目录的上一层；

    2、勾选Override，如果settings.xml的安装目录不是实际上自己的settings.xml安装目录的话，

    那就手动定位选择一下；

    3、点击 + 号添加一个配置，依次填入：archetypeCatalog && internal

    4、Finish

    1.1.5 直到出现BUILD SUCCESS，就代表你的Maven项目创建成功啦！ 

            小笔记：idea右侧点击Maven，出现的一列命令。

                    test命令：

    test命令：

                    ① 用来检测当前项目所有相关pom依赖是否下载成功；

                    ② 用来检测当前项目所有pom依赖是否有版本冲突；

            maven clean命令：

            清除这个依赖： 

     clean命令：

                    ① 清除本地（idea）pom依赖

    一般先执行clean，再执行test命令。 

    1.2 集成mybatis&&spring（ssm整合）

            集成步骤：

            1.2.1 导入pom依赖

                    

    1 添加spring相关依赖(5.0.2.RELEASE)

    2 添加mybatis相关依赖

    3 spring整合mybatis(1.3.1)

    4 添加dbcp2连接池

    5 添加日志配置(2.9.1)

     pom依赖文件：

    1. <properties>
    2.     <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    3.     <maven.compiler.source>1.8maven.compiler.source>
    4.     <maven.compiler.target>1.8maven.compiler.target>
    5.     <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
    6.  
    7.     
    8.     
    9.     <spring.version>5.0.2.RELEASEspring.version>
    10.     
    11.     <mybatis.version>3.4.5mybatis.version>
    12.     
    13.     <mysql.version>5.1.44mysql.version>
    14.     
    15.     <pagehelper.version>5.1.2pagehelper.version>
    16.     
    17.     <mybatis.spring.version>1.3.1mybatis.spring.version>
    18.     
    19.     <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    20.     <commons.pool2.version>2.4.3commons.pool2.version>
    21.     
    22.     <log4j2.version>2.9.1log4j2.version>
    23.     
    24.     <junit.version>4.12junit.version>
    25.     <servlet.version>4.0.0servlet.version>
    26.     <lombok.version>1.18.2lombok.version>
    27. properties>
    28.  
    29.  
    30. <dependencies>
    31.     
    32.     <dependency>
    33.         <groupId>org.springframeworkgroupId>
    34.         <artifactId>spring-contextartifactId>
    35.         <version>${spring.version}version>
    36.     dependency>
    37.     <dependency>
    38.         <groupId>org.springframeworkgroupId>
    39.         <artifactId>spring-ormartifactId>
    40.         <version>${spring.version}version>
    41.     dependency>
    42.     <dependency>
    43.         <groupId>org.springframeworkgroupId>
    44.         <artifactId>spring-txartifactId>
    45.         <version>${spring.version}version>
    46.     dependency>
    47.     <dependency>
    48.         <groupId>org.springframeworkgroupId>
    49.         <artifactId>spring-aspectsartifactId>
    50.         <version>${spring.version}version>
    51.     dependency>
    52.     <dependency>
    53.         <groupId>org.springframeworkgroupId>
    54.         <artifactId>spring-webartifactId>
    55.         <version>${spring.version}version>
    56.     dependency>
    57.     <dependency>
    58.         <groupId>org.springframeworkgroupId>
    59.         <artifactId>spring-testartifactId>
    60.         <version>${spring.version}version>
    61.     dependency>
    62.  
    63.     
    64.     <dependency>
    65.         <groupId>org.mybatisgroupId>
    66.         <artifactId>mybatisartifactId>
    67.         <version>${mybatis.version}version>
    68.     dependency>
    69.     
    70.     <dependency>
    71.         <groupId>mysqlgroupId>
    72.         <artifactId>mysql-connector-javaartifactId>
    73.         <version>${mysql.version}version>
    74.     dependency>
    75.     
    76.     <dependency>
    77.         <groupId>com.github.pagehelpergroupId>
    78.         <artifactId>pagehelperartifactId>
    79.         <version>${pagehelper.version}version>
    80.     dependency>
    81.     
    82.     <dependency>
    83.         <groupId>org.mybatisgroupId>
    84.         <artifactId>mybatis-springartifactId>
    85.         <version>${mybatis.spring.version}version>
    86.     dependency>
    87.  
    88.     
    89.     <dependency>
    90.         <groupId>org.apache.commonsgroupId>
    91.         <artifactId>commons-dbcp2artifactId>
    92.         <version>${commons.dbcp2.version}version>
    93.     dependency>
    94.     <dependency>
    95.         <groupId>org.apache.commonsgroupId>
    96.         <artifactId>commons-pool2artifactId>
    97.         <version>${commons.pool2.version}version>
    98.     dependency>
    99.  
    100.     
    101.     
    102.     <dependency>
    103.         <groupId>org.apache.logging.log4jgroupId>
    104.         <artifactId>log4j-coreartifactId>
    105.         <version>${log4j2.version}version>
    106.     dependency>
    107.     <dependency>
    108.         <groupId>org.apache.logging.log4jgroupId>
    109.         <artifactId>log4j-apiartifactId>
    110.         <version>${log4j2.version}version>
    111.     dependency>
    112.     
    113.     <dependency>
    114.         <groupId>org.apache.logging.log4jgroupId>
    115.         <artifactId>log4j-webartifactId>
    116.         <version>${log4j2.version}version>
    117.     dependency>
    118.  
    119.     
    120.     <dependency>
    121.         <groupId>junitgroupId>
    122.         <artifactId>junitartifactId>
    123.         <version>${junit.version}version>
    124.         <scope>testscope>
    125.     dependency>
    126.     <dependency>
    127.         <groupId>javax.servletgroupId>
    128.         <artifactId>javax.servlet-apiartifactId>
    129.         <version>${servlet.version}version>
    130.         <scope>providedscope>
    131.     dependency>
    132.     <dependency>
    133.         <groupId>org.projectlombokgroupId>
    134.         <artifactId>lombokartifactId>
    135.         <version>${lombok.version}version>
    136.         <scope>providedscope>
    137.     dependency>
    138.  
    139. dependencies>
    140.  
    141.  
    142. <resources>
    143.     
    144.     <resource>
    145.         <directory>src/main/javadirectory>
    146.         <includes>
    147.             <include>**/*.xmlinclude>
    148.         includes>
    149.     resource>
    150.     
    151.     <resource>
    152.         <directory>src/main/resourcesdirectory>
    153.         <includes>
    154.             <include>jdbc.propertiesinclude>
    155.             <include>*.xmlinclude>
    156.         includes>
    157.     resource>
    158. resources>
    159.  
    160.  
    161. <plugin>
    162.     <groupId>org.apache.maven.pluginsgroupId>
    163.     <artifactId>maven-compiler-pluginartifactId>
    164.     <version>${maven.compiler.plugin.version}version>
    165.     <configuration>
    166.         <source>${maven.compiler.source}source>
    167.         <target>${maven.compiler.target}target>
    168.         <encoding>${project.build.sourceEncoding}encoding>
    169.     configuration>
    170. plugin>
    171. <plugin>
    172.     <groupId>org.mybatis.generatorgroupId>
    173.     <artifactId>mybatis-generator-maven-pluginartifactId>
    174.     <version>1.3.2version>
    175.     <dependencies>
    176.         
    177.         <dependency>
    178.             <groupId>mysqlgroupId>
    179.             <artifactId>mysql-connector-javaartifactId>
    180.             <version>${mysql.version}version>
    181.         dependency>
    182.     dependencies>
    183.     <configuration>
    184.         <overwrite>trueoverwrite>
    185.     configuration>
    186. plugin>

            1.2.2 建立配置文件

             数据库连接配置文件：jdbc.properties：

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=UTF-8
    3. jdbc.username=用户名
    4. jdbc.password=密码

             逆向生成代码插件配置文件：generatorConfig.xml

    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.     <classPathEntry location="E:\\AnZhuangBao\\Maven\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    10.  
    11.     
    12.     <context id="infoGuardian">
    13.         
    14.         <commentGenerator>
    15.             <property name="suppressAllComments" value="true"/>
    16.             <property name="suppressDate" value="true"/> 
    17.         commentGenerator>
    18.  
    19.         
    20.         <jdbcConnection driverClass="${jdbc.driver}"
    21.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    22.  
    23.         
    24.         <javaTypeResolver>
    25.             
    26.             <property name="forceBigDecimals" value="false"/>
    27.         javaTypeResolver>
    28.  
    29.         
    30.         
    31.         
    32.         <javaModelGenerator targetPackage="com.leaf.model"
    33.                             targetProject="src/main/java">
    34.             
    35.             <property name="enableSubPackages" value="false"/>
    36.             
    37.             <property name="constructorBased" value="true"/>
    38.             
    39.             <property name="trimStrings" value="false"/>
    40.             
    41.             <property name="immutable" value="false"/>
    42.         javaModelGenerator>
    43.  
    44.         
    45.         <sqlMapGenerator targetPackage="com.leaf.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.leaf.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             <property name="enableSubPackages" value="false"/>
    59.         javaClientGenerator>
    60.  
    61.         
    62.         
    63.         
    64.         
    65.         
    66.         
    67.         
    68.         
    69.         
    70.         
    71.         
    72.         
    73.         
    74.  
    75.         <table schema="" tableName="t_mvc_Book" domainObjectName="Book"
    76.                enableCountByExample="false" enableDeleteByExample="false"
    77.                enableSelectByExample="false" enableUpdateByExample="false">
    78.             
    79.             
    80.             
    81.             
    82.         table>
    83.  
    84.         <table schema="" tableName="t_oa_permission" domainObjectName="Permission"
    85.                enableCountByExample="false" enableDeleteByExample="false"
    86.                enableSelectByExample="false" enableUpdateByExample="false">
    87.         table>
    88.  
    89.     context>
    90. generatorConfiguration>

        log4j2.xml：

    2.  
    4. <Configuration status="WARN" monitorInterval="30">
    5.     <Properties>
    6.         
    7.         <Property name="LOG_HOME">/root/workspace/lucenedemo/logsProperty>
    8.         <property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/errorproperty>
    9.         <property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warnproperty>
    10.         <property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%nproperty>
    11.     Properties>
    12.  
    13.     <Appenders>
    14.         
    15.         <Console name="Console" target="SYSTEM_OUT">
    16.             
    17.             <ThresholdFilter level="trace" onMatch="ACCEPT"
    18.                              onMismatch="DENY" />
    19.             
    20.             
    21.             <PatternLayout pattern="${PATTERN}" />
    22.         Console>
    23.  
    24.         
    25.         
    26.         <File name="log" fileName="logs/test.log" append="false">
    27.             <PatternLayout
    28.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    29.         File>
    30.         
    31.         <RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
    32.                      filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
    33.             
    34.             <ThresholdFilter level="info" onMatch="ACCEPT"
    35.                              onMismatch="DENY" />
    36.             <PatternLayout
    37.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    38.             <Policies>
    39.                 
    40.                 
    41.                 
    42.                 <TimeBasedTriggeringPolicy interval="1"
    43.                                            modulate="true" />
    44.                 
    45.                 
    46.             Policies>
    47.         RollingFile>
    48.  
    49.         <RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
    50.                      filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
    51.             <ThresholdFilter level="warn" onMatch="ACCEPT"
    52.                              onMismatch="DENY" />
    53.             <PatternLayout
    54.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    55.             <Policies>
    56.                 <TimeBasedTriggeringPolicy />
    57.                 <SizeBasedTriggeringPolicy size="2 kB" />
    58.             Policies>
    59.             
    60.             <DefaultRolloverStrategy max="20" />
    61.         RollingFile>
    62.  
    63.         <RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
    64.                      filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
    65.             <ThresholdFilter level="error" onMatch="ACCEPT"
    66.                              onMismatch="DENY" />
    67.             <PatternLayout
    68.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    69.             <Policies>
    70.                 
    71.                 <TimeBasedTriggeringPolicy interval="1"
    72.                                            modulate="true" />
    73.                 
    74.             Policies>
    75.         RollingFile>
    76.  
    77.     Appenders>
    78.  
    79.     
    80.     <Loggers>
    81.         
    82.         <logger name="org.springframework" level="INFO">logger>
    83.         <logger name="org.mybatis" level="INFO">logger>
    84.  
    85.         
    86.         <logger name="org.springframework" level="ERROR" />
    87.         <logger name="org.hibernate" level="ERROR" />
    88.         <logger name="org.apache.struts2" level="ERROR" />
    89.         <logger name="com.opensymphony.xwork2" level="ERROR" />
    90.         <logger name="org.jboss" level="ERROR" />
    91.  
    92.  
    93.         
    94.         <root level="all">
    95.             <appender-ref ref="Console" />
    96.             <appender-ref ref="RollingFileInfo" />
    97.             <appender-ref ref="RollingFileWarn" />
    98.             <appender-ref ref="RollingFileError" />
    99.         root>
    100.  
    101.     Loggers>
    102.  
    103. Configuration>

     mybatis的配置文件：mybatis.cfg.xml

    2. configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    3. <configuration>
    4.     
    5.     <properties resource="jdbc.properties"/>
    6.  
    7.     <settings>
    8.         <setting name="logImpl" value="LOG4J2"/>
    9.     settings>
    10.  
    11.     
    12.     <typeAliases>
    13.         
    14.     typeAliases>
    15.  
    16.     <plugins>
    17.         
    18.         <plugin interceptor="com.github.pagehelper.PageInterceptor">
    19.         plugin>
    20.     plugins>
    21.  
    22.     
    23.     <environments default="development">
    24.         <environment id="development">
    25.             
    26.             <transactionManager type="jdbc"/>
    27.  
    28.             
    29.             
    30.             
    31.             
    32.             <dataSource type="POOLED">
    33.                 <property name="driver"
    34.                           value="${jdbc.driver}"/>
    35.                 <property name="url"
    36.                           value="${jdbc.url}"/>
    37.                 <property name="username" value="${jdbc.username}"/>
    38.                 <property name="password" value="${jdbc.password}"/>
    39.             dataSource>
    40.         environment>
    41.     environments>
    42.  
    43.     <mappers>
    44.         <mapper resource="com/leaf/mapper/BookMapper.xml"/>
    45.     mappers>
    46. configuration>

            1.2.3 逆向自动生成代码

                    导入以上的配置文件后就可以测试生成代码了：

    这里是直接修改添加好的命令执行的项目，具体新建命令的方式可以参考我的文章：MyBatis环境搭建&&测试增删改查__Leaf1217的博客-CSDN博客 

     

    然后建立一些测试类，

    自行测试没有问题后就代表一个拥有mybatis功能的maven项目就建立好了。 

            1.2.4 添加并配置整合的配置文件

                    1.2.4.1 扫描注解驱动

                    1.2.4.2 添加并管理数据源 -> 管理sqlsession

                    1.2.4.3 扫描所有的Mapper接口

                    1.2.4.4 添加事务管理

    编写配置文件：applicationContext-mybatis.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.        xmlns:aop="http://www.springframework.org/schema/aop"
    6.        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/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    7.     
    8.     
    9.     <context:annotation-config/>
    10.     
    11.     <context:component-scan base-package="com.leaf.ssm"/>
    12.  
    13.     <context:property-placeholder location="classpath:jdbc.properties"/>
    14.  
    15.     <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
    16.           destroy-method="close">
    17.         <property name="driverClassName" value="${jdbc.driver}"/>
    18.         <property name="url" value="${jdbc.url}"/>
    19.         <property name="username" value="${jdbc.username}"/>
    20.         <property name="password" value="${jdbc.password}"/>
    21.         
    22.         <property name="initialSize" value="10"/>
    23.         
    24.         <property name="maxTotal" value="100"/>
    25.         
    26.         <property name="maxIdle" value="50"/>
    27.         
    28.         <property name="minIdle" value="10"/>
    29.         
    30.         
    31.         <property name="maxWaitMillis" value="-1"/>
    32.     bean>
    33.  
    34.     
    35.     
    36.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    37.         
    38.         <property name="dataSource" ref="dataSource"/>
    39.         
    40.         <property name="mapperLocations" value="classpath*:com/leaf/ssm/**/mapper/*.xml"/>
    41.         
    42.         <property name="typeAliasesPackage" value="com/leaf/ssm/**/model"/>
    43.         
    44.         <property name="plugins">
    45.             <array>
    46.                 <bean class="com.github.pagehelper.PageInterceptor">
    47.                     <property name="properties">
    48.                         <value>
    49.                             helperDialect=mysql
    50.                         value>
    51.                     property>
    52.                 bean>
    53.             array>
    54.         property>
    55.     bean>
    56.  
    57.     
    58.     
    59.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    60.         
    61.         
    62.         <property name="basePackage" value="com/leaf/ssm/**/mapper"/>
    63.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    64.     bean>
    65.  
    66.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    67.         <property name="dataSource" ref="dataSource" />
    68.     bean>
    69.     <tx:annotation-driven transaction-manager="transactionManager" />
    70.     <aop:aspectj-autoproxy/>
    71. beans>

    使用注解式开发：

       @Repository：将DAO类声明为Bean

       @Service：通常作用在业务层

       @Constroller：通常作用在控制层，将在Spring MVC中使用

       @Component：是一个泛化的概念，仅仅表示spring中的一个组件（Bean），可以作用在任何层次

       @Scope：模式声明（singleton|prototype）

       @Autowired：将自动在代码上下文与其匹配（默认是类型匹配）的Bean，并自动注入到相应的地方

    然后我们就可以把BookBizImpl实现类里面添加两个注解，相当于省略了set、get方法。

    1. package com.leaf.ssm.biz.impl;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.leaf.ssm.biz.BookBiz;
    6. import com.leaf.ssm.mapper.BookMapper;
    7. import com.leaf.ssm.model.Book;
    8. import com.leaf.ssm.model.BookVo;
    9. import com.leaf.ssm.entity.PageBean;
    10. import org.springframework.beans.factory.annotation.Autowired;
    11. import org.springframework.stereotype.Service;
    12.  
    13. import java.util.List;
    14. import java.util.Map;
    15.  
    16. /**
    17.  * @author Leaf
    18.  * @site 2977819715
    19.  * @company 玉渊工作室
    20.  * @create  2022-08-11 2:21
    21.  */
    22. @Service
    23. public class BookBizImpl implements BookBiz {
    24.  
    25.     @Autowired
    26.     private BookMapper bookMapper;
    27.  
    28.     //Alt+Enter 快速构建实现类，填充代码的前半部分 Ctrl+1
    29.     //Alt+Insert 快速提供set/get/toString/构造方法
    30.  
    31.  /*   public BookMapper getBookMapper() {
    32.         return bookMapper;
    33.     }
    35.     public void setBookMapper(BookMapper bookMapper) {
    36.         this.bookMapper = bookMapper;
    37.     }*/
    38.  
    39.     @Override
    40.     public int deleteByPrimaryKey(Integer bid) {
    41.         return bookMapper.deleteByPrimaryKey(bid);
    42.     }
    43.  
    44.     @Override
    45.     public Book selectByPrimaryKey(Integer bid) {
    46.         return bookMapper.selectByPrimaryKey(bid);
    47.     }
    48.  
    49.     @Override
    50.     public List selectByIn(List bidIds) {
    51.         return bookMapper.selectByIn(bidIds);
    52.     }
    53.  
    54.     @Override
    55.     public List selectBooksLike1(String bname) {
    56.         return bookMapper.selectBooksLike1(bname);
    57.     }
    58.  
    59.     @Override
    60.     public List selectBooksLike2(String bname) {
    61.         return bookMapper.selectBooksLike2(bname);
    62.     }
    63.  
    64.     @Override
    65.     public List selectBooksLike3(String bname) {
    66.         return bookMapper.selectBooksLike3(bname);
    67.     }
    68.  
    69.     @Override
    70.     public List list1() {
    71.         return bookMapper.list1();
    72.     }
    73.     @Override
    74.     public List list2() {
    75.         return bookMapper.list2();
    76.     }
    77.  
    78.     @Override
    79.     public List list3(BookVo vo) {
    80.         return bookMapper.list3(vo);
    81.     }
    82.  
    83.     @Override
    84.     public List list4() {
    85.         return bookMapper.list4();
    86.     }
    87.  
    88.     @Override
    89.     public Map list5(Map map) {
    90.         return bookMapper.list5(map);
    91.     }
    92.  
    93.     @Override
    94.     public List listPager(Map map, PageBean pageBean) {
    95.         //pageHelper分页插件相关代码
    96.         if(pageBean != null && pageBean.isPagination()){
    97.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    98.         }
    99.         List maps=bookMapper.listPager(map,pageBean);
    100.         if(pageBean != null && pageBean.isPagination()){
    101.             //处理查询结果的前提，是需要分页的
    102.             PageInfo info=new PageInfo(maps);
    103.             pageBean.setTotal(info.getTotal()+"");
    104.         }
    105.         return maps;
    106.     }
    107.  
    108.     @Override
    109.     public List list6(BookVo vo) {
    110.         return bookMapper.list6(vo);
    111.     }
    112.  
    113.     @Override
    114.     public List list7(BookVo vo) {
    115.         return bookMapper.list7(vo);
    116.     }
    117.  
    118. }

    管理数据源 -> 管理sqlsession

    我们还要给BookMapper.java添加一个标记：

     然后在测试类里面添加：

    @RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
    1. package com.leaf.ssm.imp;
    2.  
    3. import com.leaf.ssm.biz.BookBiz;
    4. import com.leaf.ssm.biz.impl.BookBizImpl;
    5. import com.leaf.ssm.entity.PageBean;
    6. import com.leaf.ssm.mapper.BookMapper;
    7. import com.leaf.ssm.model.BookVo;
    8. import com.leaf.ssm.util.SessionUtil;
    9. import org.apache.ibatis.session.SqlSession;
    10. import org.junit.After;
    11. import org.junit.Before;
    12. import org.junit.Test;
    13. import org.junit.runner.RunWith;
    14. import org.springframework.beans.factory.annotation.Autowired;
    15. import org.springframework.test.context.ContextConfiguration;
    16. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    17.  
    18. import java.util.Arrays;
    19. import java.util.HashMap;
    20. import java.util.List;
    21. import java.util.Map;
    22.  
    23. /**
    24.  * @author Leaf
    25.  * @site 2977819715
    26.  * @company 玉渊工作室
    27.  * @create  2022-08-11 2:29
    28.  */
    29. @RunWith(SpringJUnit4ClassRunner.class)
    30. @ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
    31. public class BookBizImplTest {
    32.  
    33.     @Autowired
    34.     private BookBiz bookBiz;
    35.     //private SqlSession sqlSession;
    36.  
    37.     @Before
    38.     public void setUp() throws Exception {
    39.         System.out.println("初始化方法...");
    40. //        BookBizImpl bookBiz = new BookBizImpl();
    41. //        //工具类中获取session对象
    42. //        sqlSession = SessionUtil.openSession();
    43. //        //从session对象中获取mapper对象
    44. //        BookMapper mapper = sqlSession.getMapper(BookMapper.class);
    45. //        //bookBiz.setBookMapper(mapper);
    46. //        this.bookBiz = bookBiz;
    47.     }
    48.  
    49.     @After
    50.     public void tearDown() throws Exception {
    51.         System.out.println("方法测试结束...");
    52.        /* sqlSession.commit();
    53.         sqlSession.close();*/
    54.     }
    55.  
    56.     @Test
    57.     public void deleteByPrimaryKey() {
    58.         bookBiz.deleteByPrimaryKey(44);
    59.     }
    60.  
    61.     @Test
    62.     public void selectByPrimaryKey() {
    63.         System.out.println("测试的业务方法...");
    64.         System.out.println(bookBiz.selectByPrimaryKey(45));
    65.     }
    66.  
    67.     @Test
    68.     public void test() {
    69.         int[] ints = {1,2,3,4,5,6};
    70.         //将数组变成字符串 1,2,3,4,5,6
    71.         StringBuffer sb = new StringBuffer();
    72.         for (int i:ints){
    73.             sb.append(",").append(i);
    74.         }
    75.         String s = sb.toString();
    76.         System.out.println(s.substring(1));
    77.     }
    78.  
    79.     @Test
    80.     public void getBookMapper() {
    81.     }
    82.  
    83.     @Test
    84.     public void setBookMapper() {
    85.     }
    86.  
    87.     @Test
    88.     public void selectByIn() {
    89.         List<Integer> bookIds = Arrays.asList(new Integer[]{31, 32, 33, 34});
    90.         bookBiz.selectByIn(bookIds).forEach(System.out::println);
    91.     }
    92.  
    93.     @Test
    94.     public void selectBooksLike1() {
    95.         bookBiz.selectBooksLike1("%圣墟%").forEach(System.out::println);
    96.     }
    97.  
    98.     @Test
    99.     public void selectBooksLike2() {
    100.         bookBiz.selectBooksLike2("%圣墟%").forEach(System.out::println);
    101.     }
    102.  
    103.     @Test
    104.     public void selectBooksLike3() {
    105.         bookBiz.selectBooksLike3("圣墟").forEach(System.out::println);
    106.     }
    107.  
    108.     @Test
    109.     public void list1() {
    110.         bookBiz.list1().forEach(System.out::println);
    111.     }
    112.  
    113.     @Test
    114.     public void list2() {
    115.         bookBiz.list2().forEach(System.out::println);
    116.     }
    117.  
    118.     @Test
    119.     public void list3() {
    120.         BookVo vo=new BookVo();
    121.         vo.setBookIds(Arrays.asList(new Integer[]{31,32,33,34}));
    122.         bookBiz.list3(vo).forEach(System.out::println);
    123.     }
    124.  
    125.     @Test
    126.     public void list4() {
    127.         bookBiz.list4().forEach(System.out::println);
    128.     }
    129.  
    130.     @Test
    131.     public void list5() {
    132.         Map map=new HashMap();
    133.         map.put("bid",32);
    134.         System.out.println(bookBiz.list5(map));
    135.     }
    136.  
    137.     @Test
    138.     public void listPager() {
    139.         Map map=new HashMap();
    140.         map.put("bname","圣墟");
    141.         bookBiz.listPager(map,null).forEach(System.out::println);
    142.         //查询出第二页的20条数据
    143.         PageBean pageBean=new PageBean();
    144.         pageBean.setPage(2);
    145.         pageBean.setRows(20);
    146.         bookBiz.listPager(map,null).forEach(System.out::println);
    147.     }
    148.  
    149.     @Test
    150.     public void list6() {
    151.         BookVo vo=new BookVo();
    152.         vo.setMax(45);
    153.         vo.setMin(35);
    154.         bookBiz.list6(vo).forEach(System.out::println);
    155.     }
    156.  
    157.     @Test
    158.     public void list7() {
    159.         BookVo vo=new BookVo();
    160.         vo.setMax(45);
    161.         vo.setMin(35);
    162.         bookBiz.list7(vo).forEach(System.out::println);
    163.     }
    164. }

    然后我们呢测试查询到了：

     二、aop整合分页插件PageHelper

    2.1 为什么要整合，解决什么问题？

    1.   @Override
    2.     public List listPager(Map map, PageBean pageBean) {
    3.         //pageHelper分页插件相关代码
    4.         if(pageBean != null && pageBean.isPagination()){
    5.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    6.         }
    7.         List maps=bookMapper.listPager(map,pageBean);
    8.         if(pageBean != null && pageBean.isPagination()){
    9.             //处理查询结果的前提，是需要分页的
    10.             PageInfo info=new PageInfo(maps);
    11.             pageBean.setTotal(info.getTotal()+"");
    12.         }
    13.         return maps;
    14.     }

    可以使用AOP编程解决分页代码重复的问题，省掉重复的代码。

    根据Spring aop所学，我们可以利用环绕通知来解决；

    1、找到目标对象 -> *Biz.*Pager

    2、写通知

            2.1 目标对象该方法一定携带了PageBean对象

    注解：@aspect：相当于配置了环绕通知

               @component：交给Spring进行管理

               @excution

    建立一个切面类：PageAspect

    1. package com.leaf.ssm.aspect;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.leaf.ssm.entity.PageBean;
    6. import org.aspectj.lang.ProceedingJoinPoint;
    7. import org.aspectj.lang.annotation.Around;
    8. import org.aspectj.lang.annotation.Aspect;
    9. import org.springframework.stereotype.Component;
    10.  
    11. import java.util.List;
    12.  
    13. /**
    14.  * @author Leaf
    15.  * @site 2977819715
    16.  * @company 玉渊工作室
    17.  * @create  2022-08-15 6:43
    18.  */
    19. @Component
    20. @Aspect
    21. public class PageAspect {
    22.  
    23.     /**
    24.      * *：返回值
    25.      * *..：无限包
    26.      * *Service：以Service结尾的接口名
    27.      * .Pager：以Pager方法
    28.      * 只要同时匹配上诉四个条件，就会被列为目标对象
    29.      * 上诉配置要生效，代理注释一定要打开：
    30.      * @param args
    31.      * @return
    32.      * @throws Throwable
    33.      */
    34.     @Around("execution(* *..*Biz.*Pager(..))")
    35.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    36.         Object[] params = args.getArgs();
    37.         PageBean pageBean = null;
    38.         for (Object param : params) {
    39.             if(param instanceof PageBean){
    40.                 pageBean = (PageBean)param;
    41.                 break;
    42.             }
    43.         }
    44.  
    45.         if(pageBean != null && pageBean.isPagination())
    46.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    47.  
    48.         Object list = args.proceed(params);
    49.  
    50.         if(null != pageBean && pageBean.isPagination()){
    51.             PageInfo pageInfo = new PageInfo((List) list);
    52.             pageBean.setTotal(pageInfo.getTotal()+"");
    53.         }
    54.         return list;
    55.     }
    56. }

    @Around：代表这是一个环绕通知

    然后我们测试一下：

    1.     @Test
    2.     public void listPager() {
    3.         Map map=new HashMap();
    4.         map.put("bname","圣墟");
    5.         //查询出第二页的20条数据
    6.         PageBean pageBean=new PageBean();
    7.         pageBean.setPage(2);
    8.         pageBean.setRows(20);
    9.         bookBiz.listPager(map,pageBean).forEach(System.out::println);
    10.     }

    上诉配置要生效，

    代理注释一定要打开：

    查询结果：

     

    OK

  • 相关阅读:
    数说故事亮相CPG第八届中国消费品数字科技大会
    值改变事件(SMART PLC梯形图FC)
    Anaconda Prompt中的指令集
    优化改进YOLOv5算法之添加DCNv3模块，有效提升目标检测效果
    工作心得——css让元素居中的方法
    前端学习笔记02
    Pycharm无法完整运行django设计的网页
    从React源码分析看useEffect
    Linux常用命令
    HTML5 Canvas 限定文本区域大小，文字自动换行，自动缩放
  • 原文地址：https://blog.csdn.net/qq_63492318/article/details/126323039