• Mybatis整合spring

    目录

    一，Mybatis与spring集成

    二，Aop整合pagehelper插件

    一，Mybatis与spring集成


    导入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)

    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逆向工程生成模型层层代码
    编写配置文件applicationContext-mybatis.xml
    3.1 注解式开发

       开启注解

       

       

       

       

       component-scan base-package="com.javaxl.ssm"/>

       3.2 引入外部jdbc配置文件

       

       3.3 配置dbcp2数据库连接池

       3.4 spring和mybatis整合

      

       3.5 注解式事物配置

       

           

       

       

       3.6 开启动态代理

       

    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之间的耦合。

       @Transactional

    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>

     

    Spring Test+junit完美组合
    在工程的pom文件中增加spring-test的依赖

         

           org.springframework

           spring-test

           ${spring.version}

         

       

       4.2 创建BaseTestCase，并在该类上加上两个注解

       @RunWith(SpringJUnit4ClassRunner.class)

       @ContextConfiguration(locations={"classpath:applicationContext.xml"})

    相关代码

    Service层

    1.  
    2. package com.javaxl.ssm;
    3.  
    4. import com.javaxl.ssm.model.Book;
    5. import com.javaxl.ssm.model.PageBean;
    6. import org.junit.Before;
    7. import org.junit.runner.RunWith;
    8. import org.springframework.test.context.ContextConfiguration;
    9. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    10.  
    11.  
    12. @RunWith(SpringJUnit4ClassRunner.class)
    13. @ContextConfiguration(locations={"classpath:applicationContext.xml"})
    14. public class SpringJunitBaseTest {
    15.     protected Book book;
    16.     protected PageBean pageBean;
    17.  
    18.     @Before
    19.     public void setUp(){
    20.         book = new Book();
    21.         pageBean = new PageBean();
    22.     }
    23.  
    24.  
    1. package com.javaxl.ssm.service.impl;
    2.  
    3. import com.javaxl.ssm.SpringJunitBaseTest;
    4. import com.javaxl.ssm.service.BookService;
    5. import org.junit.Test;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7.  
    8. import static org.junit.Assert.*;
    9.  
    10.  
    11. public class BookServiceImplTest extends SpringJunitBaseTest {
    12.     @Autowired
    13.     private BookService bookService;
    14.  
    15.     @Test
    16.     public void insert() {
    17.         book.setBid(10006);
    18.         book.setBname("www.javaxl.com");
    19.         book.setPrice(666f);
    20.         bookService.insert(book);
    21.     }
    22.  
    23.     @Test
    24.     public void selectByPrimaryKey() {
    25.         System.out.println(bookService.selectByPrimaryKey(10006));
    26.     }
    27. }

    二，Aop整合pagehelper插件


    注意：记得开动态代理

    使用AOP编程解决分页代码重复的问题

       @Around("execution(* *..*Service.*pager(..))")

       public Object invoke(ProceedingJoinPoint args)

    语法结构：execution(方法修饰符  方法返回值  方法所属类 匹配方法

    1. package com.javaxl.ssm.component;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.javaxl.ssm.model.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. @Component
    15. @Aspect
    16. public class PagerAspect {
    17.  
    18.     @Around("execution(* *..*Service.*Pager(..))")
    19.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    20.         Object[] params = args.getArgs();
    21.         PageBean pageBean = null;
    22.         for (Object param : params) {
    23.             if(param instanceof PageBean){
    24.                 pageBean = (PageBean)param;
    25.                 break;
    26.             }
    27.         }
    28.  
    29.         if(pageBean != null && pageBean.isPagination())
    30.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    31.  
    32.         Object list = args.proceed(params);
    33.  
    34.         if(null != pageBean && pageBean.isPagination()){
    35.             PageInfo pageInfo = new PageInfo((List) list);
    36.             pageBean.setTotal(pageInfo.getTotal()+"");
    37.         }
    38.         return list;
    39.     }
    40.  
    41.  
    42. }

    名 (  方法中的形参表 )  方法申明抛出的异常  )

    "*"  ：代表一个任意类型的参数；

    “..”：代表零个或多个任意类型的参数。
     

     今天的分享就到这啦~我们下期再见！！！

  • 相关阅读:
    Ansible学习笔记09-剧本中使用变量2
    《Java》private、protected、public区别及解析
    [附源码]java毕业设计网上鞋店管理系统
    python使用openpyxl添加图片到excel文件中
    CSDN竞赛第四期题解
    Ubuntu 20.04中docker-compose部署Nightingale
    c 理解创建多进程
    Hibernate EntityManager 指南
    【线性代数】为什么 AA* = |A|E
    浏览器不能访问阿里云ECS
  • 原文地址：https://blog.csdn.net/weixin_63544775/article/details/126339298