创建一个utils包下的JDBCUtil来简化主函数中的冗余代码
package JavaWeb.day05.utils;
import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;
public class JDBCUtil {
private static String url;
private static String user;
private static String password;
private static String driver;
// 注册驱动
static {
// 读取配置文件,加载url,user,password三个参数
Properties prop = new Properties();
try {
// 只能写 绝对路径 不会报错 否则 提示找不到系统文件
// prop.load(new FileReader("src/JavaWeb/day05/prpo.properties"));
ClassLoader classLoader = JDBCUtil.class.getClassLoader();
URL resource = classLoader.getResource("JavaWeb/day05/prpo.properties"); // 相对src的路径
String path = resource.getPath();
// System.out.println(path);
// path = /D:/IDEA/codes/basic-code/out/production/day-code/JavaWeb/day05/prpo.properties
prop.load(new FileReader(path));
url = prop.getProperty("url");
user = prop.getProperty("user");
password = prop.getProperty("password");
driver = prop.getProperty("driver");
// 读取 数据库驱动
Class.forName(driver)