java mvc spring MyBatis Log4j sql语句

来源：互联网发布：免root的手机数据恢复编辑：程序博客网时间：2024/05/20 06:30

1、需要引用类库

maven的pom.xml如下

<dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-api</artifactId><version>2.4.1</version></dependency><dependency><groupId>org.apache.logging.log4j</groupId><artifactId>log4j-core</artifactId><version>2.4.1</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>1.7.12</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.10</version></dependency><!-- common-logging 实际调用slf4j --><dependency><groupId>org.slf4j</groupId><artifactId>jcl-over-slf4j</artifactId><version>1.7.12</version></dependency><!-- java.util.logging 实际调用slf4j --><dependency><groupId>org.slf4j</groupId><artifactId>jul-to-slf4j</artifactId><version>1.7.12</version></dependency>

log4j.properties

###log4j.properties配置  log4j.rootLogger=DEBUG, stdout      log4j.logger.java.sql.Connection = DEBUG    log4j.logger.java.sql.Statement = DEBUG    log4j.logger.java.sql.PreparedStatement = DEBUG   log4j.logger.java.sql.ResultSet = INFO    log4j.appender.stdout=org.apache.log4j.ConsoleAppender     log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

最后别忘了以调试模式启动程序，控制台就可以看到日志。

0 0