druid是阿里巴巴推出的国产数据库连接池
cloudwave是国产分布式数据库
druid用到的jar 这里下载http://maven.outofmemory.cn/com.alibaba/druid/1.0.1/
连接工厂类ConnectionFactory2 .java:
public class ConnectionFactory2 {
private ConnectionFactory2(){
}
private static DruidDataSource dataSource = null;
static {
try {
dataSource = new DruidDataSource();
dataSource.setDriverClassName("com.cloudwave.jdbc.CloudDriver");
dataSource.setUsername("itest");
dataSource.setPassword("itest");
dataSource.setUrl("jdbc:cloudwave:@localhost:1978");
dataSource.setInitialSize(5); dataSource.setMinIdle(1);
dataSource.setMaxActive(10); // 启用监控统计功能
// dataSource.setFilters("stat");// for mysql
dataSource.setPoolPreparedStatements(false);
dataSource.setValidationQuery("select * from dual");
String ss= dataSource.getValidationQuery();
// dataSource.setValidationQuery(dbInfo.getValidationQuery());
} catch (Exception e) {
e.printStackTrace();
}
}
public static synchronized Connection getConnection() {
Connection con = null;
try {
con = dataSource.getConnection();
} catch (Exception e1) {
e1.printStackTrace();
}
return con;
}
}
应用测试端:
public class TestNoClass {
public void moreConnect() throws Exception{
int theradsize=10;
Connection[] conn = new Connection[theradsize];
/* String sql = "create table itest1(c_id int,c_bfile bfile)";
statement.execute(sql);*/
for(int i=0;i<theradsize;i++){
conn[i] = ConnectionFactory2.getConnection();
Statement st=conn[i].createStatement();
ResultSet rs= st.executeQuery("select 1 from dual");
while(rs.next()){
System.out.println(rs.getString(1)+"---"+i);
};
}
for(int i=0;i<theradsize;i++){
conn[i].close();
}
}
public static void main(String[] args) {
try {
TestNoClass tnc =new TestNoClass();
tnc.moreConnect();
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}
}