博文:https://www.cnblogs.com/yy3b2007com/p/9186698.html
博文:https://blog.youkuaiyun.com/kai46385076/article/details/79930846
博文,大哥: https://blog.youkuaiyun.com/lv_hang515888/article/details/80463227
Spring JPA查询,JPA 根据方法名字查询详细介绍: https://www.sojson.com/blog/295.html
极客学院视频 添加、修改、删除功能的基本实现: http://www.jikexueyuan.com/course/680_3.html*
Hikari连接池
(号称java平台最快的,替换druid):https://blog.youkuaiyun.com/wangh92/article/details/79699172
1.springboot 2.0 默认连接池就是Hikari了,所以引用parents后不用专门加依赖
2.贴我自己的配置(时间单位都是毫秒)
# jdbc_config datasource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/datebook?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&zeroDateTimeBehavior=convertToNull
spring.datasource.username=root
spring.datasource.password=root
# Hikari will use the above plus the following to setup connection pooling
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=DatebookHikariCP
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.connection-test-query=SELECT 1
3.直接启动即可 如图: