MyBatis输出sql需要log4j.properties配置

时间：2023-03-10 02:55:01
MyBatis输出sql需要log4j.properties配置 
 # Global logging configuration

 log4j.rootLogger=info,stdout,console,logfile

 # MyBatis logging configuration...

 log4j.logger.com.test.dao=DEBUG

 #log4j.logger.com.test.mappers=DEBUG

 log4j.appender.stdout=org.apache.log4j.ConsoleAppender

 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

 log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss} %5p [%t] - %m%n

 # Console output...

 log4j.appender.console.ImmediateFlush=true

 log4j.appender.console.Target=System.out

 log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender

 log4j.appender.logfile.File=${dir}/debug.log

 log4j.appender.logfile.DatePattern='_'yyyy-MM-dd'.log'

 log4j.appender.logfile.layout=org.apache.log4j.PatternLayout

 log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH\:mm\:ss,SSS} [%-5p][%t] method\:%l%n %m%n

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="cacheEnabled" value="true" />

         <setting name="lazyLoadingEnabled" value="true" />

         <setting name="multipleResultSetsEnabled" value="true" />

         <setting name="useColumnLabel" value="true" />

         <setting name="useGeneratedKeys" value="false" />

         <setting name="autoMappingBehavior" value="PARTIAL" />

         <setting name="defaultExecutorType" value="SIMPLE" />

         <setting name="defaultStatementTimeout" value="25" />

         <setting name="safeRowBoundsEnabled" value="false" />

         <setting name="mapUnderscoreToCamelCase" value="false" />

         <setting name="localCacheScope" value="SESSION" />

         <setting name="jdbcTypeForNull" value="OTHER" />

         <setting name="logImpl" value="LOG4J"/>

         <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString" />

     </settings>

 </configuration>

applicationContext.xml添加内容：

     <!-- 创建SqlSessionFactory，并指定数据源 -->

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

         <!-- 自动扫描mapping.xml文件，不需要mybatis的配置映射文件,扫描所有mapper文件,configLocation为mybatis属性,mapperLocations为所有mapper -->

             <property name="mapperLocations">

                 <list>

                     <!-- 表示在包或以下所有目录中，以-mapper.xml结尾所有文件 -->

                     <value>classpath:com/test/mappers/*-mapper.xml</value>

                 </list>

             </property>

         <property name="dataSource" ref="dataSource" />

         <property name="configLocation" value="classpath:config/mybatis-config.xml" />

         <property name="typeAliasesPackage" value="com.test.model" />

     </bean>

相关文章