Spring学习(四)——Spring整合Mybatis

一、引入依赖

 	<!--  mysql -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

    <!-- druid -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.12</version>
    </dependency>

    <!-- Spring JDBC -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!-- Mybatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.2.8</version>
    </dependency>

    <!-- mybatis-spring -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>

二、配置文件和相关类

spring.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!-- 数据源 -->
    <bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test?characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>

    <!-- SqlSessionFactory -->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:cool/gjh/mapper/*Mapper.xml"/>
        <property name="typeAliasesPackage" value="cool.gjh.entity"/>
    </bean>

    <!-- 获取DAO对象 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" id="scannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sessionFactoryBean"/>
        <property name="basePackage" value="cool.gjh.dao"/>
    </bean>

</beans>

JavaConfig配置类(混合配置)

重点是注解@ImportResource("classpath:cool/gjh/spring/spring.xml")

package cool.gjh.config;

import cool.gjh.zoo.Animal;
import cool.gjh.zoo.ZooFactory;
import org.springframework.context.annotation.*;

/**
 * Spring配置类
 *
 * @author ACE_GJH
 */
@EnableAspectJAutoProxy
@ComponentScan(basePackages = "cool.gjh")
@Configuration
@ImportResource("classpath:cool/gjh/spring/spring.xml")
public class Config {

    @Bean(name = "singleDog")
    public Animal dog(){
        return ZooFactory.getAnimalByName("Dog");
    }

    @Bean
    public Animal cat(){
        return ZooFactory.getAnimalByName("Cat");
    }

}

DAO接口

package cool.gjh.dao;

import cool.gjh.entity.Student;

import java.util.List;

/**
 * 测试DAO
 *
 * @author ACE_GJH
 */
public interface StudentDao {

    /**
     * 查询所有同学信息
     *
     * @return 所有同学
     */
    List<Student> selectAll();

}

mapper.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<!-- 指定DAO接口全类名 -->
<mapper namespace="cool.gjh.dao.StudentDao">

    <select id="selectAll" resultType="Student">
        select id, name, age, birthday, sex, height, weight from test_student
    </select>

</mapper>

sql建表

/*==============================================================*/
/* DBMS name:      MySQL 5.0                                    */
/* Created on:     2020/6/12 17:25:32                           */
/*==============================================================*/


drop table if exists test_student;

/*==============================================================*/
/* Table: test_student                                               */
/*==============================================================*/
create table test_student
(
   id                   varchar(40) not null,
   name                 varchar(30),
   age                  int(3),
   birthday             date,
   sex                  int(1),
   height               double,
   weight               double,
   primary key (id)
);

插入数据：

测试类

package test.cool.gjh.spring;

import cool.gjh.config.Config;
import cool.gjh.dao.StudentDao;
import cool.gjh.entity.Student;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import java.util.List;

/**
 * 测试Spring整合Mybatis
 */
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = Config.class)
public class SpringMybatisTest {

    @Autowired
    private StudentDao studentDao;

    /**
     * 测试Mybatis
     */
    @Test
    public void testSpringMybatis(){
        List<Student> students = studentDao.selectAll();
        for (Student student : students) {
            System.out.println(student);
        }
    }

}

测试结果：

三、事务管理

spring.xml添加事务配置

    <!-- spring JDBC提供的事务管理器 -->
    <bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager" id="transactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- 配置事务通知 -->
    <tx:advice transaction-manager="transactionManager" id="transactionInterceptor">
        <!-- 设置事务的传播属性 -->
        <tx:attributes>
            <tx:method name="getAll*" propagation="SUPPORTS"/>
        </tx:attributes>
    </tx:advice>

    <!-- 配置事务切面 -->
    <aop:config>
        <aop:pointcut id="pointcut1" expression="execution(* cool.gjh.service.*.*(..))"/>
        <aop:advisor advice-ref="transactionInterceptor" pointcut-ref="pointcut1"/>
    </aop:config>

service类

package cool.gjh.service;

import cool.gjh.dao.StudentDao;
import cool.gjh.entity.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

/**
 * @author ACE_GJH
 */
@Service
public class StudentServiceImpl implements StudentService{

    @Autowired
    private StudentDao studentDao;


    /**
     * 获取所有同学信息
     *
     * @return 所有同学
     */
    @Override
    public List<Student> getAllStudent() {
        return studentDao.selectAll();
    }
}

测试代码

    @Autowired
    private StudentService studentService;

   /**
     * 测试事务
     */
    @Test
    public void testSpringMybatis2(){
        List<Student> allStudent = studentService.getAllStudent();
        for (Student student : allStudent) {
            System.out.println(student);
        }
    }

测试结果：