编写DBUtil连接数据库工具类
db.properties文件
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.username=scott
jdbc.password=tiger
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
DBUtil工具类
package com.abc.web.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
/**
* 连接数据库的工具类
*
*/
public class DBUtil {
private static String driverName="";
private static String jdbcUrl="";
private static String jdbcUsername="";
private static String jdbcPassword="";
static
{
//给上面的变量赋值
//如何读取类路径下的属性文件呢?
Properties prop=new Properties();
try {
//使用类加载器加载资源,资源一定放在类目录下
prop.load(DBUtil.class.getClassLoader().getResourceAsStream("db.properties"));
driverName=prop.getProperty("jdbc.driver");
jdbcUrl=prop.getProperty("jdbc.url");
jdbcUsername=prop.getProperty("jdbc.username");
jdbcPassword=prop.getProperty("jdbc.password");
Class.forName(driverName);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection()
{
Connection conn=null;
//Class.
try {
conn=DriverManager.getConnection(jdbcUrl, jdbcUsername, jdbcPassword);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 释放资源的公共方法
* @return
*/
public static void release(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) {
e.printStackTrace();
}
}
}