Comment on page
输出SQL日志
如果想要查看执行的SQL语句,只需要将win.doyto.query.core.SqlAndArgs的日志等级配置为debug即可。
在spring的yaml文件里配置如下:
application.yml
logging:
level:
win.doyto.query.core.SqlAndArgs: debug
日志打印如下:
...
2021-02-25 22:17:18.442 DEBUG 80237 --- [ main] win.doyto.query.core.SqlAndArgs : SQL : SELECT platform, parentId, menuName, memo, valid, id, createUserId, createTime, updateUserId, updateTime FROM menu WHERE id = ?
2021-02-25 22:17:18.442 DEBUG 80237 --- [ main] win.doyto.query.core.SqlAndArgs : Param: 3(java.lang.Integer)
2021-02-25 22:17:18.447 DEBUG 80237 --- [ main] win.doyto.query.core.SqlAndArgs : SQL : DELETE FROM menu WHERE id = ?
2021-02-25 22:17:18.447 DEBUG 80237 --- [ main] win.doyto.query.core.SqlAndArgs : Param: 3(java.lang.Integer)
...
最近更新 2yr ago