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类:

@RestControllerpublic 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.运行结果