下面是maven依赖
<!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbutils/commons-dbutils -->
<dependency>
<groupId>commons-dbutils</groupId>
<artifactId>commons-dbutils</artifactId>
<version>1.6</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.2.0.jre8</version>
<scope>runtime</scope>
</dependency>
代码:
package yofc;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapListHandler;
import java.beans.PropertyVetoException;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
public class demo {
private static QueryRunner qr = null;
private static ComboPooledDataSource cpds = null;
public static void test(){
cpds = new ComboPooledDataSource();
try {
cpds.setDriverClass("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (PropertyVetoException e) {
e.printStackTrace();
}
cpds.setJdbcUrl("jdbc:sqlserver://10.111.69.111:1433;DatabaseName=test");
cpds.setMinPoolSize(5);
cpds.setAcquireIncrement(5);
cpds.setMaxPoolSize(20);
cpds.setUser("sa");
cpds.setPassword("user");
qr = new QueryRunner(cpds);
}
public static void main(String[] args) {
test();
try {
String sql = "select * from test";
List<Map<String, Object>> query = qr.query(sql, new MapListHandler());
for (int i = 0; i <query.size(); i++) {
System.out.println(query.get(i));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}