package com.qhit.db;
import java.io.IOException;
import java.sql.SQLException;
/**
* 得到数据库连接的类
*/
public class DbConn {
private static String user;
private static String password;
private static String url;
private static String driver;
private static DbConn dbConn;
public DbConn(){
java.util.Properties p = new java.util.Properties();
//得到数据库连接的配置文件
java.io.InputStream is = DbConn.class.getResourceAsStream("/db.properties");
try {
//加载配置文件
p.load(is);
//从配置文件里得到用户名、密码、URL
user = p.getProperty("user");
password = p.getProperty("password");
url = p.getProperty("url");
driver = p.getProperty("driver");
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 单例模式
*/
public static DbConn getDbConn(){
if(dbConn != null){
return dbConn;
}else{
dbConn = new DbConn();
return dbConn;
}
}
/**
* 得到数据库连接
*/
public java.sql.Connection getConn(){
java.sql.Connection conn = null;
try {
Class.forName(driver);
conn = java.sql.DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
return conn;
}
}