首先需要导入连接数据库的依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
<version>1.3.8.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-configuration-processor -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId><!-- 读取配置文件 -->
<optional>true</optional><!-- 表示当前依赖不向下传递。 -->
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.4</version>
</dependency>
<!-- 导入数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.8</version>
</dependency>
如果不知道配置文件需要配置什么,我们可以去看配置源码文件
在这里我们可以看出,我们需要配置的数据库文件属性前缀是“spring.datasource”
配置文件(数据源我们使用阿里的druid,功能比较全面)
spring:
datasource:
# 数据源基本配置
username: root
password: 999222
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/java2008
type: com.alibaba.druid.pool.DruidDataSource
# 数据源其他配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
# 配置监控统计拦截的filter