• Mybatis（整合spring）

    目录

    1、Mybatis与spring集成

    2、Aop整合分页插件

    1、Mybatis与spring集成

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

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

     SSM整合

    1、添加所有的pom依赖

    2、添加并配置整合的配置文件

            Spring:spring-context.xml

            Mybatis:mybatis.cfg.xml

            spring-mybatis.xml

                    1、扫描注解驱动

                    2、添加并管理数据源->管理sqlsession

                    3、扫描所有的mapper接口

                    4、添加事务管理器

                    

    添加applicationContext-mybatis.xml也就是  spring-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.zwc.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/zwc/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>

    javaBean交给Spring进行管理？

    在BookBizimpl上方提啊你啊@service注解

    相当于

    在属性上方添加@autowised

    相当于：

    标记Mapper接口被Spring所接管

    1. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    2.         <property name="dataSource" ref="dataSource" />
    3.     bean>
    4.     <tx:annotation-driven transaction-manager="transactionManager" />
    5.     <aop:aspectj-autoproxy/>

    事务管理器，管理事务的提交、回滚

    在test类加入注解：

    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})

     在属性前面加入注解：@Autowired

    测试： 

     

     测试成功代表我们成功整合

    2、Aop整合分页插件

    下图中两个if是同步的

    利用pageHelper分页，

    PageHelper.start与后续结果处理即PageInfo处理代码是完全重复的

    上述图中重复的即非核心的业务代码

    根据Spring Aop所学

    共性的非核心业务代码用通知解决

    核心业务代码，前面后面都需要添加 共性的非核心的业务代码，利用环绕通知解决

    分析：

    1.找到目标对象——>*Biz.*Pager以biz结尾类或者接口，pager方法

    2.写通知

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

            2.2 if(pageBean!=null&&pageBean.isPagination()){ // 拿到页数和行数 PageHelper.startPage(pageBean.getPage(),pageBean.getRows()); }

            2.3执行目标对象

            2.4 if(pageBean!=null&& pageBean.isPagination()){ // 处理结果的前提，是需要分页的 // maps经过第三方插件进行处理 分页 PageInfo info = new PageInfo(maps); pageBean.setTotal(info.getTotal()+""); }

    @aspect——>代表了通知/切面

    @component——>交个Spring进行管理

    创建切面包和类 

    PagerASpect：

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

    test:

     

     

  • 相关阅读:
    ME21N 采购订单新增页签增强
    libevent、libev框架介绍
    vue.js毕业设计，基于vue.js前后端分离订座预约系统（H5移动项目） 开题报告
    JavaScript进阶 第四天笔记——深浅拷贝、this绑定、防抖节流
    gma 2 成书计划
    2022牛客暑期多校训练营4 个人题解
    从零开始搭建SpringBoot项目，并且用Mybatis进行数据查询（包含所用数据库）
    基于token进行登录，每次请求携带token
    前后端分离的大数据毕设项目之基于Spark+springboot+vue的共享单车数据存储系统的设计与实现
    ​k8s常用命令 ​
  • 原文地址：https://blog.csdn.net/qq_65345936/article/details/126291946