日志

为方便调试,将日志输出进行了格式化

|------------------------------------------------------------------------------------------------------------------------------------|
|  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') 

results matching ""

    No results matching ""