Java中提供了Properties类用来读取属性文件。
第一步:首先我们在项目默认路径(src)下创建文件,名称为db.properties(名称可自定义,但扩展名必须为properties),内容如下
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;DatabaseName=FileManager
user=admin
password=123
第二步:读取属性文件
1、我们建立一个类文件,取名Judge.java,来实现对db.properties文件的加载工作,具体代码如下:
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class Judge extends Properties {
private static Judge instance;
public static Judge getInstance() {
if (instance != null) {
return instance;
} else {
makeInstance();
return instance;
}
}
private static synchronized void makeInstance() {
if (instance == null) {
instance = new Judge();
}
}
private Judge() {
InputStream is = getClass().getResourceAsStream( "/db.properties");
try {
load(is);
} catch (IOException e) {
System.out.println("文件读取失败,请确认db.properties文件是否存在。");
}
}
}
2、我们建立ConnectionManager类来建立数据库的连接(此处我只写了一个连接方法)
private static Connection getCon() {
Connection con = null;
try {
//读取db.properties配置文件
String driver = Judge.getInstance().getProperty("driver");
String url = Judge.getInstance().getProperty("url");
String user = Judge.getInstance().getProperty("user");
String password = Judge.getInstance().getProperty("password");
Class.forName(driver);
con = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}