From 2e6df1a925b9e1c034753095b2a871e91783eca0 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 13 十二月 2024 11:03:23 +0800
Subject: [PATCH] 完善SQL日志输出实现
---
pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintSqlInterceptor.java | 8 +-------
pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintExceptionSqlInterceptor.java | 6 +++---
2 files changed, 4 insertions(+), 10 deletions(-)
diff --git a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintExceptionSqlInterceptor.java b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintExceptionSqlInterceptor.java
index b3e1e8e..9ffada1 100644
--- a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintExceptionSqlInterceptor.java
+++ b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintExceptionSqlInterceptor.java
@@ -60,9 +60,9 @@
} catch (Exception e) {
// 杈撳嚭SQL寮傚父淇℃伅
log.error("SQL ErrorException:", e);
- log.info("SQL Parameters: {}", boundSql.getParameterObject());
- log.info("SQL Id: {}", sqlId);
- log.info("SQL: {}", PrintSqlHelp.getFullSql(configuration, boundSql));
+ log.error("SQL Id: {}", sqlId);
+ log.error("SQL Parameters: {}", boundSql.getParameterObject());
+ log.error("SQL: {}", PrintSqlHelp.getFullSql(configuration, boundSql));
// 鏍规嵁婧愬紓甯哥被鍨嬭繘琛岃繑鍥�
if (e instanceof InvocationTargetException) {
throw new InvocationTargetException(e);
diff --git a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintSqlInterceptor.java b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintSqlInterceptor.java
index a3775cd..e13e1eb 100644
--- a/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintSqlInterceptor.java
+++ b/pipIrr-platform/pipIrr-common/src/main/java/com/dy/common/mybatis/PrintSqlInterceptor.java
@@ -51,16 +51,10 @@
MappedStatement mappedStatement = (MappedStatement) args[0];
Object parameter = args[1];
- //BoundSql boundSql = mappedStatement.getBoundSql(parameter);
- //String sql = boundSql.getSql();
- //log.info("\n\nSQL锛歕n" + sql + "\n");
-
String sqlId = mappedStatement.getId();
BoundSql boundSql = mappedStatement.getBoundSql(parameter);
Configuration configuration = mappedStatement.getConfiguration();
- log.info("SQL Parameters: {}", boundSql.getParameterObject());
- log.info("SQL Id: {}", sqlId);
- log.info("SQL: {}", PrintSqlHelp.getFullSql(configuration, boundSql));
+ log.info("\nSQL Id: " + sqlId + "\nSQL Parameters: " + boundSql.getParameterObject() + "\nSQL: " + PrintSqlHelp.getFullSql(configuration, boundSql) + "\n");
}
return invocation.proceed();
--
Gitblit v1.8.0