druid连接池的简单例子

DruidDataSourceUtil.java文件：

import java.io.InputStream;
import java.util.Properties;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory; 
import com.alibaba.druid.pool.DruidPooledConnection;
 
public class DruidDataSourceUtil {
    public  DruidDataSource getDataSource() 
        throws Exception {
     Properties configureProperties = new Properties();
     InputStream is = DruidDataSourceUtil.class.getClassLoader().getResourceAsStream("ConfigureProperties.properties");  
     configureProperties.load(is);
     DruidDataSource druidDataSource = (DruidDataSource)DruidDataSourceFactory.createDataSource(configureProperties);
     return druidDataSource;
    }
    public  DruidPooledConnection getDruidConnection(DruidDataSource druidDataSource) throws Exception {
     DruidPooledConnection dbConn = druidDataSource.getConnection();
     return dbConn;
    }
} 
ConfigureProperties.properties配置文件放于src目录下：

url=jdbc\:sqlserver\://localhost\:1433; DatabaseName\=kb
username=sa
password=32419430
maxActive=1000
initialSize=20
testOnBorrow=false
filters=stat
testOnReturn=false
validationQuery=SELECT 'x'

Test.java文件：

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidPooledConnection;
import com.alibaba.druid.pool.DruidPooledPreparedStatement;
import com.alibaba.druid.pool.DruidPooledResultSet;
import com.alibaba.druid.pool.DruidPooledStatement;
public class Test {
    public static void main(String[] args) throws Exception {
     DruidDataSourceUtil druidDataSourceUtil = new DruidDataSourceUtil();
     DruidDataSource druidDataSource = druidDataSourceUtil.getDataSource();
     String sql = "update users set username =? where id=" + 3;
  long start = System.currentTimeMillis();
  for (int i = 0; i < 1; i++) {
   DruidPooledConnection dbConn = druidDataSourceUtil.getDruidConnection(druidDataSource);
      //System.out.println(dbConn);
   DruidPooledStatement  stmtNew = (DruidPooledStatement) dbConn.createStatement();
   DruidPooledPreparedStatement ps = (DruidPooledPreparedStatement)dbConn.prepareStatement(sql);
   ps.setString(1,"gg");
   DruidPooledResultSet rs = null;
   int j = ps.executeUpdate();
   while(j > 0){
    System.out.println("bb");
   }
  }  
  
    }

}

 

 

本例子所需的关于druid的jar包可在网上下载：

druid-1.0.0.jar

sqljdbc.jar(连接sqlserver2005数据库的jar包)