SpringBoot 整合mybatis

1. 开发环境

    IntelliJ IDEA
    Maven
    Spring-boot
    Mybatis

2. 添加Maven依赖
在 pom.xml中添加如下依赖文件：

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

3.配置数据源及映射文件

    spring:
    datasource:
      url: jdbc:mysql://localhost:3306/springboot
      username: root
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver
    mybatis:
      mapperLocations: classpath:Mapper/*.xml
      typeAliasesPackage: com.example.Domain

4.创建t_user表

5.创建springboot Maven项目：
项目骨架结构如下：

(1)UserController类:

@RestController
public class UserController {
    @Autowired
    private UserDao userDao;

    @RequestMapping("/findUserById")
    public User findUserById(@RequestParam(value="id") Integer id) {
        User user = null;
        try {
            user = userDao.findUserById(id);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return user;
    }
}

(2)User实体类

    private Integer id;
    private String name;
    private Integer age;
    private String email;
    ...省略get和set方法

(3)UserDao类

    @Component
    public class UserDao {
        @Autowired
        private UserMapper userMapper;
        public User findUserById(Integer id) throws Exception {
               return userMapper.findUserById(id);
        }
    }

(4)UserMapper接口类

    @Mapper
    public interface UserMapper {
        User findUserById(Integer id);
    }

(5)UserMapper.xml映射文件

<?xml version = "1.0" encoding = "UTF-8"?>
<!DOCTYPE mapper PUBLIC
        "-//mybatis.org//DTD com.example.Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace = "com.example.Mapper.UserMapper">
    <resultMap id = "result" type = "user">
        <result property = "id" column = "id"/>
        <result property = "name" column = "f_name"/>
        <result property = "age" column = "f_age"/>
        <result property = "email" column = "f_email"/>
    </resultMap>
    <select id = "findUserById" resultMap = "result">
        SELECT * FROM t_user where id = #{id};
    </select>
</mapper>

6.运行结果