레이지루크 설치, 설정(sql문 콘솔창에 출력 시켜줌)

//sts01 프로젝트 참고
pom.xml

<dependency>

            <groupId>org.lazyluke</groupId>

            <artifactId>log4jdbc-remix</artifactId>

            <version>0.2.7</version>

 </dependency>

mybatis-context.xml

// 위에있는 데이터베이스 소스의 아이디를 ref로 정해주면 데이터베이스가 실행될때 인터셉터하여 먼저 레이지루크를 실행하게 된다
<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">

       <constructor-arg ref="dataSource1" />

       <property name="logFormatter">

           <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">

               <property name="loggingType" value="MULTI_LINE" />

               <property name="sqlPrefix" value="SQL         :  "/>

           </bean>

       </property>

   </bean>

//한 후에 sqlSessionFactory안 datasource 프로퍼티안 ref에 방금추가한 Id= dataSource를 맞춰준다.

src/main/resources

log4j.xml

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

<!DOCTYPE log4j:configuration PUBLIC "-//APACHE//DTD LOG4J 1.2//EN" "log4j.dtd">

<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">

   <!-- Appenders -->

   <appender name="console" class="org.apache.log4j.ConsoleAppender">

       <layout class="org.apache.log4j.PatternLayout">

           <param name="ConversionPattern" value="%d %5p [%c] %m%n" />

       </layout>  

   </appender>

    

   <appender name="console-infolog" class="org.apache.log4j.ConsoleAppender">

       <layout class="org.apache.log4j.PatternLayout">

           <param name="ConversionPattern" value="%d %5p %m%n" />

       </layout>  

   </appender>

    

   <!-- Application Loggers -->

   <logger name="first" additivity="false">

       <level value="debug" />

       <appender-ref ref="console"/>

   </logger>

    

   <!-- Query Loggers -->

   <logger name="jdbc.sqlonly" additivity="false">

       <level value="INFO"/>

       <appender-ref ref="console-infolog"/>

   </logger>

    

   <logger name="jdbc.resultsettable" additivity="false">

       <level value="INFO"/>

       <appender-ref ref="console"/>

   </logger>

   <!-- Root Logger -->

   <root>

       <priority value="off"/>

       <appender-ref ref="console" />

   </root>

    

</log4j:configuration>