这是使用Apache DBCP的示例:
BasicDataSource dbcp = new BasicDataSource();dbcp.setDriverClassName("com.mysql.jdbc.Driver");dbcp.setUrl("jdbc:mysql://localhost/test");dbcp.setUsername("");dbcp.setPassword("");JdbcTemplate jt = new JdbcTemplate(dbcp);jt.execute("SELECt 1");jt.execute("SELECT 1");log4j输出为:-
[DEBUG] [JdbcTemplate] [execute:416] - Executing SQL statement [SELECT 1][DEBUG] [DataSourceUtils] [doGetConnection:110] - Fetching JDBC Connection from DataSource[DEBUG] [DataSourceUtils] [doReleaseConnection:332] - Returning JDBC Connection to DataSource[DEBUG] [JdbcTemplate] [execute:416] - Executing SQL statement [SELECt 1][DEBUG] [DataSourceUtils] [doGetConnection:110] - Fetching JDBC Connection from DataSource[DEBUG] [DataSourceUtils] [doReleaseConnection:332] - Returning JDBC Connection to DataSource



