Mybatis详解（一）配置Mybatis集成SpringBoot

1、在pom.xml配置文件中引用常用的Jar包的坐标

<?xml version="1.0" encoding="UTF-8"?>
<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.0</modelVersion>
   <parent>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-parent</artifactId>
      <version>2.1.5.RELEASE</version>
      <relativePath/> <!-- lookup parent from repository -->
   </parent>
   <groupId>com.example</groupId>
   <artifactId>demo</artifactId>
   <version>0.0.1-SNAPSHOT</version>
   <name>demo</name>
   <description>Demo project for Spring Boot</description>
   <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
      <java.version>1.8</java.version>
   </properties>

   <dependencies>
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter</artifactId>
      </dependency>
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-web</artifactId>
      </dependency>
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-test</artifactId>
         <scope>test</scope>
      </dependency>
      <dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
         <version>1.18.4</version>
         <scope>provided</scope>
      </dependency>
      <dependency>
         <groupId>com.google.guava</groupId>
         <artifactId>guava</artifactId>
         <version>27.0.1-jre</version>
      </dependency>
      <dependency>
         <groupId>org.apache.commons</groupId>
         <artifactId>commons-lang3</artifactId>
         <version>3.8.1</version>
      </dependency>

      <dependency>
         <groupId>org.apache.commons</groupId>
         <artifactId>commons-collections4</artifactId>
         <version>4.3</version>
      </dependency>

      <dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>fastjson</artifactId>
         <version>1.2.47</version>
      </dependency>
      <dependency>
         <groupId>org.apache.httpcomponents</groupId>
         <artifactId>httpclient</artifactId>
      </dependency>
      <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
      <dependency>
         <groupId>org.mybatis.spring.boot</groupId>
         <artifactId>mybatis-spring-boot-starter</artifactId>
         <version>1.3.2</version>
      </dependency>
      <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
      <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
         <version>8.0.15</version>
      </dependency>
      <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
      <dependency>
         <groupId>com.alibaba</groupId>
         <artifactId>druid</artifactId>
         <version>1.1.16</version>
      </dependency>
      <!-- spring上下文支持 -->
      <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-context-support</artifactId>
      </dependency>
      <!-- 支持jsp处理 -->
      <dependency>
         <groupId>org.apache.tomcat.embed</groupId>
         <artifactId>tomcat-embed-jasper</artifactId>
      </dependency>
      <!-- 配合jsp处理js等文件 -->
      <dependency>
         <groupId>javax.servlet</groupId>
         <artifactId>javax.servlet-api</artifactId>
      </dependency>
      <!--jsp依赖jar-->
      <dependency>
         <groupId>javax.servlet.jsp</groupId>
         <artifactId>javax.servlet.jsp-api</artifactId>
         <version>2.3.1</version>
      </dependency>
      <!--Jstl标签依赖的jar包start-->
      <dependency>
         <groupId>javax.servlet</groupId>
         <artifactId>jstl</artifactId>
      </dependency>
      <!-- 对jdbc的支持 -->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-jdbc</artifactId>
      </dependency>
      <!--<dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-web</artifactId>
      </dependency>-->
      <!--再在你的配置类开头加上@PropertySource("classpath:your.properties")，其余用法与加载yml的配置一样-->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-configuration-processor</artifactId>
         <optional>true</optional>
      </dependency>
      <dependency>
         <groupId>javax.persistence</groupId>
         <artifactId>persistence-api</artifactId>
         <version>1.0.2</version>
      </dependency>
      <!-- 添加springboot对amqp的支持 -->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-amqp</artifactId>
      </dependency>

      <dependency>
         <groupId>org.mybatis.generator</groupId>
         <artifactId>mybatis-generator-core</artifactId>
         <version>1.3.5</version>
      </dependency>
      <!-- https://mvnrepository.com/artifact/log4j/log4j -->
      <dependency>
         <groupId>log4j</groupId>
         <artifactId>log4j</artifactId>
         <version>1.2.17</version>
      </dependency>
        <!--redis支持-->
      <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-data-redis</artifactId>
      </dependency>
      <dependency>
         <groupId>redis.clients</groupId>
         <artifactId>jedis</artifactId>
      </dependency>
   </dependencies>

   <!--测试出错，不影响编译结果-->
   <build>
      <plugins>
         <plugin>
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-surefire-plugin</artifactId>
            <configuration>
               <testFailureIgnore>true</testFailureIgnore>
            </configuration>
         </plugin>
         <!--mybatis逆向工程-->
         <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.2</version>
            <configuration>
            <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
               <verbose>true</verbose>
               <overwrite>true</overwrite>
            </configuration>
            <dependencies>
               <dependency>
                  <groupId>mysql</groupId>
                  <artifactId>mysql-connector-java</artifactId>
                  <version>5.1.44</version>
               </dependency>
            </dependencies>
         </plugin>
      </plugins>
   </build>
</project>

2、配置application.properties文件

数据库配置：

# mysql
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/demo?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root123

# mybatis
mybatis.mapper-locations=classpath:sqlmap/*.xml
mybatis.type-aliases-package=com.example.demo.entity

#打印SQL语句
logging.level.root=info
logging.level.com.bloc.core.mapper=debug

3、配置数据源MybatisConfig

@Configuration
public class MybatisConfig {
	
	    @Autowired
	    private DataSourceProperties dataSourceProperties;
	    private static final String MAPPER_LOCATION = "classpath:sqlmap/*.xml";
	    @Bean(name = "dataSource")
	    public DataSource dataSource() {
	        DruidDataSource dataSource = new DruidDataSource();
	        dataSource.setUrl(dataSourceProperties.getUrl());
	        System.out.println(dataSourceProperties.getUrl());
	        dataSource.setDriverClassName(dataSourceProperties.getDriverClassName());
	        dataSource.setUsername(dataSourceProperties.getUsername());
	        dataSource.setPassword(dataSourceProperties.getPassword());
	        return dataSource;
	    }
	    @Bean
	    public SqlSessionFactory sqlSessionFactory() throws Exception {
	        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
	        sqlSessionFactoryBean.setDataSource(dataSource());
	        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
	        sqlSessionFactoryBean.setMapperLocations(resolver.getResources(MAPPER_LOCATION));
	        return sqlSessionFactoryBean.getObject();
	    }

}

4、目录结构

目录结构及代码：

User实体

@Accessors(chain = true)
@Getter
@Setter
// 也可以直接使用@Data
@Entity
@Table(name="tbl_user")
public class User implements Serializable {
    private Long id;
    private Integer version;
    @Column(name = "user_code")
    private String userCode;
    @Column(name = "user_name")
    private String userName;
    private Integer age;
    private String phone;
    private String address;
    private String email;
    private Integer sex;
    private String state;
    @Column(name = "create_time")
    private String createTime;
    @Column(name = "creator_code")
    private String creatorCode;
    @Column(name = "update_time")
    private String updateTime;
    @Column(name = "modifier_code")
    private String modifierCode;
}

UserDaoMapper

@Mapper
public interface UserDaoMapper {
	
	 User findByUsername(@Param("name") String name);

	 Integer saveUser(User user);

}

UserDaoMapper.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">

<mapper namespace="com.example.demo.mapper.UserDaoMapper">

    <resultMap id="userResultMap" type="com.example.demo.entity.User">
        <result column="id" property="id"></result>
        <result column="version" property="version"></result>
        <result column="user_code" property="userCode"></result>
        <result column="user_name" property="userName"></result>
        <result column="age" property="age"></result>
        <result column="phone" property="phone"></result>
        <result column="address" property="address"></result>
        <result column="email" property="email"></result>
        <result column="sex" property="sex"></result>
        <result column="state" property="state"></result>
        <result column="create_time" property="createTime"></result>
        <result column="creator_code" property="creatorCode"></result>
        <result column="update_time" property="updateTime"></result>
        <result column="modifier_code" property="modifierCode"></result>
    </resultMap>

    <sql id="Base_Column_List" >
         id,version,user_code,user_name,age,phone,address,email,sex,state,
        create_time,creator_code,update_time,modifier_code
    </sql>

    <select id="findByUsername" parameterType="string" resultMap="userResultMap">
    	SELECT
        <include refid="Base_Column_List" />
    	FROM tbl_user
		WHERE user_name = #{name}
    </select>

    <insert id="saveUser" parameterType="com.example.demo.entity.User" useGeneratedKeys="true" keyProperty="id">
        insert into tbl_user(
        id,version,user_code,user_name,age,phone,address,email,sex,state,
        create_time,creator_code,update_time,modifier_code
        ) values (
        #{id},#{version},#{userCode},#{userName},#{age},#{phone},#{address},#{email},#{sex},#{state},
        #{createTime},#{creatorCode},#{updateTime},#{modifierCode}
        )
    </insert>
    
</mapper>

5、@Before,@After和@BeforeClass和@AfterClass的区别

《Mybatis从入门到精通》书中测试代码中，有用到@Beforeclass这个注解，这里做一下拓展

@Before 在每个测试方法执行的时候都会各执行一次标有@Before部分的代码。

@Beforeclass 在类中只会被执行一次

@After 释放资源，对于每个测试方法都要执行一次

@Afterclass 所有测试用例执行完才执行一次

一个JUnit4的单元测试用例执行顺序为： 
@BeforeClass --> @Before --> @Test --> @After --> @AfterClass 

每一个测试方法的调用顺序为： @Before -> @Test -> @After