首页 > MyBatis SQL 语句log重复输出问题

MyBatis SQL 语句log重复输出问题

使用的log相关maven依赖

      <!-- LOGGING begin -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>${slf4j.version}</version>
        </dependency>

        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.0.13</version>
            <scope>runtime</scope>
        </dependency>

        <!-- 代码直接调用log4j会被桥接到slf4j -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>log4j-over-slf4j</artifactId>
            <version>${slf4j.version}</version>
            <scope>runtime</scope>
        </dependency>
        <!-- 代码直接调用common-logging会被桥接到slf4j -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>jcl-over-slf4j</artifactId>
            <version>${slf4j.version}</version>
            <scope>runtime</scope>
        </dependency>
        <!-- 代码直接调用java.util.logging会被桥接到slf4j -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>jul-to-slf4j</artifactId>
            <version>${slf4j.version}</version>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.bgee.log4jdbc-log4j2</groupId>
            <artifactId>log4jdbc-log4j2-jdbc4</artifactId>
            <version>1.15</version>
            <scope>runtime</scope>
        </dependency>
        <!-- LOGGING end -->

logback 配置文件 logback.xml

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <appender name="console" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
            <charset>UTF-8</charset>
        </encoder>
    </appender>

    <appender name="rollingFile" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>logs/bos.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>logs/bos.%d{yyyy-MM-dd}.log</fileNamePattern>
        </rollingPolicy>
        <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
            <charset>UTF-8</charset>
        </encoder>
    </appender>

    <!-- project default level -->
    <logger name="com.bos" level="INFO" />

    <!--打印 MyBatis 的 SQL 到控制台 start -->
    <!--必须使用 DEBUG 级别-->
    <!--<logger name="com.bos.dao" level="DEBUG">-->
        <!--<appender-ref ref="console" />-->
    <!--</logger>-->
    <!--打印 MyBatis 的 SQL 到控制台 end -->

    <!--log4jdbc -->
    <logger name="jdbc.sqltiming" level="DEBUG"/>

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

com.bos.dao里都是使用 mybatis-generator-maven-plugin生成的
但是调试的时候发现所有的SQL语句都重复输出了两次, 而其他log都是正常的:

15:47:03.441 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - ==>  Preparing: select ID, MemberName, MemberAccount, MemberPassword, TelePhoneNo, ContactPhone, ParentID, Email, MemberCode, MemberType, Avatar, Address, UnvalidateStartTime, UnvalidateEndTime, IsValidate, Shield, ApprovalStatus, MailboxVerification, RegistedSource, Remark, LastLoginTime, CurrentLoginTime, Status, CreationUser, CreationDate, ModificaitonUser, ModificationDate, Recommended, LoginTimes, NewMessageCount, NewOrderCount, SystemSource, ActivationTime, HospitalID from TB_MB_MemberInfo where ID = ? 
15:47:03.441 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - ==>  Preparing: select ID, MemberName, MemberAccount, MemberPassword, TelePhoneNo, ContactPhone, ParentID, Email, MemberCode, MemberType, Avatar, Address, UnvalidateStartTime, UnvalidateEndTime, IsValidate, Shield, ApprovalStatus, MailboxVerification, RegistedSource, Remark, LastLoginTime, CurrentLoginTime, Status, CreationUser, CreationDate, ModificaitonUser, ModificationDate, Recommended, LoginTimes, NewMessageCount, NewOrderCount, SystemSource, ActivationTime, HospitalID from TB_MB_MemberInfo where ID = ? 
15:47:03.442 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - ==> Parameters: 64866(Integer)
15:47:03.442 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - ==> Parameters: 64866(Integer)
15:47:03.445 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - <==      Total: 1
15:47:03.445 [btpool0-0] DEBUG c.b.j.c.d.m.M.selectByPrimaryKey - <==      Total: 1
【热门文章】
【热门文章】