• Mybitis与Spring集成

    目录

    一、Mybatis与spring集成

    1、导入pom依赖

     2、利用mybatis逆向工程生成模型层层代码

    3、编写配置文件applicationContext-mybatis.xml

    4、Spring Test+junit完美组合

    二、Aop整合pagehelper插件

    1、PageAspect 

    2、BookBizImpl

    3、BookBizImplTest2

    一、Mybatis与spring集成

    1、导入pom依赖

    1.1 添加spring相关依赖(5.0.2.RELEASE)
    spring-core
    spring-beans
    spring-context
    spring-orm
    spring-tx
    spring-aspects
    spring-web

    1.2 添加mybatis相关依赖
    mybatis核心：mybatis(3.4.5)
    Mybatis分页：pagehelper(5.1.2)

    1.3 spring整合mybatis(1.3.1)
    mybatis-spring

    1.4 添加dbcp2连接池
    commons-dbcp2(2.1.1)
    commons-pool2(2.4.3)

    1.5 添加日志配置(2.9.1)
    log4j-core
    log4j-api
    log4j-web

    1.6 其他
    junit(4.12)
    javax.servlet-api(4.0.0)
    lombok(1.18.2)

    注：使用mybatis-generator插件，pom文件添加支持

     2、利用mybatis逆向工程生成模型层层代码

    2.  
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" 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>ssmartifactId>
    9.   <version>1.0-SNAPSHOTversion>
    10.   <packaging>warpackaging>
    11.  
    12.   <name>ssm Maven Webappname>
    13.   
    14.   <url>http://www.example.comurl>
    15.  
    16.   <properties>
    17.     <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    18.     <maven.compiler.source>1.8maven.compiler.source>
    19.     <maven.compiler.target>1.8maven.compiler.target>
    20.     <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
    21.  
    22.     
    23.     
    24.     <spring.version>5.0.2.RELEASEspring.version>
    25.     
    26.     <mybatis.version>3.4.5mybatis.version>
    27.     
    28.     <mysql.version>5.1.44mysql.version>
    29.     
    30.     <pagehelper.version>5.1.2pagehelper.version>
    31.     
    32.     <mybatis.spring.version>1.3.1mybatis.spring.version>
    33.     
    34.     <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    35.     <commons.pool2.version>2.4.3commons.pool2.version>
    36.     
    37.     <log4j2.version>2.9.1log4j2.version>
    38.     
    39.     <junit.version>4.12junit.version>
    40.     <servlet.version>4.0.0servlet.version>
    41.     <lombok.version>1.18.2lombok.version>
    42.   properties>
    43.  
    44.  
    45.   <dependencies>
    46.     
    47.     <dependency>
    48.       <groupId>org.springframeworkgroupId>
    49.       <artifactId>spring-contextartifactId>
    50.       <version>${spring.version}version>
    51.     dependency>
    52.     <dependency>
    53.       <groupId>org.springframeworkgroupId>
    54.       <artifactId>spring-ormartifactId>
    55.       <version>${spring.version}version>
    56.     dependency>
    57.     <dependency>
    58.       <groupId>org.springframeworkgroupId>
    59.       <artifactId>spring-txartifactId>
    60.       <version>${spring.version}version>
    61.     dependency>
    62.     <dependency>
    63.       <groupId>org.springframeworkgroupId>
    64.       <artifactId>spring-aspectsartifactId>
    65.       <version>${spring.version}version>
    66.     dependency>
    67.     <dependency>
    68.       <groupId>org.springframeworkgroupId>
    69.       <artifactId>spring-webartifactId>
    70.       <version>${spring.version}version>
    71.     dependency>
    72.     <dependency>
    73.       <groupId>org.springframeworkgroupId>
    74.       <artifactId>spring-testartifactId>
    75.       <version>${spring.version}version>
    76.     dependency>
    77.  
    78.     
    79.     <dependency>
    80.       <groupId>org.mybatisgroupId>
    81.       <artifactId>mybatisartifactId>
    82.       <version>${mybatis.version}version>
    83.     dependency>
    84.     
    85.     <dependency>
    86.       <groupId>mysqlgroupId>
    87.       <artifactId>mysql-connector-javaartifactId>
    88.       <version>${mysql.version}version>
    89.     dependency>
    90.     
    91.     <dependency>
    92.       <groupId>com.github.pagehelpergroupId>
    93.       <artifactId>pagehelperartifactId>
    94.       <version>${pagehelper.version}version>
    95.     dependency>
    96.     
    97.     <dependency>
    98.       <groupId>org.mybatisgroupId>
    99.       <artifactId>mybatis-springartifactId>
    100.       <version>${mybatis.spring.version}version>
    101.     dependency>
    102.  
    103.     
    104.     <dependency>
    105.       <groupId>org.apache.commonsgroupId>
    106.       <artifactId>commons-dbcp2artifactId>
    107.       <version>${commons.dbcp2.version}version>
    108.     dependency>
    109.     <dependency>
    110.       <groupId>org.apache.commonsgroupId>
    111.       <artifactId>commons-pool2artifactId>
    112.       <version>${commons.pool2.version}version>
    113.     dependency>
    114.  
    115.     
    116.     
    117.     <dependency>
    118.       <groupId>org.apache.logging.log4jgroupId>
    119.       <artifactId>log4j-coreartifactId>
    120.       <version>${log4j2.version}version>
    121.     dependency>
    122.     <dependency>
    123.       <groupId>org.apache.logging.log4jgroupId>
    124.       <artifactId>log4j-apiartifactId>
    125.       <version>${log4j2.version}version>
    126.     dependency>
    127.     
    128.     <dependency>
    129.       <groupId>org.apache.logging.log4jgroupId>
    130.       <artifactId>log4j-webartifactId>
    131.       <version>${log4j2.version}version>
    132.     dependency>
    133.  
    134.     
    135.     <dependency>
    136.       <groupId>junitgroupId>
    137.       <artifactId>junitartifactId>
    138.       <version>${junit.version}version>
    139.       <scope>testscope>
    140.     dependency>
    141.     <dependency>
    142.       <groupId>javax.servletgroupId>
    143.       <artifactId>javax.servlet-apiartifactId>
    144.       <version>${servlet.version}version>
    145.       <scope>providedscope>
    146.     dependency>
    147.     <dependency>
    148.       <groupId>org.projectlombokgroupId>
    149.       <artifactId>lombokartifactId>
    150.       <version>${lombok.version}version>
    151.       <scope>providedscope>
    152.     dependency>
    153.  
    154.   dependencies>
    155.  
    156.  
    157.   <build>
    158.     <finalName>ssmfinalName>
    159.     <resources>
    160.       
    161.       <resource>
    162.         <directory>src/main/javadirectory>
    163.         <includes>
    164.           <include>**/*.xmlinclude>
    165.         includes>
    166.       resource>
    167.       
    168.       <resource>
    169.         <directory>src/main/resourcesdirectory>
    170.         <includes>
    171.           <include>jdbc.propertiesinclude>
    172.           <include>*.xmlinclude>
    173.         includes>
    174.       resource>
    175.     resources>
    176.  
    177.     <pluginManagement>
    178.       <plugins>
    179.         <plugin>
    180.           <groupId>org.apache.maven.pluginsgroupId>
    181.           <artifactId>maven-compiler-pluginartifactId>
    182.           <version>${maven.compiler.plugin.version}version>
    183.           <configuration>
    184.             <source>${maven.compiler.source}source>
    185.             <target>${maven.compiler.target}target>
    186.             <encoding>${project.build.sourceEncoding}encoding>
    187.           configuration>
    188.         plugin>
    189.         <plugin>
    190.           <groupId>org.mybatis.generatorgroupId>
    191.           <artifactId>mybatis-generator-maven-pluginartifactId>
    192.           <version>1.3.2version>
    193.           <dependencies>
    194.             
    195.             <dependency>
    196.               <groupId>mysqlgroupId>
    197.               <artifactId>mysql-connector-javaartifactId>
    198.               <version>${mysql.version}version>
    199.             dependency>
    200.           dependencies>
    201.           <configuration>
    202.             <overwrite>trueoverwrite>
    203.           configuration>
    204.         plugin>
    205.  
    206.         <plugin>
    207.           <artifactId>maven-clean-pluginartifactId>
    208.           <version>3.1.0version>
    209.         plugin>
    210.         
    211.         <plugin>
    212.           <artifactId>maven-resources-pluginartifactId>
    213.           <version>3.0.2version>
    214.         plugin>
    215.         <plugin>
    216.           <artifactId>maven-compiler-pluginartifactId>
    217.           <version>3.8.0version>
    218.         plugin>
    219.         <plugin>
    220.           <artifactId>maven-surefire-pluginartifactId>
    221.           <version>2.22.1version>
    222.         plugin>
    223.         <plugin>
    224.           <artifactId>maven-war-pluginartifactId>
    225.           <version>3.2.2version>
    226.         plugin>
    227.         <plugin>
    228.           <artifactId>maven-install-pluginartifactId>
    229.           <version>2.5.2version>
    230.         plugin>
    231.         <plugin>
    232.           <artifactId>maven-deploy-pluginartifactId>
    233.           <version>2.8.2version>
    234.         plugin>
    235.       plugins>
    236.     pluginManagement>
    237.   build>
    238. project>
    239.

    3、编写配置文件applicationContext-mybatis.xml

    3.1 注解式开发
    开启注解

    注解式开发
    注解驱动
    context:annotation-config/
    用注解方式注入bean，并指定查找范围：com.javaxl.ssm及子子孙孙包
    component-scan base-package=“com.javaxl.ssm”/>

    3.2 引入外部jdbc配置文件

    3.3 配置dbcp2数据库连接池

    3.4 spring和mybatis整合

    3.5 注解式事物配置

     

    3.6 开启动态代理
    aop:aspectj-autoproxy/

    3.7 注解式开发
    @Repository：将DAO类声明为Bean
    @Service：通常作用在业务层
    @Constroller：通常作用在控制层，将在Spring MVC中使用
    @Component：是一个泛化的概念，仅仅表示spring中的一个组件（Bean），可以作用在任何层次
    @Scope：模式声明（singleton|prototype）
    @Autowired：将自动在代码上下文与其匹配（默认是类型匹配）的Bean，并自动注入到相应的地方
    @Resource：
    1）@Resource后面没有任何内容，默认通过name属性去匹配bean，找不到再按type去匹配
    2）指定了name或者type则根据指定的类型去匹配bean
    3）指定了name和type则根据指定的name和type去匹配bean，任何一个不匹配都将报错

    问题：@Autowired和@Resource两个注解的区别：
    1）@Autowired默认按照byType方式进行bean匹配，@Resource默认按照byName方式进行bean匹配
    2）@Autowired是Spring的注解，@Resource是J2EE的注解，这个看一下导入注解的时候这两个注解的包名就一清二楚了
    Spring属于第三方的，J2EE是Java自己的东西，因此，建议使用@Resource注解，以减少代码和Spring之间的耦合。

    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.javaxl.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/javaxl/ssm/**/mapper/*.xml"/>
    41.         
    42.         <property name="typeAliasesPackage" value="com/javaxl/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/javaxl/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>
    72.  
    73.

     

    4、Spring Test+junit完美组合

    4.1、BookBiz

    1. package com.liaoxin.ssm.biz;
    2.  
    3. import com.liaoxin.ssm.model.Book;
    4. import com.liaoxin.ssm.model.BookVo;
    5. import com.liaoxin.ssm.util.PageBean;
    6.  
    7. import java.util.List;
    8. import java.util.Map;
    9.  
    10. public interface BookBiz {
    11.     public int deleteByPrimaryKey(Integer bid);
    12.  
    13.     public Book selectByPrimaryKey(Integer bid);
    14.  
    15.     public List selectByIn(List bookIds);
    16.  
    17.     public List selectBooksLike1(String bname);
    18.     public List selectBooksLike2(String bname);
    19.     public List selectBooksLike3(String bname);
    20.  
    21.     List list1();
    22.     List list2();
    23.     List list3(BookVo vo);
    24.     List list4();
    25.     Map list5(Map map);
    26.  
    27.     List listPager(Map map, PageBean pageBean);
    28.  
    29.     List list6(BookVo bookVo);
    30.  
    31.     List list7(BookVo bookVo);
    32. }
    33.

    4.2、BookBizImpl

    1. package com.liaoxin.ssm.biz.impl;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.liaoxin.ssm.biz.BookBiz;
    6. import com.liaoxin.ssm.mapper.BookMapper;
    7. import com.liaoxin.ssm.model.Book;
    8. import com.liaoxin.ssm.model.BookVo;
    9. import com.liaoxin.ssm.util.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. @Service
    17. public class BookBizImpl implements BookBiz {
    18.     @Autowired
    19.     private BookMapper bookMapper;
    20.  
    21. //    alt+insert 快速提供set/get/tostring/构造方法
    22. //    alt+enter 快速构建实现类，填充代码的前半部分 ctrl+1
    23. //    public BookMapper getBookMapper() {
    24. //        return bookMapper;
    25. //    }
    26.  
    27. //    public void setBookMapper(BookMapper bookMapper) {
    28. //        this.bookMapper = bookMapper;
    29. //    }
    30.  
    31.     @Override
    32.     public int deleteByPrimaryKey(Integer bid) {
    33.         return bookMapper.deleteByPrimaryKey(bid);
    34.     }
    35.  
    36.     @Override
    37.     public Book selectByPrimaryKey(Integer bid) {
    38.         return bookMapper.selectByPrimaryKey(bid);
    39.     }
    40.  
    41.     @Override
    42.     public List selectByIn(List bookIds) {
    43.         return bookMapper.selectByIn(bookIds);
    44.     }
    45.  
    46.     @Override
    47.     public List selectBooksLike1(String bname) {
    48.         return bookMapper.selectBooksLike1(bname);
    49.     }
    50.  
    51.     @Override
    52.     public List selectBooksLike2(String bname) {
    53.         return bookMapper.selectBooksLike2(bname);
    54.     }
    55.  
    56.     @Override
    57.     public List selectBooksLike3(String bname) {
    58.         return bookMapper.selectBooksLike3(bname);
    59.     }
    60.  
    61.     @Override
    62.     public List list1() {
    63.         return bookMapper.list1();
    64.     }
    65.  
    66.     @Override
    67.     public List list2() {
    68.         return bookMapper.list2();
    69.     }
    70.  
    71.     @Override
    72.     public List list3(BookVo vo) {
    73.         return bookMapper.list3(vo);
    74.     }
    75.  
    76.     @Override
    77.     public List list4() {
    78.         return bookMapper.list4();
    79.     }
    80.  
    81.     @Override
    82.     public Map list5(Map map) {
    83.         return bookMapper.list5(map);
    84.     }
    85.  
    86.     @Override
    87.     public List listPager(Map map, PageBean pageBean) {
    88. //        pageHelper分页插件相关的代码
    89.         if(pageBean!=null&&pageBean.isPagination()){
    90.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    91.         }
    92.         List maps = bookMapper.listPager(map);
    93.         if(pageBean!=null&&pageBean.isPagination()){
    94. //            处理查询结果的前提是需要分页，是需要分页的
    95.             PageInfo info = new PageInfo(maps);
    96.             pageBean.setTotal(info.getTotal()+"");
    97.         }
    98.         return maps;
    99.     }
    100.  
    101.     @Override
    102.     public List list6(BookVo bookVo) {
    103.         return bookMapper.list6(bookVo);
    104.     }
    105.  
    106.     @Override
    107.     public List list7(BookVo bookVo) {
    108.         return bookMapper.list7(bookVo);
    109.     }
    110. }
    111.

    4.3、BookMapper

    1. package com.liaoxin.ssm.mapper;
    2.  
    3. import com.liaoxin.ssm.model.Book;
    4. import com.liaoxin.ssm.model.BookVo;
    5. import org.apache.ibatis.annotations.Param;
    6. import org.springframework.stereotype.Repository;
    7.  
    8. import java.util.List;
    9. import java.util.Map;
    10.  
    11. @Repository
    12. public interface BookMapper {
    13.     int deleteByPrimaryKey(Integer bid);
    14.  
    15.     int insert(Book record);
    16.  
    17.     int insertSelective(Book record);
    18.  
    19.     Book selectByPrimaryKey(Integer bid);
    20.  
    21.     int updateByPrimaryKeySelective(Book record);
    22.  
    23.     int updateByPrimaryKey(Book record);
    24.  
    25. //  通过in关键字进行查询：讲解foreach 标签的使用
    26. //    如果说参数是非实体类(book,Order,....)，那么急的加上注解 @param,bookIds是对应collection属性的
    27.     List selectByIn(@Param("bookIds") List bookIds);
    28.  
    29.     List selectBooksLike1(@Param("bname") String bname);
    30.     List selectBooksLike2(@Param("bname") String bname);
    31.     List selectBooksLike3(@Param("bname") String bname);
    32.  
    33. //    list1 list2的结论是，对于单表查询而言，可以用resultmap/resulttype接收，但是多表必须用resultmap接收
    34.     List list1();
    35.     List list2();
    36. //    如果要传入多个查询参数，必须以对象的方式进行传递
    37. //    举例：select * from t_mvc_book where bid in (1,2,3,4,5,6) and bname in ("圣墟","不死不休")
    38.     List list3(BookVo vo);
    39. //    说明了不管返回1条数据，还是多条数据，都应该用java.util.Map进行接受
    40. //    如果是1条数据，那么返回值是Map
    41. //    如果是多条数据，那么返回值List
    42.     List list4();
    43.     Map list5(Map map);
    44.  
    45. //    利用第三方插件进行分页
    46.     List listPager(Map map);
    47.  
    48.     /**
    49.      * 处理特殊字符
    50.      * @param bookVo
    51.      * @return
    52.      */
    53.     List list6(BookVo bookVo);
    54.  
    55.  
    56.     /**
    57.      * 处理特殊字符
    58.      * @param bookVo
    59.      * @return
    60.      */
    61.     List list7(BookVo bookVo);
    62.  
    63.  
    64. }

    4.4、BookBizImplTest

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

    运行如下： 

     

    二、Aop整合pagehelper插件

     使用AOP编程解决分页代码重复的问题
    @Around(“execution(* *…*Service.*pager(…))”)
    public Object invoke(ProceedingJoinPoint args)

    语法结构：execution(方法修饰符 方法返回值 方法所属类 匹配方法名 ( 方法中的形参表 ) 方法申明抛出的异常 )
    “*” ：代表一个任意类型的参数；
    “…”：代表零个或多个任意类型的参数。

    /**
    * *:返回值类型
    * *：无限包
    * *Service：以Service结尾接口名
    * *Pager:以Pager方法
    * 只要同时匹配上诉四个条件，就会被列为目标对象
    * 上诉配置要生效，代理注解aop:aspectj-autoproxy/ 不能少
    *
    * @param args
    * @return
    * @throws Throwable
    */

    1、PageAspect 

    1. package com.liaoxin.ssm.aspect;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.liaoxin.ssm.util.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. @Component
    14. @Aspect
    15. public class PageAspect {
    16.  
    17.     /**
    18.      * *:返回值类型
    19.      * *：无限包
    20.      * *Service：以Service结尾接口名
    21.      * *Pager:以Pager方法
    22.      * 只要同时匹配上诉四个条件，就会被列为目标对象
    23.      * 上诉配置要生效，代理注解 不能少
    24.      *
    25.      * @param args
    26.      * @return
    27.      * @throws Throwable
    28.      */
    29.     @Around("execution(* *..*Biz.*Pager(..))")
    30.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    31.         Object[] params = args.getArgs();
    32.         PageBean pageBean = null;
    33.         for (Object param : params) {
    34.             if(param instanceof PageBean){
    35.                 pageBean = (PageBean)param;
    36.                 break;
    37.             }
    38.         }
    39.  
    40.         if(pageBean != null && pageBean.isPagination())
    41.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    42.  
    43. //        执行目标方法
    44.         Object list = args.proceed(params);
    45.  
    46.         if(null != pageBean && pageBean.isPagination()){
    47.             PageInfo pageInfo = new PageInfo((List) list);
    48.             pageBean.setTotal(pageInfo.getTotal()+"");
    49.         }
    50.         return list;
    51.     }
    52.  
    53.  
    54. }
    55.  
    56.

    2、BookBizImpl

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

    3、BookBizImplTest2

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

     

  • 相关阅读:
    vue的组件使用
    Linux Command echo
    macOS Sonoma 14.6.1 (23G93) Boot ISO 原版可引导镜像下载
    Flutter dio Http请求之Cookie管理
    错题本1：为什么往div盒子模型添加不上背景颜色和背景图片？
    我的前端成长之路：中医药大学毕业的业务女前端修炼之路
    第7章 - 多无人机系统的协同控制 --＞ 实验验证
    09.Json语法
    LeetCode 104. 二叉树的最大深度
    华为云云耀云服务器L实例评测｜用PHP从数据库到后端到前端完整实现一个中秋节祝福语项目
  • 原文地址：https://blog.csdn.net/qq_44247968/article/details/126343309