package com.stone.test;
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
public class ConnectionPool {
private static BasicDataSource bs;
public static BasicDataSource getDataSource() {
if (bs == null) {
bs = new BasicDataSource();
bs.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
bs.setUrl("jdbc:sqlserver://localhost:1433;DatabaseName=wepull");
bs.setUsername("sa");
bs.setPassword("123");
bs.setMaxActive(5);
}
return bs;
}
public static void main(String[] args) {
try {
Connection con = ConnectionPool.getDataSource().getConnection();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
public class ConnectionPool {
private static BasicDataSource bs;
public static BasicDataSource getDataSource() {
if (bs == null) {
bs = new BasicDataSource();
bs.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
bs.setUrl("jdbc:sqlserver://localhost:1433;DatabaseName=wepull");
bs.setUsername("sa");
bs.setPassword("123");
bs.setMaxActive(5);
}
return bs;
}
public static void main(String[] args) {
try {
Connection con = ConnectionPool.getDataSource().getConnection();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}