MyBatis使用logback包打印SQL语句实践
<div id="navCategory"><h5 class="catalogue">目录</h5><ul class="first_class_ul"><li>1、引入依赖</li><li>2、新建配置文件</li><ul class="second_class_ul"><li>效果图</li><li>修正</li></ul><li>总结</li><ul class="second_class_ul"></ul></ul></div><p>完整打印出sql语句。</p><p>新建 maven 项目，使用pom.xml管理依赖。</p>
<p class="maodian"></p><h2>1、引入依赖</h2>
<div class="jb51code"><pre class="brush:xml;"> <dependencies>
<!-- mybatis 3 的依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.13</version>
</dependency>
<!-- mysql 的依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.49</version>
</dependency>
<!-- junit 的依赖 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!-- slf4j 日志api -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>2.0.5</version>
</dependency>
<!-- logback-classic 依赖 -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.4.6</version>
</dependency>
<!-- logback-core 依赖 -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
<version>1.4.6</version>
</dependency>
</dependencies>
</pre></div>
<p class="maodian"></p><h2>2、新建配置文件</h2>
<p>在 resources/ 下新建 logback.xml 文件</p>
<div class="jb51code"><pre class="brush:xml;"><?xml version="1.0" encoding="UTF-8"?>
<configuration>
<!-- console表示当前日志信息是可以输出到控制台的-->
<appender name="Console" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<!--
https://blog.csdn.net/qq_38701905/article/details/80739240
%d{yyyy-MM-dd HH:mm:ss SSS}
%-3level %logger{1024}
%boldGreen(%logger{15})
%class{35}
-->
<pattern>[%level] %blue(%d{HH:mm:ss.SSS}) %cyan([%thread]) %boldGreen(%logger{15}) - %msg %n</pattern>
</encoder>
</appender>
<!-- name 是要扫描的包路径; level 是消息等级, TRACE < DEBUG < INFO < WARN < FATAL -->
<logger name="com.mio.mapper" level="DEBUG" additivity="false">
<appender-ref ref="Console"/>
</logger>
<!--
<root level="debug">
<appender-ref ref="Console"/>
</root>
-->
</configuration>
</pre></div>
<p class="maodian"></p><h3>效果图</h3>
<p>确实打印出了xml组装后的sql语句。</p>
<p style="text-align:center"><img alt="" src="https://img.jbzj.com/file_images/article/202601/2026010909535652.png" /></p>
<p class="maodian"></p><h3>修正</h3>
<p>为了显示更多信息，可以把标签替换为标签，见上文配置文件。</p>
<p class="maodian"></p><h2>总结</h2>
<p>以上为个人经验，希望能给大家一个参考，也希望大家多多支持琼殿技术社区。</p>
<div class="art_xg">
<b>您可能感兴趣的文章:</b><ul><li>Springboot+Mybatis+logback打印sql脚本日志实现过程</li><li>LogBack+MybatisPlus实现打印sql日志</li><li>logback打印多次mybatis的sql日志问题</li><li>SpringBoot项目的logback日志配置(包括打印mybatis的sql语句)</li></ul>
</div>
</div>
<!--endmain-->
頁:
[1]