java语言实现:使用数据库连接池,连接derby数据库。
DBPool
<pre name="code" class="java">package com.raisecom.fll.db;
import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class DBPool {
public static ComboPooledDataSource ds=new ComboPooledDataSource();
static{
try {
ds.setDriverClass("org.apache.derby.jdbc.EmbeddedDriver");
} catch (PropertyVetoException e) {
e.printStackTrace();
}
ds.setJdbcUrl("jdbc:derby:userinfo;create=false");
ds.setUser("abc");
ds.setPassword("abc");
ds.setMaxPoolSize(50);
ds.setMinPoolSize(10);
ds.setInitialPoolSize(10);
}
public static Connection getConnection(){
try {
return ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}