From 3b4f2727f885b4acb9a0429841d6a94849664956 Mon Sep 17 00:00:00 2001
From: liyj <1003249715@qq.com>
Date: Sat, 31 Aug 2024 11:28:18 +0800
Subject: [PATCH] 1、日志打印优化,输出sql语句

---
 dyh-service/dyh-utils/src/main/resources/logback-spring.xml   |   20 ++++++++------------
 dyh-service/dyh-sys/src/main/resources/logback-spring.xml     |    2 ++
 dyh-service/dyh-disp/src/main/resources/logback-spring.xml    |    2 ++
 dyh-service/dyh-mediate/src/main/resources/logback-spring.xml |    2 ++
 4 files changed, 14 insertions(+), 12 deletions(-)

diff --git a/dyh-service/dyh-disp/src/main/resources/logback-spring.xml b/dyh-service/dyh-disp/src/main/resources/logback-spring.xml
index 154c939..fd78825 100644
--- a/dyh-service/dyh-disp/src/main/resources/logback-spring.xml
+++ b/dyh-service/dyh-disp/src/main/resources/logback-spring.xml
@@ -27,6 +27,8 @@
             <appender-ref ref="CONSOLE" />
         </root>
 
+        <logger name="cn.huge" level="DEBUG" additivity="true"/>
+        <logger name="org.hibernate.SQL" level="DEBUG" additivity="true"/>
         <!-- 为 MyBatis 设置 DEBUG 级别的日志 -->
         <logger name="com.baomidou.mybatisplus" level="INFO" additivity="false">
             <appender-ref ref="CONSOLE" />
diff --git a/dyh-service/dyh-mediate/src/main/resources/logback-spring.xml b/dyh-service/dyh-mediate/src/main/resources/logback-spring.xml
index aae0d03..e4b8779 100644
--- a/dyh-service/dyh-mediate/src/main/resources/logback-spring.xml
+++ b/dyh-service/dyh-mediate/src/main/resources/logback-spring.xml
@@ -27,6 +27,8 @@
             <appender-ref ref="CONSOLE" />
         </root>
 
+        <logger name="cn.huge" level="DEBUG" additivity="true"/>
+        <logger name="org.hibernate.SQL" level="DEBUG" additivity="true"/>
         <!-- 为 MyBatis 设置 DEBUG 级别的日志 -->
         <logger name="com.baomidou.mybatisplus" level="INFO" additivity="false">
             <appender-ref ref="CONSOLE" />
diff --git a/dyh-service/dyh-sys/src/main/resources/logback-spring.xml b/dyh-service/dyh-sys/src/main/resources/logback-spring.xml
index 2175edc..40597db 100644
--- a/dyh-service/dyh-sys/src/main/resources/logback-spring.xml
+++ b/dyh-service/dyh-sys/src/main/resources/logback-spring.xml
@@ -27,6 +27,8 @@
             <appender-ref ref="CONSOLE" />
         </root>
 
+        <logger name="cn.huge" level="DEBUG" additivity="true"/>
+        <logger name="org.hibernate.SQL" level="DEBUG" additivity="true"/>
         <!-- 为 MyBatis 设置 DEBUG 级别的日志 -->
         <logger name="com.baomidou.mybatisplus" level="INFO" additivity="false">
             <appender-ref ref="CONSOLE" />
diff --git a/dyh-service/dyh-utils/src/main/resources/logback-spring.xml b/dyh-service/dyh-utils/src/main/resources/logback-spring.xml
index 7965148..760a78c 100644
--- a/dyh-service/dyh-utils/src/main/resources/logback-spring.xml
+++ b/dyh-service/dyh-utils/src/main/resources/logback-spring.xml
@@ -22,21 +22,17 @@
             </encoder>
         </appender>
 
-        <!-- 为 MyBatis 设置 DEBUG 级别的日志 -->
-        <logger name="org.apache.ibatis" level="DEBUG"/>
-        <!-- 输出 SQL 语句和参数 -->
-        <logger name="org.apache.ibatis.binding" level="DEBUG"/>
-        <!-- 输出 SQL 语句执行情况 -->
-        <logger name="org.apache.ibatis.session" level="DEBUG"/>
-        <!-- 输出 SQL 语句执行结果 -->
-        <logger name="org.apache.ibatis.executor" level="DEBUG"/>
-        <!-- 输出 SQL 语句 -->
-        <logger name="org.apache.ibatis.scripting" level="DEBUG"/>
-
         <!-- 设置根日志级别,如果日志级别低于设置的级别,则该日志不会被记录。如果日志级别高于设置的级别,那么这条日志将会被记录 -->
-        <root level="DEBUG">
+        <root level="INFO">
             <appender-ref ref="CONSOLE" />
         </root>
+
+        <logger name="cn.huge" level="DEBUG" additivity="true"/>
+        <logger name="org.hibernate.SQL" level="DEBUG" additivity="true"/>
+        <!-- 为 MyBatis 设置 DEBUG 级别的日志 -->
+        <logger name="com.baomidou.mybatisplus" level="INFO" additivity="false">
+            <appender-ref ref="CONSOLE" />
+        </logger>
     </springProfile>
 
     <!-- 测试环境+生产环境,多个使用逗号隔开 -->

--
Gitblit v1.8.0