springboot之整合数据库
1.整合druid
添加依赖
log4j
log4j
1.2.17
com.alibaba
druid
1.1.21
配置文件
#Spring Boot 默认是不注入这些属性值的,需要自己绑定
#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,stat:监控统计、log4j:日志记录、wall:防御sql注入
#如果允许时报错 java.lang.ClassNotFoundException: org.apache.log4j.Priority
#则导入 log4j 依赖即可,Maven 地址:https://mvnrepository.com/artifact/log4j/log4j
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
配置druid类
效果
2.mybatis整合
#mybatis配置
mybatis:
type-aliases-package: com.ywy.springboot05mybatis.pojo
mapper-locations: classpath:mybatis/mapper/*.xml
yml配置
写实体类测试
mapper接口
mapper
原文:https://www.cnblogs.com/ywy1/p/15169122.html