log4jdbc mysql_Log4jdbc demo

packagelog4jdbc;importjava.sql.Connection;importjava.sql.PreparedStatement;importorg.junit.Test;importcom.mchange.v2.c3p0.ComboPooledDataSource;public classDataSourceTest {

@Testpublic voidtestC3P0() {try{

ComboPooledDataSource dataSource= newComboPooledDataSource();

dataSource.setUser("root");

dataSource.setPassword("密码");

dataSource.setDriverClass("net.sf.log4jdbc.DriverSpy");

dataSource.setJdbcUrl("jdbc:log4jdbc:mysql://localhost:3306/实例名");

dataSource.setMaxPoolSize(50);

Connection conn=dataSource.getConnection();

String sql= "select * " + "from tb_person where id=?";

PreparedStatement ps= null;

ps=conn.prepareStatement(sql);

ps.setInt(1, 1);

ps.executeQuery();

ps.close();

conn.close();

}catch(Exception e) {

e.printStackTrace();

}

}

}

log4j.xml

Console输出：

log4j:ERROR No appender named [connection-appender] could be found.

2015-09-22 22:40:38.933 DEBUG debug: ... log4jdbc initializing ...

2015-09-22 22:40:38.934 DEBUG debug: log4jdbc.properties not found on classpath

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.debug.stack.prefix is not defined

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.sqltiming.warn.threshold is not defined

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.sqltiming.error.threshold is not defined

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.booleanastruefalse is not defined (using default value false)

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.maxlinelength is not defined (using default of 90)

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.fulldebugstacktrace is not defined (using default value false)

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.statement.warn is not defined (using default value false)

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.select is not defined (using default value true)

2015-09-22 22:40:38.934 DEBUG debug: x log4jdbc.dump.sql.insert is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.update is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.delete is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.create is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.dump.sql.addsemicolon is not defined (using default value false)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.auto.load.popular.drivers is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.trim.sql is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.trim.sql.extrablanklines is not defined (using default value true)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.suppress.generated.keys.exception is not defined (using default value false)

2015-09-22 22:40:38.935 DEBUG debug: x log4jdbc.drivers is not defined

2015-09-22 22:40:38.942 DEBUG debug: FOUND DRIVER com.mysql.jdbc.Driver

2015-09-22 22:40:38.945 DEBUG debug: ... log4jdbc initialized! ...

工程目录下logs/sql.log

-----> 2015-09-22 22:40:39.241 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)

2. select * from tb_person where id=1

http://blog.csdn.net/alex1314159/article/details/47185365

http://sourceforge.net/projects/c3p0/?source=typ_redirect

https://github.com/arthurblake/log4jdbc