Xml
-------------------------------------------------------------------
<!--log Listener--
<Context-param> <Param-name>Log4jconfiglocation</Param-name> <Param-value>Classpath:log4j.properties</Param-value></Context-param><Context-param> <Param-name>Log4jrefreshinterval</Param-name> <Param-value>60000</Param-value></Context-param><Listener> <Listener-class>Org.springframework.web.util.Log4jConfigListener</Listener-class></Listener>
Log4j.properties
--------------------------------------------------------------------
# Set Root path print level to Debuglog4j.rootlogger=Debug, Console # definition Appenderlog4j.appender.Console=Org.apache.log4j.ConsoleAppender log4j.appender.Console.layout=org.apache.log4j.PatternLayout Log4j.appender.Console.layout.ConversionPattern=%d [%t]%-5p [%c]-%m%N # Filter out unnecessary logs (the package path of the extra logs printed by the console) Log4j.logger.org.apache=errorlog4j.logger.org.springframework=errorlog4j.logger.org.mybatis.spring=ERRORLOG4J.LOGGER.NET.SF=Errorlog4j.logger.com.alibaba.druid=error# print out SQL statement related logs Log4j.logger.java.sql.ResultSet=Error Log4j.logger.java.sql.Connection=Error Log4j.logger.java.sql.Statement=debuglog4j.logger.java.sql.PreparedStatement=debug
log4j Print Pure SQL logs