idea201801
mysql
新建一个springboot项目,pom文件中导入依赖。mybatis、mysql、lombok.请看下图:
application.properties文件详细代码:#datasourcespring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTCspring.datasource.username=rootspring.datasource.password=rootspring.datasource.type=com.zaxxer.hikari.HikariDataSourcespring.datasource.hikari.minimum-idle=5spring.datasource.hikari.maximum-pool-size=15spring.datasource.hikari.auto-commit=truespring.datasource.hikari.idle-timeout=30000spring.datasource.hikari.pool-name=DatebookHikariCPspring.datasource.hikari.max-lifetime=1800000spring.datasource.hikari.connection-timeout=30000spring.datasource.hikari.connection-test-query=SELECT 1
建立所对应的目录。如图片所示,并写下的代码:
启动项目并测试:http://localhost:8080/list
MySQL驱动为新的名称【com.mysql.cj.jdbc.Driver】
数据库地址URL后面要加上时区【serverTimezone=UTC】