SpringBoot: RESTful Web APP连接mysql(mybatis)

@[TOC](SpringBoot: RESTful Web APP连接mysql(mybatis))

0. 系统版本

• 操作系统：window10
• spring boot ：2.1.4 release
• eclipse Version : 2019-03 (4.11.0)
• java : Oracle JDK 1.8
• maven : 3.5.4

1. mysql中新建表user

执行以下sql

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '' ,
  `email` varchar(255) DEFAULT '' ,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

2. 配置application.properties

配置MySQL数据源和mybatis配置文件位置
修改src/main/resources/application.properties文件，内容如下：

spring.datasource.url=jdbc:mysql://localhost:3306/db_example?serverTimezone=GMT
spring.datasource.username=root
spring.datasource.password=yourpassword

mybatis.config-location=classpath:mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/*Mapper.xml

3. 修改POM.xml

• 首先需要继承母POM: spring-boot-starter-parent
• 选用依赖：
  1. spring-boot-starter-web
  2. spring-boot-starter-test
  3. mybatis-spring-boot-starter
  4. mysql-connector-java
  5. spring-boot-devtools
• 构建组件：spring-boot-maven-plugin (打包用)

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.4.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.hiramchen</groupId>
	<artifactId>SpringBoot-rest-mybatis</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>SpringBoot-rest-mybatis</name>
	<description>SpringBoot-rest-service</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId