打印详细日志，级别为debug，如sql语句也打印出来

打印详细日志，如sql语句也打印出来，则在项目的logback.xml文件中添加以下内容：

<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="java.sql.ResultSet" level="debug" />

logback.xml整个文件内容如下：

<?xml version="1.0" encoding="UTF-8"?>

<!-- Reference Manual http://logback.qos.ch/manual/index.html -->

<configuration scan="true" scanPeriod="60 seconds" debug="false">
    <property resource="config/properties/changeAble.properties" />
	<contextName>rcs.system</contextName>  
	<appender name="stdout" class="ch.qos.logback.core.ConsoleAppender">
		<encoder charset="UTF-8">
			<pattern>[%d{HH:mm:ss.SSS}][%5level][%thread][%logger{30}] : %msg%n
			</pattern>
		</encoder>
	</appender>
	<appender name="SystemRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
			<level>TRACE</level>
		</filter>
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.system-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>

		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	
	<appender name="dcsRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.dcs-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	
	<appender name="posRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.pos-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	
	<appender name="pmsRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.pms-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	
	<appender name="mmsRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.mms-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	<appender name="revsRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.revs-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	<appender name="reportRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.report-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	<appender name="riskRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.risk-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	<appender name="srcbRollingFile"
		class="ch.qos.logback.core.rolling.RollingFileAppender">
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<fileNamePattern>${rcs.log.path}/rcs.srcb-%d{yyyy-MM-dd}.%i.log
			</fileNamePattern>
			<maxHistory>90</maxHistory>
			<timeBasedFileNamingAndTriggeringPolicy
				class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
				<maxFileSize>20MB</maxFileSize>
			</timeBasedFileNamingAndTriggeringPolicy>
		</rollingPolicy>
		<encoder>
			<pattern>%d{HH:mm:ss.SSS} [%thread] [%level] %logger - %msg%n
			</pattern>
		</encoder>
	</appender>
	<root level="INFO">
		 	<appender-ref ref="stdout" />
		 	<appender-ref ref="SystemRollingFile" />
	</root>

	<logger name="com.erayt.ecas5" level="WARN" />
	<logger name="com.erayt.solar.module.transform.core.AbstractTransformer" level="WARN" />
	<logger name="org.apache" level="INFO" />
	<logger name="org.springframework" level="INFO" />
	<logger name="java.sql" level="INFO" />
	<logger name="SOLAR.LOGGER" level="INFO" />
	<logger name="SOLAR.MESSAGE" level="INFO" /> 
	<logger name="java.sql.Connection" level="INFO" />
	<logger name="java.sql.PreparedStatement" level="INFO" />
	<logger name="java.sql.ResultSet" level="INFO" />
	<logger name="com.ibatis" level="INFO" />

	<logger name="com.erayt.dcs" level="INFO" additivity="false">  
        <appender-ref ref="dcsRollingFile" />  
        <appender-ref ref="stdout" />
    </logger> 
    <logger name="com.erayt.pos" level="INFO" additivity="false">  
        <appender-ref ref="posRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.pms" level="INFO" additivity="false">  
        <appender-ref ref="pmsRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.mms" level="INFO" additivity="false">  
        <appender-ref ref="mmsRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.revs" level="INFO" additivity="false">  
        <appender-ref ref="revsRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.report" level="INFO" additivity="false">  
        <appender-ref ref="reportRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.risk" level="INFO" additivity="false">  
        <appender-ref ref="riskRollingFile" />
        <appender-ref ref="stdout" />  
    </logger>
    <logger name="com.erayt.srcb" level="INFO" additivity="false">  
        <appender-ref ref="srcbRollingFile" />  
        <appender-ref ref="stdout" />
    </logger>
    <!-- 新增XNetAppender2 -->
<appender name="xnet" class="com.erayt.solar.logging.appender.XNetAppender2">
	<config class="com.erayt.solar.monitor.XNetAppenderConfiguration" />
</appender>

<!-- 增加xnet的appender-ref -->
<root level="INFO">
	<appender-ref ref="xnet" />
</root>
	<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="java.sql.ResultSet" level="debug" />


</configuration>