Spring mvc+mybatis+Log4j控制台打印sql语句 -清零世界

bubuko 2022/1/25 19:53:07 java 字数 2327 阅读 1061 0 来源 http://www.bubuko.com/infolist-5-1.html

第一步：添加依赖，在web层中

<!-- log start -->
<dependency>
  <groupId>log4j</groupId>
  <artifactId>log4j</artifactId>
  <version>${log4j.version}</version>
</dependency>
<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>${slf4j.version}</version>
</dependency>
<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-log4j12</artifactId>
  <version>${slf4j.version}</version>
</dependency>
<!-- log end -->

第二步：在resources下添加log4j文件，此文件系统自动加载。

技术分享图片

第三步：log4j中添加以下内容

# Set root category priority to INFO and its only appender to CONSOLE.
#log4j.rootCategory=INFO, CONSOLE            debug   info   warn error fatal
log4j.rootCategory=debug, CONSOLE, LOGFILE

# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE

# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

# LOGFILE is set to be a File appender using a PatternLayout.
# log4j.appender.LOGFILE=org.apache.log4j.FileAppender
# log4j.appender.LOGFILE.File=d:\axis.log
# log4j.appender.LOGFILE.Append=true
# log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
# log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n


此打印sql配置无法在分布式项目中打印出来，但是可以打印相关信息，以后分布式打印sql模板再添加

Spring mvc+mybatis+Log4j控制台打印sql语句

原文：https://www.cnblogs.com/xiaofengshan/p/12823472.html

如果您也喜欢它,动动您的小指点个赞吧

Spring mvc+mybatis+Log4j控制台打印sql语句

分类汇总

您的鼓励是对我最大的支持