java 如何实现控制台打印sql语句

Bertha 。 2023-08-17 15:58 194阅读 0赞

**spring boot项目打印sql语句 2019.9.27**  
首先我们看一下效果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3NDQ2Ng_size_16_color_FFFFFF_t_70]  
现在直接上代码：  
logback-spring.xml 文件

<configuration>      
              
          
          
        <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">      
            <encoder>      
                <pattern>%d %p (%file:%line\)- %m%n</pattern>
                    
                  
                <charset>UTF-8</charset>     
            </encoder>      
        </appender>      
          
          
          
        <appender name="commonlog"      
            class="ch.qos.logback.core.rolling.RollingFileAppender">      
            <File>E:/log/apply/commonlog.log</File>      
              
              
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">      
                  
                  
                <fileNamePattern>E:/log/apply/commonlog.%d.%i.log</fileNamePattern>
                   
                <maxHistory>30</maxHistory>     
                <timeBasedFileNamingAndTriggeringPolicy  class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">      
                        
                    <maxFileSize>5KB</maxFileSize>      
                </timeBasedFileNamingAndTriggeringPolicy>      
            </rollingPolicy>      
            <encoder>      
                  
                <pattern>%d %p (%file:%line\)- %m%n</pattern>      
                  
                <charset>UTF-8</charset>      
            </encoder>      
        </appender>
          
          
        
        <appender name="sqllog"      
            class="ch.qos.logback.core.rolling.RollingFileAppender">      
            <File>E:/log/apply/sqllog.log</File>      
              
              
            <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">      
                  
                  
                <fileNamePattern>E:/log/apply/sqllog.%d.%i.log</fileNamePattern>
                   
                <maxHistory>30</maxHistory>     
                <timeBasedFileNamingAndTriggeringPolicy  class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">      
                        
                    <maxFileSize>5KB</maxFileSize>      
                </timeBasedFileNamingAndTriggeringPolicy>      
            </rollingPolicy>      
            <encoder>
                  
                <pattern>%d %p (%file:%line\)- %m%n</pattern>      
                  
                <charset>UTF-8</charset>      
            </encoder>      
        </appender>
          
          
          
        <logger name="cn.apply.mapper" level="DEBUG" additivity="false">
            <appender-ref ref="sqllog" />
            <appender-ref ref="STDOUT" />
        </logger>
          
        <root level="info">      
            <appender-ref ref="STDOUT" />
            <appender-ref ref="commonlog" />       
        </root>      
    </configuration>

application.properties 配置

#引入日志配置文件  
    logging.config=classpath:logback-spring.xml

运行项目，调用接口看效果！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3NDQ2Ng_size_16_color_FFFFFF_t_70]: /images/20230810/3879682ad9ae4002a5ca22fd8e5d7fc8.png