public class MyDbcp {
private Connection conn;
private PreparedStatement ps;
private ResultSet rs;
public static void main(String[] args) {
MyDbcp dbcp = new MyDbcp();
dbcp.testDbcp();
dbcp.testDbcp2();// 使用文件属性的配置方式实现
}
private void testDbcp2() {
// 创建Properties类
Properties pro = new Properties();
// 获取文件流
InputStream in = MyDbcp.class.getResourceAsStream("db.properties");
// 加载属性配置文件
try {
pro.load(in);
BasicDataSource dataSource = new BasicDataSource();
conn = dataSource.getConnection();
conn.prepareStatement("delete * from where id=" + '1' + "")
.executeUpdate();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void testDbcp() {
// 创建dbcp连接池核心类
BasicDataSource dataSource = new BasicDataSource();
dataSource.setUrl("jdbc:mysql:///bank");
dataSource.setDriverClassName("com.mysql.jdbc.driver");
dataSource.setUsername("root");
dataSource.setPassword("123456");
// 初始化连接
dataSource.setInitialSize(3);
// 最大连接
dataSource.setMaxActive(6);
// 最大空闲时间
dataSource.setMaxIdle(3000);
try {
conn = dataSource.getConnection();
if (conn != null) {
System.out.println(conn);
}
int i = conn.prepareStatement("delete * from where id=" + '1' + "")
.executeUpdate();
if (i > 0) {
System.out.println("删除成功!");
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}