package net.tianyu.sample;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.sql.DataSource;
import org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS;
import org.apache.commons.dbcp.datasources.SharedPoolDataSource;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
public class TestDataSouce extends DriverManagerDataSource {
public static void main(String[] args) throws Exception {
TestDataSouce test = new TestDataSouce();
DataSource dataSource = test.getDataSouce();
int i = 0;
while (true) {
try {
i++;
Connection con = dataSource.getConnection();
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
stmt.executeQuery("SELECT * FROM T_USER");
System.out.println(i);
} catch (Exception e) {
e.printStackTrace();
}
}
}
public DataSource getDataSouce() throws Exception {
DataSource dataSource_ = null;
DriverAdapterCPDS ds = new DriverAdapterCPDS();
ds.setDriver("com.microsoft.sqlserver.jdbc.SQLServerDriver");
ds.setUrl("jdbc:sqlserver://127.0.0.1:1433;DatabaseName=TIANYU-DB");
ds.setUser("sa");
ds.setPassword("tianyu");
ds.setPoolPreparedStatements(false);
SharedPoolDataSource tds = new SharedPoolDataSource();
tds.setConnectionPoolDataSource(ds);
tds.setMaxActive(20);
tds.setMaxWait(1000);
tds.setMaxIdle(8);
dataSource_ = tds;
return dataSource_;
}
}