mybatis接入spring-boot

mybatis要接入spring-boot，首先配置pom：

		<!-- 数据库连接相关 -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<!-- 数据库连接相关 -->

然后，配置application.properties:

### DataSource
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/xh?autoReconnect=true&charset=utf8
spring.datasource.username=root
spring.datasource.password=

#mybatis配置
#mybatis.config-location=
mybatis.mapper-locations=classpath:mybatis/*.xml

其中，mybatis.config-location可以定义一些bean(ResultMap)，这里没有使用。

mybatis.mapper-locations是指mapper文件位置，例子中对应：

其中，UserMapper里面定义了一个方法“getUserNameByUserId"，注意namesapce的值“com.test.mapper.UserMapper”

<?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.test.mapper.UserMapper">
    <select id="getUserNameByUserId" parameterType="java.lang.Integer" resultType="java.lang.String">
        SELECT user_nick_name from users WHERE id = #{userId} limit 1
    </select>
</mapper>

接着，注解MapperScan，可以在SpringBootApplication注入，也可以另外创建一个Config类，比如：

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableTransactionManagement
@MapperScan(value = {"com.test.common.mapper"})
public class MyBatisConfig {
}

接着，定义你的mapper接口文件，注意文件所在位置“com.test.common.mapper”，和上面的MapperScan对应，比如

package com.test.common.mapper;

import org.springframework.stereotype.Component;

@Component
public interface UserMapper {

    String getUserNameByUserId(Integer userId);
}

使用如下：

    @Autowired
    private UserMapper userMapper;
    
    public String getUserName() {
        String a = this.userMapper.getUserNameByUserId(19);
        return a;
    }

效果等同于运行sql : 

select user_nick_name from users where id = 19