1. MyBatis Log Plus
MyBatis Log Plus是打印SQL日志的神器,最重要的是可将原有自动组装为带参数的完整可执行的SQL。 MyBatis Log Plus输出后的SQL是直接可以到Navicat执行的,省去了原来自己对Console原始SQL去手工编辑的麻烦。
备注:之前用过一款MyBatis Log,也不错,但是收费的,有30天的试用期。和MyBatis Log Plus总体区别不大。
Console原始SQL日志:
2022-11-11 21:22:52,177 [http-bio-9080-exec-8] DEBUG [java.sql.PreparedStatement] - ==> Executing: SELECT a.uuid AS uuid, a.status AS status, a.create_user_uuid AS createUserUuid, a.update_user_uuid AS updateUserUuid, a.remark AS remark, a.created_at AS createdAt, a.updated_at AS updatedAt FROM test a WHERE 1=1 AND a.status != -1 AND a.uuid = ? 2022-11-11 21:22:52,177 [http-bio-9080-exec-8] DEBUG [java.sql.PreparedStatement] - ==> Parameters: cc891cf3e3