1、下载log4jdbc-1.2alpha1
添加对应jar,log4jdbc3.jar(对应jdk版本1.4和1.5),log4jdbc4.jar(对应jdk版本1.6和1.7)
2、修改jdbc配置文件中driver(全改)和url(加log4jdbc)
driver = net.sf.log4jdbc.DriverSpy
url = jdbc:log4jdbc:oracle:thin:@172.25.14.22:1521:g22u1
name = taiping_hk_dev
password = taiping_hk_devpwd
3、添加log4jdbc配置文件
log4j.logger.jdbc.sqlonly=DEBUG,console
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss.SSS} %m%n%n
log4j.logger.jdbc.sqltiming=INFO,console
log4j.logger.jdbc.connection=INFO,console
控制台效果如下