Spring Boot应用连接数据库MySQL，并编写自定义SQL

1、修改pom.xml文件

在项目的pom.xml文件上增加如下代码，添加依赖文件。

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.6</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>1.5.4.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-jpa -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
    <version>1.5.4.RELEASE</version>
</dependency>

2、 设置全局配置文件

在src/main/resources/application.properties中设置数据源和jpa配置。

server.port=8080

spring.datasource.url=jdbc:mysql://104.100.22.56:3306/kg_on?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
spring.datasource.username=55
spring.datasource.password=ithc
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
# Specify the DBMS
spring.jpa.database = MYSQL
# Show or not log for each sql q