日志
为方便调试,将日志输出进行了格式化
|------------------------------------------------------------------------------------------------------------------------------------|
| sqlString | INSERT INTO Test_Book |
| | |
| | (`created_at`,`updated_at`,`created_by`,`updated_by`,`test_name`,`test_id`) |
| | |
| | Values |
| | |
| | (@created_at,@updated_at,@created_by,@updated_by,@test_name,@test_id) |
|------------------------------------------------------------------------------------------------------------------------------------|
| sqlParam | created_at = 2017-05-02T21:05:00.931 |
| | |
| | updated_at = 2017-05-02T21:05:00.931 |
| | |
| | created_by = zhangsanfeng |
| | |
| | updated_by = zhangsanfeng |
| | |
| | test_name = test |
| | |
| | test_id = 11738897238937600 |
|------------------------------------------------------------------------------------------------------------------------------------|
| rowsAffected | 1 |
|------------------------------------------------------------------------------------------------------------------------------------|
| finalSql | INSERT INTO Test_Book |
| | |
| | (`created_at`,`updated_at`,`created_by`,`updated_by`,`test_name`,`test_id`) |
| | |
| | Values |
| | |
| | ('2017-05-02T21:05:00.931','2017-05-02T21:05:00.931','zhangsanfeng','zhangsanfeng','test','11738897238937600') |
|------------------------------------------------------------------------------------------------------------------------------------|
| generatedKeys | 11738897238937600 |
|------------------------------------------------------------------------------------------------------------------------------------|
| result | 1 |
|------------------------------------------------------------------------------------------------------------------------------------|
| timeSpend | 12 ms |
|------------------------------------------------------------------------------------------------------------------------------------|
为方便检验SQL执行情况,在输出上面的调试信息后,会紧跟输出finalSql的内容
如下,可以直接选中复制,然后粘贴到Mysql客户端去执行。
INSERT INTO Test_Book (`created_at`,`updated_at`,`created_by`,`updated_by`,`test_name`,`test_id`) Values ('2017-05-02T21:05:00.931','2017-05-02T21:05:00.931','zhangsanfeng','zhangsanfeng','test','11738897238937600')