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