三个jar依赖(maven项目):Junit jdbc org.apache.tomcat.dbcp
一个database.properties文件内容如下:
#数据库的配置信息
#key.key2=value
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@119.29.159.215:8771:orcl
jdbc.username=scott
jdbc.password=tiger
initSize=10
maxSize=200
连接池代码:
package HuangCD.Util;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
public class DBUtil {
//连接池对象
private static BasicDataSource ds;
private DBUtil(){
}
//加载参数
static{
Properties p = new Properties();
try {
p.load(DBUtil.class.getClassLoader().getResourceAsStream("database.properties"));
String driver = p.getProperty("jdbc.driver");
String url = p.getProperty("jdbc.url");
String user = p.getProperty("jdbc.username");
String pwd = p.getProperty("jdbc.password");
String initSize = p.getProperty("initSize");
String maxSize = p.getProperty("maxSize");
//创建连接池
ds = new BasicDataSource();
//设置参数
ds.setDriverClassName(driver);
ds.setUrl(url);
ds.setUsername(user);
ds.setPassword(pwd);
ds.setInitialSize(new Integer(initSize));
ds.setMaxActive(new Integer(maxSize));
} catch (IOException e) {
e.printStackTrace();
throw new RuntimeException("加载配置文件失败",e);
}
}
/*
* 以上就是将配置文件里的参数全部读取出来,接下来就是要
* 写两个方法,一个是用来创建连接的,一个关闭连接
* */
public static Connection getConnection() throws SQLException{
return ds.getConnection();
}
public static void close(Connection conn){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("关闭连接失败",e);
}
}
}
}测试代码:
package HuangCD.Util;
import java.sql.Connection;
import java.sql.SQLException;
import org.junit.Test;
public class Testdb {
@Test
public void test01(){
Connection conn = null;
try {
conn = DBUtil.getConnection();
System.out.println("OK!");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBUtil.close(conn);
}
}
}
测试成功: