让mybatis在控制台里打印sql语句

来源：互联网发布：c语言最大公约数流程图编辑：程序博客网时间：2024/05/17 22:39

一、添加log4j的jar包

二、在eclipse的src包下添加资源文件或xml文件

资源文件：名为log4j.properties

log4j.rootLogger=debug, stdout, logfile log4j.logger.com.ibatis=DEBUGlog4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUGlog4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUGlog4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG log4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUGlog4j.logger.java.sql.ResultSet=DEBUG log4j.logger.org.springframework=ERRORlog4j.logger.org.compass=ERROR log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n log4j.appender.logfile=org.apache.log4j.RollingFileAppenderlog4j.appender.logfile.File=empi.loglog4j.appender.logfile.MaxFileSize=512KBlog4j.appender.logfile.MaxBackupIndex=3log4j.appender.logfile.layout=org.apache.log4j.PatternLayoutlog4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n

xml文件名为log4j.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">  <appender name="console" class="org.apache.log4j.ConsoleAppender">     <param name="Target" value="System.out"/>     <layout class="org.apache.log4j.PatternLayout">       <param name="ConversionPattern" value="%d{MMM dd yyyy HH:mm:ss,SSS} %-5p %c - %m%n"/>     </layout>   </appender>     <appender class="org.apache.log4j.RollingFileAppender"          name="file">          <param name="File" value="ts.log" />          <param name="MaxFileSize" value="100KB" />          <param name="MaxBackupIndex" value="2" />          <layout class="org.apache.log4j.PatternLayout">              <param name="ConversionPattern"                  value="=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n" />          </layout>      </appender>     <category name="net.carefx" additivity="false"><priority value="DEBUG"/><appender-ref ref="console"/></category>    <category name="org.springframework" additivity="false">        <priority value="ERROR"/>        <appender-ref ref="console"/>    </category>        <category name="org.springframework.orm.ibatis3" additivity="false">        <priority value="ERROR"/>        <appender-ref ref="console"/>    </category>      <category name="org.apache.ibatis" additivity="false">        <priority value="DEBUG"/>        <appender-ref ref="console"/>    </category>        <category name="java.sql" additivity="false">        <priority value="ERROR"/>        <appender-ref ref="console"/>    </category>     <logger name="org.apache.ibatis.common.jdbc.SimpleDataSource">          <level value="debug" />      </logger>       <logger name="org.apache.ibatis.common.jdbc.SimpleDataSource">          <level value="debug" />      </logger>       <logger name="org.apache.ibatis.common.jdbc.ScriptRunner">          <level value="debug" />      </logger>       <logger name="org.apache.ibatis.common.jdbc.SqlMapClientDelegate">          <level value="debug" />      </logger>       <logger name="java.sql.Connection">          <level value="debug" />      </logger>       <logger name="java.sql.Statement">          <level value="debug" />      </logger>       <logger name="java.sql.PreparedStatement">          <level value="debug" />      </logger>       <logger name="java.sql.ResultSet">          <level value="debug" />      </logger>       <root>     <priority value ="ERROR" />     <appender-ref ref="console" />   </root> </log4j:configuration>

三、这样就可以在控制台里打印sql语句了，编写完毕，希望对大家有所帮助了(^_^)！

0 0