log4jdbc使用

spring xml配置（拦截需要处理的dataSource连接）

Java代码  

1. <bean id="log4jdbcInterceptor" class="net.sf.log4jdbc.DataSourceSpyInterceptor" />  
2.     <bean id="dataSourceLog4jdbcAutoProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">  
3.        <property name="interceptorNames">  
4.            <list>  
5.               <value>log4jdbcInterceptor</value>  
6.            </list>  
7.        </property>  
8.        <property name="beanNames">  
9.            <list>  
10.               <value>dataSource</value>  
11.            </list>  
12.        </property>  
13.     </bean>  

log4j.properties配置(日志级别为OFF时日志将不会生效)

Java代码  

1. log4j.logger.jdbc.sqlonly=OFF  
2. log4j.logger.jdbc.sqltiming=INFO  
3. log4j.logger.jdbc.audit=OFF  
4. log4j.logger.jdbc.resultset=OFF  
5. log4j.logger.jdbc.connection=OFF  

 

maven依赖

Xml代码  

1. <dependency>  
2.                <groupId>net.sf.log4jdbc</groupId>  
3.                <artifactId>log4jdbc3</artifactId>  
4.                <version>1.2.1</version>  
5.  </dependency>