今天操作数据,遇到了bug,想在控制台打印sql的实际参数,方便查找问题。项目本来的设置是打印的占位符,类似于这种
SQL: delete from cpzx_dclass where 1=1 AND classcode = ? AND oldclasscode = ? AND pkey = ?
如果想打印具体的参数值怎么办呢?
可以这么设置:
如果是application.yml:
mybatis:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
如果是application.properties:
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
修改后:
==> Preparing: delete from cpzx_dclass where 1=1 AND classcode = ? AND oldclasscode = ? AND pkey = ?
==> Parameters: e5(String), null, e5null(String) // 实际参数值
java交流群,欢迎大佬和java学习者加入:344635699