package com;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import snaq.db.ConnectionPool;
public class DBConn {
public static Connection conn = null;
public static ConnectionPool pool = null;
public static void main(String[] args) {
System.out.println(getConn());
free(conn,null,null);
}
public static Connection getConn() {
try {
Class<?> c = Class.forName("oracle.jdbc.driver.OracleDriver");
Driver driver = (Driver) c.newInstance();
DriverManager.registerDriver(driver);
pool = new ConnectionPool("db", 10, 100, 4,
"jdbc:oracle:thin:@localhost:1521:orcl", "system", "root");
long timeOut = 3000;
conn = pool.getConnection(timeOut);
} catch (Exception e) {
// TODO: handle exception
System.out.println("获取连接对象异常!!");
e.printStackTrace();
}
return conn;
}
public static void free(Connection conn,
Statement stmt, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
// TODO: handle exception
System.out.println("关闭连接异常!!");
e.printStackTrace();
}
if (pool != null) {
pool.release();
}
}
}
DBPool连接池
最新推荐文章于 2022-02-22 17:09:16 发布