第一章：思路

Spring 和 Mybatis 整合思路.png

第二章：Mybatis - Spring 技术

  • 官网。
  • 相关技术之间版本匹配说明：

Mybatis - Spring 技术版本匹配.png

  • Mybatis-Spring 的依赖：
  1. <dependency>
  2.     <groupId>org.mybatis</groupId>
  3.     <artifactId>mybatis-spring</artifactId>
  4.     <version>2.0.6</version>
  5. </dependency>

第三章：总体 SSM 整合所需依赖

  • pom.xml
  1. <!-- Mybatis 整合 Spring -->
  2. <dependency>
  3.     <groupId>org.mybatis</groupId>
  4.     <artifactId>mybatis-spring</artifactId>
  5.     <version>2.0.6</version>
  6. </dependency>
  7. <!-- SpringMVC -->
  8. <dependency>
  9.     <groupId>org.springframework</groupId>
  10.     <artifactId>spring-webmvc</artifactId>
  11.     <version>5.3.12</version>
  12. </dependency>
  13. <!-- Spring 持久化层所需依赖 -->
  14. <dependency>
  15.     <groupId>org.springframework</groupId>
  16.     <artifactId>spring-orm</artifactId>
  17.     <version>5.3.12</version>
  18. </dependency>
  19. <!-- 日志 -->
  20. <dependency>
  21.     <groupId>ch.qos.logback</groupId>
  22.     <artifactId>logback-classic</artifactId>
  23.     <version>1.2.7</version>
  24. </dependency>
  25. <!-- ServletAPI -->
  26. <dependency>
  27.     <groupId>javax.servlet</groupId>
  28.     <artifactId>javax.servlet-api</artifactId>
  29.     <version>4.0.1</version>
  30.     <scope>provided</scope>
  31. </dependency>
  32. <!-- Spring5和Thymeleaf整合包 -->
  33. <dependency>
  34.     <groupId>org.thymeleaf</groupId>
  35.     <artifactId>thymeleaf-spring5</artifactId>
  36.     <version>3.0.12.RELEASE</version>
  37. </dependency>
  38. <!-- Mybatis核心 -->
  39. <dependency>
  40.     <groupId>org.mybatis</groupId>
  41.     <artifactId>mybatis</artifactId>
  42.     <version>3.5.7</version>
  43. </dependency>
  44. <!-- MySQL驱动 -->
  45. <dependency>
  46.     <groupId>mysql</groupId>
  47.     <artifactId>mysql-connector-java</artifactId>
  48.     <version>8.0.25</version>
  49. </dependency>
  50. <!-- 数据源 -->
  51. <dependency>
  52.     <groupId>com.alibaba</groupId>
  53.     <artifactId>druid</artifactId>
  54.     <version>1.2.8</version>
  55. </dependency>
  56. <!-- junit5 -->
  57. <dependency>
  58.     <groupId>org.junit.jupiter</groupId>
  59.     <artifactId>junit-jupiter-api</artifactId>
  60.     <version>5.8.1</version>
  61.     <scope>test</scope>
  62. </dependency>
  63. <!-- Spring 的测试功能 -->
  64. <dependency>
  65.     <groupId>org.springframework</groupId>
  66.     <artifactId>spring-test</artifactId>
  67.     <version>5.3.12</version>
  68. </dependency>
  69. <!-- Lombok -->
  70. <dependency>
  71.     <groupId>org.projectlombok</groupId>
  72.     <artifactId>lombok</artifactId>
  73.     <version>1.18.22</version>
  74.     <scope>provided</scope>
  75. </dependency>

第四章：配置数据源

4.1 创建 jdbc.properties

  • jdbc.properties
  1. jdbc.user=root
  2. jdbc.password=123456
  3. jdbc.url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true&allowMultiQueries=true
  4. jdbc.driver=com.mysql.cj.jdbc.Driver

4.2 加入日志配置文件

  • logback.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <configuration debug="true">
  3.     <!-- 指定日志输出的位置 -->
  4.     <appender name="STDOUT"
  5.               class="ch.qos.logback.core.ConsoleAppender">
  6.         <encoder>
  7.             <!-- 日志输出的格式 -->
  8.             <!-- 按照顺序分别是：时间、日志级别、线程名称、打印日志的类、日志主体内容、换行 -->
  9.             <pattern>[%d{HH:mm:ss.SSS}] [%-5level] [%thread] [%logger] [%msg]%n</pattern>
  10.             <charset>UTF-8</charset>
  11.         </encoder>
  12.     </appender>
  14.     <!-- 设置全局日志级别。日志级别按顺序分别是：DEBUG、INFO、WARN、ERROR -->
  15.     <!-- 指定任何一个日志级别都只打印当前级别和后面级别的日志。 -->
  16.     <root level="INFO">
  17.         <!-- 指定打印日志的appender，这里通过“STDOUT”引用了前面配置的appender -->
  18.         <appender-ref ref="STDOUT" />
  19.     </root>
  21.     <!-- 根据特殊需求指定局部日志级别 -->
  22.     <logger name="org.springframework.web.servlet.DispatcherServlet" level="DEBUG" />
  24. </configuration>

4.3 创建 Spring 的配置文件

  • spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  7.     <!-- 加载外部属性配置文件 -->
  8.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  10.     <!-- 配置数据源 -->
  11.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  12.         <property name="url" value="${jdbc.url}"/>
  13.         <property name="password" value="${jdbc.password}"/>
  14.         <property name="driverClassName" value="${jdbc.driver}"/>
  15.         <property name="username" value="${jdbc.user}"/>
  16.     </bean>
  18. </beans>

4.3 创建 Junit 测试

  1. package com.github.fairy.era;
  3. import lombok.extern.slf4j.Slf4j;
  4. import org.junit.jupiter.api.Test;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;
  8. import javax.sql.DataSource;
  11. /**
  12.  * @author 许大仙
  13.  * @version 1.0
  14.  * @since 2021-11-22 09:25
  15.  */
  16. @SpringJUnitConfig(locations = {"classpath:spring-persist.xml"})
  17. @Slf4j
  18. public class SpringTest {
  19.     @Autowired
  20.     private DataSource dataSource;
  22.     @Test
  23.     public void test() {
  24.         log.info(" dataSource = " + dataSource);
  25.     }
  27. }

第五章：配置 SqlSessionFactoryBean

5.1 创建 Mybatis 全局配置文件

  • mybatis-config.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  7.     <!-- Mybatis全局配置 -->
  8.     <settings>
  9.         <!-- 将数据库表字段映射到驼峰式命名的Java实体类属性中 -->
  10.         <!-- 数据库表字段格式：单词_单词 -->
  11.         <!-- Java实体类属性：首字母小写的驼峰式命名 -->
  12.         <setting name="mapUnderscoreToCamelCase" value="true"/>
  13.     </settings>
  15. </configuration>

5.2 数据库脚本

  1. SET NAMES utf8mb4;
  2. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- 创建数据库
  6. -- ----------------------------
  7. CREATE DATABASE IF NOT EXISTS `ssm` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  9. -- ----------------------------
  10. -- 创建表
  11. -- ----------------------------
  12. DROP TABLE IF EXISTS `employee`;
  13. CREATE TABLE `employee`  (
  14.   `id` int(11) NOT NULL AUTO_INCREMENT,
  15.   `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  16.   `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  17.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  18.   PRIMARY KEY (`id`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  21. -- ----------------------------
  22. -- 插入数据
  23. -- ----------------------------
  24. INSERT INTO `employee` VALUES (1, 'jerry', '男', 'jerry@qq.com');
  25. INSERT INTO `employee` VALUES (2, 'aa', '男', 'aa@11.com');
  26. INSERT INTO `employee` VALUES (3, 'bb', '男', 'bb@11.com');
  27. INSERT INTO `employee` VALUES (4, 'aa', '男', 'aa@11.com');
  28. INSERT INTO `employee` VALUES (5, 'bb', '男', 'bb@11.com');
  30. SET FOREIGN_KEY_CHECKS = 1;

5.3 创建实体类

  • Employee.java
  1. package com.github.fairy.era.entity;
  3. import lombok.Data;
  5. /**
  6.  * @author 许大仙
  7.  * @version 1.0
  8.  * @since 2021-11-22 09:42
  9.  */
  10. @Data
  11. public class Employee {
  13.     private Integer id;
  15.     private String lastName;
  17.     private String gender;
  19.     private String email;
  20. }

5.4 创建 Mapper 接口

  • EmployeeMapper.java
  1. package com.github.fairy.era.mapper;
  3. import com.github.fairy.era.entity.Employee;
  5. import java.util.List;
  7. /**
  8.  * @author 许大仙
  9.  * @version 1.0
  10.  * @since 2021-11-22 09:56
  11.  */
  12. public interface EmployeeMapper {
  14.     List<Employee> findAll();
  15. }

5.5 创建 Mapper 配置文件

  • EmployeeMapper.xml
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  6. <!-- mapper是根标签。namespace属性是找到当前配置的依据 -->
  7. <!-- 由于最理想的Mybatis使用方式是：通过Mapper接口调用接口方法，访问数据库 -->
  8. <!-- 这样的理想方式要求：能够通过接口全类名找到Mapper配置 -->
  9. <!-- 所以：我们就用Mapper接口的全类名来给namespace属性赋值 -->
  10. <mapper namespace="com.github.fairy.era.mapper.EmployeeMapper">
  13.     <select id="findAll" resultType="com.github.fairy.era.entity.Employee">
  14.         SELECT id,last_name,gender,email 
  15.         FROM employee
  16.     </select>
  18. </mapper>

5.6 配置 sqlSessionFactoryBean

5.6.1 保留 Mybatis 全局配置文件

  • spring-persist.xml
  1. <!-- 配置 sessionFactoryBean -->
  2. <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  3.     <!-- 数据源 -->
  4.     <property name="dataSource" ref="dataSource"/>
  5.     <!-- 指定 Mybatis 全局配置文件位置 -->
  6.     <property name="configLocation" value="classpath:mybatis-config.xml"/>
  7.     <!-- 指定 Mapper 配置文件位置 -->
  8.     <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  9. </bean>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  7.     <!-- 加载外部属性配置文件 -->
  8.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  10.     <!-- 配置数据源 -->
  11.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  12.         <property name="url" value="${jdbc.url}"/>
  13.         <property name="password" value="${jdbc.password}"/>
  14.         <property name="driverClassName" value="${jdbc.driver}"/>
  15.         <property name="username" value="${jdbc.user}"/>
  16.     </bean>
  18.     <!-- 配置 sessionFactoryBean -->
  19.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  20.         <!-- 数据源 -->
  21.         <property name="dataSource" ref="dataSource"/>
  22.         <!-- 指定 Mybatis 全局配置文件位置 -->
  23.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  24.         <!-- 指定 Mapper 配置文件位置 -->
  25.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  26.     </bean>
  28. </beans>

5.6.2 彻底舍弃 Mybatis 全局配置文件

  • spring-persist.xml
  1. <!-- 配置 sessionFactoryBean -->
  2. <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  3.     <!-- 数据源 -->
  4.     <property name="dataSource" ref="dataSource"/>
  5.     <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  6.     <property name="configuration">
  7.         <bean class="org.apache.ibatis.session.Configuration">
  8.             <property name="mapUnderscoreToCamelCase" value="true"/>
  9.         </bean>
  10.     </property>
  11.     <!-- 指定 Mapper 配置文件位置 -->
  12.     <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  13. </bean>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  7.     <!-- 加载外部属性配置文件 -->
  8.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  10.     <!-- 配置数据源 -->
  11.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  12.         <property name="url" value="${jdbc.url}"/>
  13.         <property name="password" value="${jdbc.password}"/>
  14.         <property name="driverClassName" value="${jdbc.driver}"/>
  15.         <property name="username" value="${jdbc.user}"/>
  16.     </bean>
  18.     <!-- 配置 sessionFactoryBean -->
  19.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  20.         <!-- 数据源 -->
  21.         <property name="dataSource" ref="dataSource"/>
  22.         <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  23.         <property name="configuration">
  24.             <bean class="org.apache.ibatis.session.Configuration">
  25.                 <property name="mapUnderscoreToCamelCase" value="true"/>
  26.             </bean>
  27.         </property>
  28.         <!-- 指定 Mapper 配置文件位置 -->
  29.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  30.     </bean>
  32. </beans>

注意：上面两种方式如果并存，会抛出异常：java.lang.IllegalStateException: Property ‘configuration’ and ‘configLocation’ can not specified with together

5.7 配置 Mapper 接口的扫描器

5.7.1 使用扫描器

  • spring-persist.xml
  1. <!-- 配置 Mapper 接口 bean 的扫描器 -->
  2. <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  3.     <property name="basePackage" value="com.github.fairy.era.mapper"/>
  4. </bean>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  7.     <!-- 加载外部属性配置文件 -->
  8.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  10.     <!-- 配置数据源 -->
  11.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  12.         <property name="url" value="${jdbc.url}"/>
  13.         <property name="password" value="${jdbc.password}"/>
  14.         <property name="driverClassName" value="${jdbc.driver}"/>
  15.         <property name="username" value="${jdbc.user}"/>
  16.     </bean>
  18.     <!-- 配置 sessionFactoryBean -->
  19.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  20.         <!-- 数据源 -->
  21.         <property name="dataSource" ref="dataSource"/>
  22.         <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  23.         <property name="configuration">
  24.             <bean class="org.apache.ibatis.session.Configuration">
  25.                 <property name="mapUnderscoreToCamelCase" value="true"/>
  26.             </bean>
  27.         </property>
  28.         <!-- 指定 Mapper 配置文件位置 -->
  29.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  30.     </bean>
  32.     <!-- 配置 Mapper 接口 bean 的扫描器 -->
  33.     <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  34.         <property name="basePackage" value="com.github.fairy.era.mapper"/>
  35.     </bean>
  37. </beans>

5.7.2 使用 mybatis-spring 名称空间

  • spring-persist.xml
  1. <!-- 使用 mybatis-spring 名称空间 -->
  2. <mybatis-spring:scan base-package="com.github.fairy.era.mapper"/>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">
  8.     <!-- 加载外部属性配置文件 -->
  9.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  11.     <!-- 配置数据源 -->
  12.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  13.         <property name="url" value="${jdbc.url}"/>
  14.         <property name="password" value="${jdbc.password}"/>
  15.         <property name="driverClassName" value="${jdbc.driver}"/>
  16.         <property name="username" value="${jdbc.user}"/>
  17.     </bean>
  19.     <!-- 配置 sessionFactoryBean -->
  20.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  21.         <!-- 数据源 -->
  22.         <property name="dataSource" ref="dataSource"/>
  23.         <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  24.         <property name="configuration">
  25.             <bean class="org.apache.ibatis.session.Configuration">
  26.                 <property name="mapUnderscoreToCamelCase" value="true"/>
  27.             </bean>
  28.         </property>
  29.         <!-- 指定 Mapper 配置文件位置 -->
  30.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  31.     </bean>
  33.     <!-- 使用 mybatis-spring 名称空间 -->
  34.     <mybatis-spring:scan base-package="com.github.fairy.era.mapper"/>
  36. </beans>

注意：两种方式任选一种即可。

5.8 测试

  1. package com.github.fairy.era;
  3. import com.github.fairy.era.mapper.EmployeeMapper;
  4. import lombok.extern.slf4j.Slf4j;
  5. import org.junit.jupiter.api.Test;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;
  10. /**
  11.  * @author 许大仙
  12.  * @version 1.0
  13.  * @since 2021-11-22 09:25
  14.  */
  15. @SpringJUnitConfig(locations = {"classpath:spring-persist.xml"})
  16. @Slf4j
  17. public class SpringTest {
  20.     @Autowired
  21.     private EmployeeMapper employeeMapper;
  23.     @Test
  24.     public void test() {
  25.         System.out.println("employeeMapper = " + employeeMapper);
  26.     }
  28. }

第六章：加入声明式事务

6.1 配置事务管理器

  • spring-persist.xml
  1. <!-- 配置事务管理器 -->
  2. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  3.     <property name="dataSource" ref="dataSource"/>
  4. </bean>
  5. <!-- 开启基于注解的事务支持 -->
  6. <tx:annotation-driven transaction-manager="transactionManager"/>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  6.        xmlns:tx="http://www.springframework.org/schema/tx"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
  9.     <!-- 加载外部属性配置文件 -->
  10.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  12.     <!-- 配置数据源 -->
  13.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  14.         <property name="url" value="${jdbc.url}"/>
  15.         <property name="password" value="${jdbc.password}"/>
  16.         <property name="driverClassName" value="${jdbc.driver}"/>
  17.         <property name="username" value="${jdbc.user}"/>
  18.     </bean>
  20.     <!-- 配置 sessionFactoryBean -->
  21.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  22.         <!-- 数据源 -->
  23.         <property name="dataSource" ref="dataSource"/>
  24.         <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  25.         <property name="configuration">
  26.             <bean class="org.apache.ibatis.session.Configuration">
  27.                 <property name="mapUnderscoreToCamelCase" value="true"/>
  28.             </bean>
  29.         </property>
  30.         <!-- 指定 Mapper 配置文件位置 -->
  31.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  32.     </bean>
  34.     <!-- 使用 mybatis-spring 名称空间 -->
  35.     <mybatis-spring:scan base-package="com.github.fairy.era.mapper"/>
  37.     <!-- 配置事务管理器 -->
  38.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  39.         <property name="dataSource" ref="dataSource"/>
  40.     </bean>
  41.     <!-- 开启基于注解的事务支持 -->
  42.     <tx:annotation-driven transaction-manager="transactionManager"/>
  44. </beans>

6.2 创建Service组件

  • EmployeeService.java
  1. package com.github.fairy.era.service;
  3. import com.github.fairy.era.entity.Employee;
  5. import java.util.List;
  7. /**
  8.  * @author 许大仙
  9.  * @version 1.0
  10.  * @since 2021-11-22 12:38
  11.  */
  12. public interface EmployeeService {
  14.     List<Employee> findAll();
  15. }
  • EmployeeServiceImpl.java
  1. package com.github.fairy.era.service.impl;
  3. import com.github.fairy.era.entity.Employee;
  4. import com.github.fairy.era.mapper.EmployeeMapper;
  5. import com.github.fairy.era.service.EmployeeService;
  6. import lombok.RequiredArgsConstructor;
  7. import org.springframework.stereotype.Service;
  8. import org.springframework.transaction.annotation.Transactional;
  10. import java.util.List;
  12. /**
  13.  * @author 许大仙
  14.  * @version 1.0
  15.  * @since 2021-11-22 12:39
  16.  */
  17. @Service
  18. @Transactional(rollbackFor = Exception.class,readOnly = true)
  19. @RequiredArgsConstructor
  20. public class EmployeeServiceImpl implements EmployeeService {
  22.     private final EmployeeMapper employeeMapper;
  24.     @Override
  25.     public List<Employee> findAll() {
  26.         return employeeMapper.findAll();
  27.     }
  28. }

6.3 配置自动扫描的包

  • spring-persist.xml
  1. <!-- 配置自动扫描的包 -->
  2. <context:component-scan base-package="com.github.fairy.era.service"/>
  • 完整的 spring-persist.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  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"
  5.        xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
  6.        xmlns:tx="http://www.springframework.org/schema/tx"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
  9.     <!-- 加载外部属性配置文件 -->
  10.     <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
  12.     <!-- 配置数据源 -->
  13.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  14.         <property name="url" value="${jdbc.url}"/>
  15.         <property name="password" value="${jdbc.password}"/>
  16.         <property name="driverClassName" value="${jdbc.driver}"/>
  17.         <property name="username" value="${jdbc.user}"/>
  18.     </bean>
  20.     <!-- 配置 sessionFactoryBean -->
  21.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  22.         <!-- 数据源 -->
  23.         <property name="dataSource" ref="dataSource"/>
  24.         <!-- 舍弃 Mybatis 全局配置文件，使用 configuration 属性 -->
  25.         <property name="configuration">
  26.             <bean class="org.apache.ibatis.session.Configuration">
  27.                 <property name="mapUnderscoreToCamelCase" value="true"/>
  28.             </bean>
  29.         </property>
  30.         <!-- 指定 Mapper 配置文件位置 -->
  31.         <property name="mapperLocations" value="classpath*:com/github/fairy/era/mapper/*Mapper.xml"/>
  32.     </bean>
  34.     <!-- 使用 mybatis-spring 名称空间 -->
  35.     <mybatis-spring:scan base-package="com.github.fairy.era.mapper"/>
  37.     <!-- 配置事务管理器 -->
  38.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  39.         <property name="dataSource" ref="dataSource"/>
  40.     </bean>
  41.     <!-- 开启基于注解的事务支持 -->
  42.     <tx:annotation-driven transaction-manager="transactionManager"/>
  44.     <!-- 配置自动扫描的包 -->
  45.     <context:component-scan base-package="com.github.fairy.era.service"/>
  47. </beans>

6.4 测试

  1. package com.github.fairy.era;
  3. import com.github.fairy.era.service.EmployeeService;
  4. import lombok.extern.slf4j.Slf4j;
  5. import org.junit.jupiter.api.Test;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.test.context.junit.jupiter.SpringJUnitConfig;
  9. /**
  10.  * @author 许大仙
  11.  * @version 1.0
  12.  * @since 2021-11-22 09:25
  13.  */
  14. @SpringJUnitConfig(locations = {"classpath:spring-persist.xml"})
  15. @Slf4j
  16. public class SpringTest {
  18.     @Autowired
  19.     private EmployeeService employeeService;
  21.     @Test
  22.     public void test() {
  23.         employeeService.findAll().forEach(System.out::println);
  24.     }
  26. }