SpringBoot集成Mybatis

1.创建SpringBoot工程

根据
http://www.cnblogs.com/vitasyuan/p/8765329.html
说明创建SpringBoot项目。

2.添加相关依赖

在pom.xml文件中添加数据库连接和mybatis的相关依赖，完整的pom文件如下：

org.springframework.boot
spring-boot-starter-parent
2.0.1.RELEASE

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>

org.springframework.boot
spring-boot-starter

org.springframework.boot
spring-boot-starter-test
test



org.springframework.boot
spring-boot-starter-web


mysql
mysql-connector-java
runtime

org.mybatis.spring.boot
mybatis-spring-boot-starter
1.3.2

org.springframework.boot
spring-boot-maven-plugin

3.创建测试数据表

创建测试数据库：springbootdemo，并添加以下数据表：

CREATE TABLE dictionary (
id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
dict_key varchar(50) NOT NULL DEFAULT '' COMMENT '字典key',
dict_value varchar(50) NOT NULL DEFAULT '' COMMENT 'value',
parent_id int(11) NOT NULL COMMENT '上级节点id',
description varchar(100) NOT NULL DEFAULT '' COMMENT '描述信息',
PRIMARY KEY (id),
KEY Index_dictKey_parentId (dict_key,parent_id)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='数据字典表';

4.添加数据库相关配置

数据库配置使用多环境配置，具体多环境配置方法参考：http://www.cnblogs.com/vitasyuan/p/8782612.html

在application-dev.properties配置文件中添加数据库相关配置：

数据库配置

spring.datasource.url=jdbc:mysql://localhost:3306/springbootdemo
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
在application.properties文件中添加使用dev环境配置文件的内容：

配置使用的配置环境，值为application-{profile}.properties中的profile值

spring.profiles.active=rc
#mapper文件的路径
mybatis.mapper-locations=classpath:mapper/**/*.xml

5.添加mapper文件和接口

在resource文件夹下添加mapper/demo-server文件夹，并添加dictionary.xml配置文件，配置文件内容如下：

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.business.dictionary.dao.DictionaryDao">

    <resultMap id="DictionaryResultMap" type="com.example.demo.business.dictionary.Dictionary">
        <result property="id" column="id"></result>
        <result property="dictKey" column="dict_key"></result>
        <result property="dictValue" column="dict_value"></result>
        <result property="parentId" column="parent_id"></result>
        <result property="description" column="description"></result>
    </resultMap>

    <select id="list" resultMap="DictionaryResultMap">
        SELECT * FROM `dictionary`
    </select>

    <select id="listChildrenByKey" resultMap="DictionaryResultMap">
        SELECT * FROM dictionary where parent_id= (select id from dictionary where dict_key= #{key})
    </select>

    <delete id="delete" parameterType="int">
        delete from dictionary where id = #{id}
    </delete>

    <insert id="insert" parameterType="com.example.demo.business.dictionary.Dictionary">
        INSERT INTO `dictionary`(`dict_key`,`dict_value`,`parent_id`,`description`)
        VALUES(#{dictKey}, #{dictValue}, #{parentId}, #{description})
    </insert>
</mapper>

6.添加controller测试数据库连接

创建controller类，代码如下：

@RestController
@RequestMapping(value = "/dictionary")
public class DictionaryController {

    @Autowired
    private DictionaryDao dictionaryDao;

    @GetMapping
    public Response<List<Dictionary>> get(){
        Response<List<Dictionary>> response = new Response<>();
        response.setData(dictionaryDao.list());
        return  response;
    }
}

启动服务，在浏览器中输入访问url：

http://localhost:8080/demo/dictionary
返回以下数据：

{
  "code": 200,
  "message": "Success",
  "data": [
    {
      "id": 27,
      "dictKey": "test",
      "dictValue": "testvalue",
      "parentId": 1,
      "description": "test"
    },
    {
      "id": 30,
      "dictKey": "test",
      "dictValue": "testvalue",
      "parentId": 1,
      "description": "test"
    },
    {
      "id": 32,
      "dictKey": "test",
      "dictValue": "testvalue",
      "parentId": 1,
      "description": "test"
    },
    {
      "id": 33,
      "dictKey": "test",
      "dictValue": "testvalue",
      "parentId": 1,
      "description": "test"
    }
  ]
}

表示数据库配置成功。