druid连接池的简单例子

来源：互联网发布：win7 映射网络驱动器编辑：程序博客网时间：2024/06/07 05:19

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包)