一、寫屬性文件 后綴名為 properties
寫入如下內(nèi)容：
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1;database=MyBlogHome
uid=sa
pwd=123456
注：這里就是 鍵值對(duì)方式的 名稱和值 一定要用 “=” 隔開
二、寫一個(gè)讀取屬性文件的類 繼承自 Properties 類
代碼如下：
package com.lwm.dao;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
public class PropertiesReader extends Properties {
private Properties pro;
public String get(String key){
pro = new Properties();
//該方法是打開并讀取一個(gè)String類型參數(shù)指定的文件到系統(tǒng)內(nèi)存中，以方便獲得文件信息
InputStream is = this.getClass().getResourceAsStream("/db.properties"); //千萬別忘記加上路徑 如 "/" 代表根目錄
try {
pro.load(is);
} catch (IOException e) {
e.printStackTrace();
}
return pro.getProperty(key);
}
}
三、寫B(tài)aseDao類
代碼如下：
package com.lwm.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
PropertiesReader proReader = new PropertiesReader();
private String driver = proReader.get("driver");
private String url = proReader.get("url");
private String uid = proReader.get("uid");
private String pwd = proReader.get("pwd");
protected Connection connection = null;
protected PreparedStatement statement = null;
protected ResultSet result = null;
public Connection getConnection(){
try {
Class.forName(driver);
connection = DriverManager.getConnection(url,uid,pwd);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
|
