<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring.version>3.2.4.RELEASE</spring.version>
<version.slf4j>1.7.6</version.slf4j>
<version.logback>1.1.2</version.logback>
</properties>

<!-- log -->
 <dependency>
  <groupId>org.lazyluke</groupId>
  <artifactId>log4jdbc-remix</artifactId>
  <version>0.2.7</version>
 </dependency>
 <dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>${version.slf4j}</version>
 </dependency>
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-classic</artifactId>
  <version>${version.logback}</version>
 </dependency>
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-access</artifactId>
            <version>${version.logback}</version>
 </dependency>
 <dependency>
  <groupId>org.logback-extensions</groupId>
  <artifactId>logback-ext-spring</artifactId>
  <version>0.1.2</version>
 </dependency>

<!--jul橋接 用來輸出 Java Logging Framework (JUL) -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jul-to-slf4j</artifactId>
<version>${version.slf4j}</version>
/dependency>
 
 
<!-- jcl橋接，用來輸出 第三方Jakarta Commons Logging (JCL) -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jcl-over-slf4j</artifactId>
<version>${version.slf4j}</version>
</dependency>

<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
 <constructor-arg ref="dataSourceSpied" />
 </bean>(此處數(shù)據(jù)源用來代理原有的數(shù)據(jù)源，注入sessionfactory的時(shí)候用此處的dataSource)
<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
 <constructor-arg ref="dataSourceSpied" />
 </bean>(此處數(shù)據(jù)源用來代理原有的數(shù)據(jù)源，注入sessionfactory的時(shí)候用此處的dataSource)

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

<!-- scan 當(dāng)此屬性設(shè)置為true時(shí)，配置文件如果發(fā)生改變，將會(huì)被重新加載， 默認(rèn)值為true。 -->
<!-- scanPeriod 設(shè)置監(jiān)測(cè)配置文件是否有修改的時(shí)間間隔，如果沒有給出時(shí)間單位，默認(rèn)單位是毫秒。 當(dāng)scan為true時(shí)，此屬性生效。 默認(rèn)的時(shí)間間隔為1分鐘。 -->
<!-- debug 當(dāng)此屬性設(shè)置為true時(shí)，將打印出logback內(nèi)部日志信息，實(shí)時(shí)查看logback運(yùn)行狀態(tài)。 默認(rèn)值為false。 -->
<configuration scan="true" scanPeriod="60" debug="false">
<substitutionProperty name="log.base" value="c:/" />
<contextName>${tomcatName}${catalina.home}</contextName>

<appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">
<filter class="ch.qos.logback.classic.filter.ThresholdFilter">
<level>DEBUG</level>
</filter>

<!-- 注意 logback 的括號(hào)需要轉(zhuǎn)義 -->
<encoder charset="UTF-8" class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
<pattern>[%-5level] %d{MM-dd HH:mm:ss} %method - %m%n
</pattern>
</encoder>
</appender>

<!-- 此處配置用來只打印sql語句，若還想打印其他可注釋此處代碼-->
<logger name="jdbc.sqltiming" level="INFO" />
<logger name="jdbc" level="ERROR" />


<root level="INFO">
<appender-ref ref="CONSOLE" />
</root>
</configuration>

mybatis-plus:
 mapper-locations: classpath*:/mapping/**/*.xml
 //當(dāng)表中的字段名有下劃線，則需要開啟這個(gè)配置，將下劃線轉(zhuǎn)成駝峰命名法
 configuration:
  map-underscore-to-camel-case: true