1、db.properties文件内容
driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:XE
username=scott
passwd=123456
2、封装类的内容
package com.bjsxt.entity;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class DBUtil {
//声明jdbc全局参数
public static String driver;
public static String url;
public static String username;
public static String passwd;
//使用静态代码块,在类加载到文件时读取
static{
//动态获取对象流
InputStream in = DBUtil.class.getResourceAsStream("/properties");
//创建properties对象
Properties p = new Properties();
//加载
try {
p.load(in);
//将读取的jdbc参数赋值给全局变量
driver=p.getProperty("driver");
url=p.getProperty("url");
username=p.getProperty("username