Sping boot使用MySql整合p6spy
使用p6spy实现控制台输出sql语句时拼接参数
pom依赖
<dependency>
<groupId>p6spy</groupId>
<artifactId>p6spy</artifactId>
<version>3.8.6</version>
</dependency>
在resources下添加spy.properties配置文件
功能快捷键
//数据库连接驱动
driverlist=com.mysql.cj.jdbc.Driver
logMessageFormat=com.p6spy.engine.spy.appender.MultiLineFormat
# logMessageFormat=com.p6spy.engine.spy.appender.SingleLineFormat
databaseDialectDateFormat=yyyy-MM-dd HH:mm:ss
appender=com.p6spy.engine.spy.appender.StdoutLogger
修改数据库驱动和url
driver-class-name:为com.p6spy.engine.spy.P6SpyDriver
url在jabc与mysql中加入p6spy: