SpringBoot的快速创建我们使用到的是idea的Spring Initializr创建方式:
点击下一步创建包名,Java版本要选8
下一步引入需要使用的maven(常用的是web、jdbc、mysql、mybatis)
创建项目名称
创建成功后等待引入maven完成就创建好SpringBoot环境啦
配置连接数据库:
可以在application.properties或application.yml,这里是使用yml进行配置,在resources文件下:
application.yml配置:
(包括数据库连接,druid监控[注:springboot2x不用写配置类],thymeleaf路径配置)
spring:
datasource:
username: root
password: 123
url: jdbc:mysql://127.0.0.1:3306/springboot_db?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
# druid配置
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
# 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
thymeleaf:
prefix: classpath:/templates/
cache: false
druid需要两个jar(pom可能引入不成功所以jar放在lib路径下再导入)
pom.xml:
<!--引入druid数据源-->
<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
<scope>system</scope>
<systemPath>${basedir}/lib/druid-1.1.10.jar</systemPath>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
数据库连接就做完啦
下一篇博客:【SpringBoot】SpringBoot+mysql+thymeleaf+mybatis实现一个Demo