logback打印日志

logback打印ibatisSQL语句

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
	<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
		 <!-- encoder的默认实现类是ch.qos.logback.classic.encoder.PatternLayoutEncoder --> 
		<encoder>
			<pattern>%date{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
		</encoder>
	</appender>

	<!--logback输出日志到文件（滚动）RollingFileAppender继承了FileAppender-->
	<appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
		<file>../logs/bootexample/bootexample.log</file><!--和项目同级目录-->
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>../logs/bootexample/bootexample.%d{yyyy-MM-dd}.%i.log</fileNamePattern>
			<timeBasedFileNamingAndTriggeringPolicy
            class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
	        	<maxFileSize>5MB</maxFileSize>
      		</timeBasedFileNamingAndTriggeringPolicy> 
		</rollingPolicy>
		<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">  
            <pattern>%-20(%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread]) %-5level %logger{80} - %msg%n</pattern>  
        </encoder>
        <filter class="ch.qos.logback.classic.filter.LevelFilter">  
    		<level>INFO</level>  
    		<onMatch>ACCEPT</onMatch>  
    		<onMismatch>DENY</onMismatch>  
		</filter>   
	</appender>
	
	<root level="DEBUG">
		<appender-ref ref="STDOUT" />
		<appender-ref ref="FILE" />	
	</root>
	<!--ibatis打印SQL-->
	<logger name="com.ibatis" level="debug" />  
	<logger name="com.ibatis.common.jdbc.SimpleDataSource" level="debug" />  
	<logger name="com.ibatis.common.jdbc.ScriptRunner" level="debug" />  
	<logger name="com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate" level="debug" />  
	<logger name="java.sql.Connection" level="debug" />  
	<logger name="java.sql.Statement" level="debug" />  
	<logger name="java.sql.PreparedStatement" level="debug" />
	<logger name="org.springframework.web" level="debug"/>
</configuration>

相关jar

logback-classic-1.0.13.jar
logback-core-1.0.13.jar
slf4j-api-1.7.5.jar