Mybatis 利用log4j打印输出log

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration>     <settings>         <setting name="logImpl" value="LOG4J" />     </settings> </configuration>

  spring-mybatis.xml    <!-- spring-myBatis文件  配置mapper文件-->  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">   <property name="dataSource" ref="dataSource" />            <property name="configLocation" value="classpath:mybatis-config.xml"/>   <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->   <property name="mapperLocations" value="classpath:cn/edu/buaa/bhxuanke/mapper/*.xml" />     </bean> 设置任意一个  log4j.properties /log4j.xml  在log4j的配置文件 log4j.properties ：

log4j.rootLogger=error, stdout, logfile #cn.edu.buaa.bhxuanke 为命名空间 log4j.logger.cn.edu.buaa.bhxuanke=debug,stdout log4j.additivity.cn.edu.buaa.bhxuanke=false

log4j.logger.org.springframework.web=debug

log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

log4j.appender.logfile=org.apache.log4j.RollingFileAppender log4j.appender.logfile.File=framework.log log4j.appender.logfile.MaxFileSize=512KB log4j.appender.logfile.MaxBackupIndex=3 log4j.appender.logfile.layout=org.apache.log4j.PatternLayout log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n

 

log4j.xml(只输出SQL)   <?xml version="1.0" encoding="UTF-8"?> <log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>     <!-- ===================================================================== -->     <!--  定义全局输出适配器                                                      -->     <!-- ===================================================================== -->     <appender name="consoleAppender" class="org.apache.log4j.ConsoleAppender">         <layout class="org.apache.log4j.PatternLayout">             <param name="ConversionPattern" value="[%d{yyyy-MM-dd HH:mm:ss.SSS}]-[%c]-[%t] %x - %m%n"/>         </layout>     </appender>

    <!-- Mybatis and SQL -->     <logger name="org.apache.ibatis" additivity="true">         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <logger name="org.mybatis.spring" additivity="true">         <level value="ERROR"/>         <appender-ref ref="consoleAppender"/>     </logger>     <logger name="java.sql" additivity="true">         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <logger name="java.sql.Connection" additivity="true">         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <logger name="java.sql.Statement" additivity="true">         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <logger name="java.sql.PreparedStatement" additivity="true">         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <!-- Spring -->     <logger name="org.springframework" additivity="true">         <level value="ERROR"/>         <appender-ref ref="consoleAppender"/>     </logger>

    <!-- ActiveMQ -->     <logger name="org.apache.activemq" additivity="true">         <level value="ERROR"/>         <appender-ref ref="consoleAppender"/>     </logger>     <!-- ===================================================================== -->     <!--  根日志记录器                                                          -->     <!-- ===================================================================== -->     <root>         <level value="DEBUG"/>         <appender-ref ref="consoleAppender"/>     </root> </log4j:configuration>

 

  查考： http://blog.sina.com.cn/s/blog_4e1e357d0102wd0l.html             http://blog.csdn.net/zht666/article/details/9042373#comments             http://www.cnblogs.com/yjmyzz/p/4033729.html