druid连接池与数据库简单配置

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
        }

    }