ssm+mybatis打印日志(之前没配过)

12 篇文章 0 订阅

1.在web.xml文件中加入log4j的配置文件

<!-- 加载log4j配置文件 -->
  <context-param>
    <param-name>log4jConfigLocation</param-name>
    <param-value>classpath:log4j.properties</param-value>
    <!-- <param-value>/WEB-INF/log4j.xml</param-value> -->
  </context-param>
  <listener>
    <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
  </listener>

2.创建log4j.prooerties文件
最后一句是对应你的接口所对应的包(主要是最后一句)

log4j.rootLogger= info,WARN, console ,R
#log4j.rootLogger=debug, console ,R
log4j.additivity.jdbc=false
log4j.logger.autolog=info,console
log4j.additivity.autolog=false

#### console #####
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{MM-dd HH:mm:ss} %p %c %m%n

###rolling file###
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File= ${catalina.home}/logs/ms.log
log4j.appender.R.MaxFileSize=2MB
log4j.appender.R.MaxBackupIndex=1000
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern= %d{MM-dd HH:mm:ss} %p %c %m%n

#\u8bb0\u5f55\u6570\u636e\u5e93\u8fde\u63a5\u548c\u91ca\u653e\u4fe1\u606f\uff0c\u53ef\u8bb0\u5f55\u5f53\u524d\u7684\u6570\u636e\u5e93\u8fde\u63a5\u6570\uff0c\u4fbf\u4e8e\u8bca\u65ad\u8fde\u63a5\u662f\u5426\u91ca\u653e
log4j.logger.jdbc.connection=off
#\u8bb0\u5f55\u9664\u4e86ResultSet\u5916\u7684\u6240\u6709JDBC\u8c03\u7528\u60c5\u51b5\u3002\u4e00\u822c\u4e0d\u9700\u8981\u3002
log4j.logger.jdbc.audit=off
#\u8bb0\u5f55\u8fd4\u56de\u7ed3\u679c\u96c6\u4fe1\u606f
log4j.logger.jdbc.resultset=off
log4j.logger.jdbc.sqlonly=off
#\u8bb0\u5f55sql\u6267\u884c\u7684\u65f6\u95f4\uff0c\u53ef\u4ee5\u5206\u6790\u8017\u65f6\u7684sql\u8bed\u53e5
log4j.logger.jdbc.sqltiming=info,dbconsole,dblog

log4j.additivity.jdbc.sqlonly=false
log4j.additivity.jdbc.sqltiming=false  
log4j.additivity.jdbc.audit=false  
log4j.additivity.jdbc.resultset=false
log4j.additivity.jdbc.connection=false
#\u8bb0\u5f55\u7cfb\u7edf\u6267\u884c\u8fc7\u7684sql\u8bed\u53e5
#log4j.additivity.jdbc.sqlonly=true
#log4j.logger.jdbc.sqlonly=DEBUG,dbconsole
#\u63a7\u5236\u53f0\u8f93\u51fa
log4j.appender.dbconsole=org.apache.log4j.ConsoleAppender 
#\u63a7\u5236\u53f0\u8f93\u51fa\u683c\u5f0f\u5b9a\u4e49 
log4j.appender.dbconsole.layout=org.apache.log4j.PatternLayout
log4j.appender.dbconsole.layout.ConversionPattern=%d{MM-dd HH:mm:ss} %p %c %m%n


###rolling file###
log4j.appender.dblog=org.apache.log4j.RollingFileAppender
log4j.appender.dblog.File=${catalina.home}/logs/db.log
log4j.appender.dblog.MaxFileSize=2MB
log4j.appender.dblog.MaxBackupIndex=1000
log4j.appender.dblog.layout=org.apache.log4j.PatternLayout
log4j.appender.dblog.layout.ConversionPattern= %d{MM-dd HH:mm:ss} %p %c %m%n



####Configuration for ERROR Logger
log4j.logger.LOGERROR=ERROR,logerror,stdout
log4j.appender.logerror=org.apache.log4j.RollingFileAppender
log4j.appender.logerror.File=${catalina.home}/logs/error.log
log4j.appender.logerror.MaxFileSize=2MB
log4j.appender.logerror.MaxBackupIndex=10
log4j.appender.logerror.layout=org.apache.log4j.PatternLayout
log4j.appender.logerror.layout.ConversionPattern=%d{MM-dd HH:mm:ss} %p %c %m%n


#\u8bb0\u5f55sql\u6267\u884c\u7684\u65f6\u95f4\uff0c\u53ef\u4ee5\u5206\u6790\u8017\u65f6\u7684sql\u8bed\u53e5
#log4j.appender.jdbc.sqltiming=true
#log4j.logger.jdbc.sqltiming=INFO,console  
#\u8bb0\u5f55\u9664\u4e86ResultSet\u5916\u7684\u6240\u6709JDBC\u8c03\u7528\u60c5\u51b5\u3002\u4e00\u822c\u4e0d\u9700\u8981\u3002
#log4j.additivity.jdbc.audidt=true
#log4j.logger.jdbc.audit=INFO,console
#\u8bb0\u5f55\u8fd4\u56de\u7ed3\u679c\u96c6\u4fe1\u606f
#log4j.additivity.jdbc.resultset=true
#log4j.logger.jdbc.resultset=INFO,console 
#\u8bb0\u5f55\u6570\u636e\u5e93\u8fde\u63a5\u548c\u91ca\u653e\u4fe1\u606f\uff0c\u53ef\u8bb0\u5f55\u5f53\u524d\u7684\u6570\u636e\u5e93\u8fde\u63a5\u6570\uff0c\u4fbf\u4e8e\u8bca\u65ad\u8fde\u63a5\u662f\u5426\u91ca\u653e
#log4j.appender.jdbc.connection=true
#log4j.logger.jdbc.connection=debug
log4j.logger.com.trueway.apply.mapper=DEBUG

3.记得要引log4j的依赖

<dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <!-- 格式化对象,方便输出日志 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.1.41</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>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值