项目结构
db.properties文件里的内容
driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:xe
user=system
password=1234
DBUtils 工具类
package cn.lyc.util;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DBUtils {
private static String DRIVER;
private static String URL;
private static String USER;
private static String PASSWORD;
private static Properties props = new Properties();
/**
* 静态加载资源
*/
static {
InputStream is = DBUtils.class.getClassLoader().getResourceAsStream("db.properties");
try {
props.load(is);
DRIVER = props.getProperty("driver");
URL = props.getProperty("url");
USER = props.getProperty("user");
PASSWORD = props.getProperty("password");
Class.forName(DRIVER);
} catch (IOException e) {
e.printStackTrace();
System.out.println("文件读取错误,请查看 DBUtil 表");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("没有找到文件哦,请查看 DRIVER 字符串");
}
}
/**
* 创建连接对象
* @return
*/
public static Connection getConnection(){
Connection cn = null;
try {
cn = DriverManager.getConnection(URL,USER,PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("数据库,连接错误!请查看 DBUtil!");
}
return cn;
}
/**
* 释放资源
* @param cn
* @param st
* @param rs
*/
public static void close (Connection cn, Statement st , ResultSet rs){
t