C3P0是一个开源的JDBC连接池,它实现了数据源和JNDI绑定,支持JDBC3规范和JDBC2的标准扩展。目前使用它的开源项目有Hibernate,Spring等。
<bean id="ds" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="root"></property>
<property name="password" value="123456"></property>
<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mydb"></property>
</bean>
DataSource ds=(DataSource)ctx.getBean("ds");
try {
Connection connection=ds.getConnection();
PreparedStatement prstPreparedStatement= connection.prepareStatement("select * from userlist");
ResultSet rsResultSet=prstPreparedStatement.executeQuery();
while (rsResultSet.next()) {
System.out.println(rsResultSet.getString(1)+rsResultSet.getInt(2));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}