Mybatis与Spring的集成

一、Mybatis与Spring的整合

1. 导入pom依赖


 
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0modelVersion>
 
  <groupId>org.examplegroupId>
  <artifactId>mavenTextartifactId>
  <version>1.0-SNAPSHOTversion>
  <packaging>warpackaging>
 
  <name>mavenText Maven Webappname>
  
  <url>http://www.example.comurl>
 
  <properties>
    <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    <maven.compiler.source>1.8maven.compiler.source>
    <maven.compiler.target>1.8maven.compiler.target>
    <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
 
    
    
    <spring.version>5.0.2.RELEASEspring.version>
    
    <mybatis.version>3.4.5mybatis.version>
    
    <mysql.version>5.1.44mysql.version>
    
    <pagehelper.version>5.1.2pagehelper.version>
    
    <mybatis.spring.version>1.3.1mybatis.spring.version>
    
    <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    <commons.pool2.version>2.4.3commons.pool2.version>
    
    <log4j2.version>2.9.1log4j2.version>
    
    <junit.version>4.12junit.version>
    <servlet.version>4.0.0servlet.version>
    <lombok.version>1.18.2lombok.version>
  properties>
 
  <dependencies>
    
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-contextartifactId>
      <version>${spring.version}version>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-ormartifactId>
      <version>${spring.version}version>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-txartifactId>
      <version>${spring.version}version>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-aspectsartifactId>
      <version>${spring.version}version>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-webartifactId>
      <version>${spring.version}version>
    dependency>
    <dependency>
      <groupId>org.springframeworkgroupId>
      <artifactId>spring-testartifactId>
      <version>${spring.version}version>
    dependency>
 
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatisartifactId>
      <version>${mybatis.version}version>
    dependency>
    
    <dependency>
      <groupId>mysqlgroupId>
      <artifactId>mysql-connector-javaartifactId>
      <version>${mysql.version}version>
    dependency>
    
    <dependency>
      <groupId>com.github.pagehelpergroupId>
      <artifactId>pagehelperartifactId>
      <version>${pagehelper.version}version>
    dependency>
    
    <dependency>
      <groupId>org.mybatisgroupId>
      <artifactId>mybatis-springartifactId>
      <version>${mybatis.spring.version}version>
    dependency>
 
    
    <dependency>
      <groupId>org.apache.commonsgroupId>
      <artifactId>commons-dbcp2artifactId>
      <version>${commons.dbcp2.version}version>
    dependency>
    <dependency>
      <groupId>org.apache.commonsgroupId>
      <artifactId>commons-pool2artifactId>
      <version>${commons.pool2.version}version>
    dependency>
 
    
    
    <dependency>
      <groupId>org.apache.logging.log4jgroupId>
      <artifactId>log4j-coreartifactId>
      <version>${log4j2.version}version>
    dependency>
    <dependency>
      <groupId>org.apache.logging.log4jgroupId>
      <artifactId>log4j-apiartifactId>
      <version>${log4j2.version}version>
    dependency>
    
    <dependency>
      <groupId>org.apache.logging.log4jgroupId>
      <artifactId>log4j-webartifactId>
      <version>${log4j2.version}version>
    dependency>
 
    
    <dependency>
      <groupId>junitgroupId>
      <artifactId>junitartifactId>
      <version>${junit.version}version>
      <scope>testscope>
    dependency>
    <dependency>
      <groupId>javax.servletgroupId>
      <artifactId>javax.servlet-apiartifactId>
      <version>${servlet.version}version>
      <scope>providedscope>
    dependency>
    <dependency>
      <groupId>org.projectlombokgroupId>
      <artifactId>lombokartifactId>
      <version>${lombok.version}version>
      <scope>providedscope>
    dependency>
 
  dependencies>
 
  <build>
    <finalName>mavenTextfinalName>
    <resources>
 
      
      <resource>
        <directory>src/main/javadirectory>
        <includes>
          <include>**/*.xmlinclude>
        includes>
      resource>
      
      <resource>
        <directory>src/main/resourcesdirectory>
        <includes>
          <include>jdbc.propertiesinclude>
          <include>*.xmlinclude>
        includes>
      resource>
    resources>
    <pluginManagement>
      <plugins>
        <plugin>
          <groupId>org.apache.maven.pluginsgroupId>
          <artifactId>maven-compiler-pluginartifactId>
          <version>${maven.compiler.plugin.version}version>
          <configuration>
            <source>${maven.compiler.source}source>
            <target>${maven.compiler.target}target>
            <encoding>${project.build.sourceEncoding}encoding>
          configuration>
        plugin>
        <plugin>
          <groupId>org.mybatis.generatorgroupId>
          <artifactId>mybatis-generator-maven-pluginartifactId>
          <version>1.3.2version>
          <dependencies>
            
            <dependency>
              <groupId>mysqlgroupId>
              <artifactId>mysql-connector-javaartifactId>
              <version>${mysql.version}version>
            dependency>
          dependencies>
          <configuration>
            <overwrite>trueoverwrite>
          configuration>
        plugin>
 
        <plugin>
          <groupId>org.mybatis.generatorgroupId>
          <artifactId>mybatis-generator-maven-pluginartifactId>
          <version>1.3.2version>
 
          <dependencies>
            
            <dependency>
              <groupId>mysqlgroupId>
              <artifactId>mysql-connector-javaartifactId>
              <version>5.1.44version>
            dependency>
          dependencies>
          <configuration>
            <overwrite>trueoverwrite>
          configuration>
        plugin>
 
        <plugin>
          <artifactId>maven-clean-pluginartifactId>
          <version>3.1.0version>
        plugin>
        
        <plugin>
          <artifactId>maven-resources-pluginartifactId>
          <version>3.0.2version>
        plugin>
        <plugin>
          <artifactId>maven-compiler-pluginartifactId>
          <version>3.8.0version>
        plugin>
        <plugin>
          <artifactId>maven-surefire-pluginartifactId>
          <version>2.22.1version>
        plugin>
        <plugin>
          <artifactId>maven-war-pluginartifactId>
          <version>3.2.2version>
        plugin>
        <plugin>
          <artifactId>maven-install-pluginartifactId>
          <version>2.5.2version>
        plugin>
        <plugin>
          <artifactId>maven-deploy-pluginartifactId>
          <version>2.8.2version>
        plugin>
      plugins>
    pluginManagement>
  build>
project>

2.编写配置文件：applicationContext-mybatis.xml


<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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">
    
    
    <context:annotation-config/>
    
    <context:component-scan base-package="com.zq.ssm"/>
 
    <context:property-placeholder location="classpath:jdbc.properties"/>
 
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        
        <property name="initialSize" value="10"/>
        
        <property name="maxTotal" value="100"/>
        
        <property name="maxIdle" value="50"/>
        
        <property name="minIdle" value="10"/>
        
        
        <property name="maxWaitMillis" value="-1"/>
    bean>
 
    
    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        
        <property name="dataSource" ref="dataSource"/>
        
        <property name="mapperLocations" value="classpath*:com/javaxl/ssm/**/mapper/*.xml"/>
        
        <property name="typeAliasesPackage" value="com/javaxl/ssm/**/model"/>
        
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <value>
                            helperDialect=mysql
                        value>
                    property>
                bean>
            array>
        property>
    bean>
 
    
    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        
        
        <property name="basePackage" value="com/javaxl/ssm/**/mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    bean>
 
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    bean>
    <tx:annotation-driven transaction-manager="transactionManager" />
    <aop:aspectj-autoproxy/>
beans>

3.使用注解开发

@Repository：将DAO类声明为Bean

@Service：通常作用在业务层

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

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

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

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

4. 测试

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


package com.zq.biz.impl;
 
import com.zq.biz.BookBiz;
import com.zq.mapper.BookMapper;
import com.zq.model.Book;
import com.zq.model.BookVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
import java.util.Map;
 
 
@Service
public class BookBizImpl implements BookBiz {
 
    @Autowired
    private BookMapper bookMapper;
 
    //Alt+Enter 快速构建实现类，填充代码的前半部分 Ctrl+1
    //Alt+Insert 快速提供set/get/toString/构造方法
 
    /*public BookMapper getBookMapper() {
        return bookMapper;
    }
    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }*/
 
    @Override
    public int deleteByPrimaryKey(Integer bid) {
        return bookMapper.deleteByPrimaryKey(bid);
    }
 
    @Override
    public Book selectByPrimaryKey(Integer bid) {
        return bookMapper.selectByPrimaryKey(bid);
    }
 
    @Override
    public List selectByIn(List bookIds) {
        return bookMapper.selectByIn(bookIds);
    }
 
    public List selectBooksLike1(String bname){
        return  bookMapper.selectBooksLike1(bname);
    }
 
    public List selectBooksLike2(String bname){
        return  bookMapper.
    selectBooksLike2(bname);
}
 
    public List selectBooksLike3(String bname){
        return  bookMapper.selectBooksLike3(bname);
    }
 
    @Override
    public List list1() {
        return bookMapper.list1();
    }
 
    @Override
    public List list2() {
        return bookMapper.list2();
    }
 
    @Override
    public List list3(BookVo vo) {
        return bookMapper.list3(vo);
    }
 
    @Override
    public List list4() {
        return bookMapper.list4();
    }
 
    @Override
    public Map list5(Map map) {
        return bookMapper.list5(map);
    }
 
    @Override
    public List list6(BookVo bookVo) {
        return bookMapper.list6(bookVo);
    }
 
    @Override
    public List list7(BookVo bookVo) {
        return list7(bookVo);
    }
 
}

5. 管理数据源 -> 管理sqlsession

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

然后在测试类里面添加：
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={“classpath:applicationContext-mybatis.xml”})


package com.zq.biz.impl;
 
import com.zq.biz.BookBiz;
import com.zq.mapper.BookMapper;
import com.zq.model.BookVo;
import com.zq.util.SessionUtil;
import com.zq.biz.impl.BookBizImpl;
import org.apache.ibatis.session.SqlSession;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
 
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
import static org.junit.Assert.*;
 
 
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:applicationContext-mybatis.xml"})
public class BookBizImplTest {
 
    private BookBiz bookBiz;
    private SqlSession sqlSession;
 
    @Before
    public void setUp() throws Exception {
        System.out.println("初始化方法...");
        BookBizImpl bookBiz = new BookBizImpl();
        //工具类中获取session对象
        sqlSession = SessionUtil.openSession();
        System.out.println(sqlSession+"初始化方法");
        //从session对象中获取mapper对象
        BookMapper mapper = sqlSession.getMapper(BookMapper.class);
        bookBiz.setBookMapper(mapper);
        this.bookBiz = bookBiz;
    }
 
    @After
    public void tearDown() throws Exception {
        System.out.println("方法测试结束...");
        System.out.println(sqlSession);
        sqlSession.commit();
        sqlSession.close();
    }
 
    @Test
    public void deleteByPrimaryKey() {
        bookBiz.deleteByPrimaryKey(44);
        sqlSession.commit();
        sqlSession.close();
    }
 
    @Test
    public void selectByPrimaryKey() {
        System.out.println("测试的业务方法...");
        System.out.println(bookBiz.selectByPrimaryKey(44));
    }
 
    @Test
    public void text3() {
       int[] ints = {1,2,3,4};
       //将数组变为字符串
        StringBuffer sb = new StringBuffer();
        for (int i : ints){
            sb.append(",").append(i);
        }
        String s = sb.toString();
        System.out.println(s.substring(1));
    }
 
    @Test
    public void selectByIn() {
        List integers = Arrays.asList(new Integer[] {33,34,32});
        bookBiz.selectByIn(integers).forEach(System.out::println);
    }
 
    @Test
    public void selectBooksLike1() {
        bookBiz.selectBooksLike1("%圣嘘%").forEach(System.out::println);
    }
 
    @Test
    public void selectBooksLike2() {
        bookBiz.selectBooksLike2("%圣嘘%").forEach(System.out::println);
    }
 
    @Test
    public void selectBooksLike3() {
        bookBiz.selectBooksLike3("圣嘘").forEach(System.out::println);
    }
 
    @Test
    public void list1() {
        bookBiz.list1().forEach(System.out::println);
    }
 
    @Test
    public void list2() {
        bookBiz.list2().forEach(System.out::println);
    }
 
    @Test
    public void list3() {
        BookVo vo = new BookVo();
        vo.setBooKIds(Arrays.asList(new Integer[]{31,32,33,34}));
        bookBiz.list3(vo).forEach(System.out::println);
    }
 
    @Test
    public void list4() {
        bookBiz.list4().forEach(System.out::println);
    }
 
    @Test
    public void list5() {
        Map map = new HashMap();
        map.put("bid",32);
        System.out.println(bookBiz.list5(map));
    }
 
    @Test
    public void list6() {
        BookVo vo = new BookVo();
        vo.setMax(45);
        vo.setMin(35);
        bookBiz.list6(vo).forEach(System.out::println);
    }
 
    @Test
    public void list7() {
        BookVo vo = new BookVo();
        vo.setMax(45);
        vo.setMin(35);
        bookBiz.list7(vo).forEach(System.out::println);
    }
}

二、AOP整合pagehelper插件

待解决问题：

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

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

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

2、写通知

2.1 目标对象该方法一定携带了PageBean对象
注解：@aspect：相当于配置了环绕通知

@component：交给Spring进行管理

@excution

3、建立一个切面类：PageAspect


package com.zq.ssm.aspect;
 
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zq.ssm.entity.PageBean;
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.springframework.stereotype.Component;
 
import java.util.List;
 
@Component
@Aspect
public class PageAspect {
 
    /**
     * *：返回值
     * *..：无限包
     * *Service：以Service结尾的接口名
     * .Pager：以Pager方法
     * 只要同时匹配上诉四个条件，就会被列为目标对象
     * 上诉配置要生效，代理注释一定要打开：
     * @param args
     * @return
     * @throws Throwable
     */
    @Around("execution(* *..*Biz.*Pager(..))")
    public Object invoke(ProceedingJoinPoint args) throws Throwable {
        Object[] params = args.getArgs();
        PageBean pageBean = null;
        for (Object param : params) {
            if(param instanceof PageBean){
                pageBean = (PageBean)param;
                break;
            }
        }
 
        if(pageBean != null && pageBean.isPagination())
            PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
 
        Object list = args.proceed(params);
 
        if(null != pageBean && pageBean.isPagination()){
            PageInfo pageInfo = new PageInfo((List) list);
            pageBean.setTotal(pageInfo.getTotal()+"");
        }
        return list;
    }
}

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

相关阅读:
使用 Data Assistant 快速创建测试数据集
 线程本地存储 ThreadLocal
原生js+css制作--可以弹奏的吉他
 《位图BitMap - 基于java实现》
模型部署踩坑(持续更新ing)
分布式中的常见问题
 LOCK接口
 python算法
 开启潮玩文化新篇章，泡泡玛特首届海外PTS潮玩成功落地新加坡
 GDP-海藻糖，5‘-鸟苷二磷酸岩藻糖，GDP-fucose ，CAS：15839-70-0
原文地址：https://blog.csdn.net/weixin_66110079/article/details/126344288