Mybatis中配置控制台打印sql语句

Mybatis中配置控制台打印sql语句

<?xml version="1.0" encoding="UTF-8" ?>
<Configuration status="WARN" monitorInterval="1800">
	<Appenders>
		<RollingFile name="RollingFile" fileName="logs/${project.artifactId}.log"
			filePattern="logs/${project.artifactId}/$${date:yyyy-MM}/%d{dd-MM-yyyy}-%i.log.gz">
			<PatternLayout pattern="%d{yyyyMMdd HH:mm:ss} %l %p %msg%n" />
			<SizeBasedTriggeringPolicy size="1 MB" />
		</RollingFile>
		<Console name="Console" target="SYSTEM_OUT">
			<PatternLayout pattern="%d{yyyyMMdd HH:mm:ss.SSS} %p %msg%n" />
		</Console>
	</Appenders>
	<Loggers>
		<Logger name="org.springframework" level="ERROR" additivity="false">
			<AppenderRef ref="Console" />
		</Logger>
		<Logger name="org.springframework" level="info" additivity="false">
			<AppenderRef ref="RollingFile" />
		</Logger>
		<logger name="java.sql.ResultSet" level="ERROR" additivity="false">
			<AppenderRef ref="Console" />
			<AppenderRef ref="RollingFile" />
		</logger>
		<logger name="com.cetripnet" level="${log4j.level}" additivity="false">
			<AppenderRef ref="Console" />
			<AppenderRef ref="RollingFile" />
		</logger>
		<logger name="common" level="${log4j.level}" additivity="false">
			<AppenderRef ref="Console" />
			<AppenderRef ref="RollingFile" />
		</logger>
		<Root level="error">
			<AppenderRef ref="Console" />
			<AppenderRef ref="RollingFile" />
		</Root>
	</Loggers>
</Configuration>