1.创建SpringBoot工程
根据
http://www.cnblogs.com/vitasyuan/p/8765329.html
说明创建SpringBoot项目。
2.添加相关依赖
在pom.xml文件中添加数据库连接和mybatis的相关依赖，完整的pom文件如下：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.1.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<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-test</artifactId>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-web -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
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"
}
]
}
表示数据库配置成功。