DBConnection

package com.sinosoft.webmodule.historyIssues.utils;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
* 连接中间库
* @className DBConnection.java
* @packageName com.sinosoft.webmodule.historyIssues.utils
* @date 2013-10-10 下午03:47:31
* @author zhangyangbin
* @version v1.0.0
*/
public class DBConnection {
private String url="";
private String username="";
private String password="";
private String driver="";
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;

public DBConnection(){
Properties pro=new Properties();
try {
pro.load(DBConnection.class.getResourceAsStream("/app/historyIssues.properties"));
url=pro.getProperty("jdbc.url");
username=pro.getProperty("jdbc.username");
password=pro.getProperty("jdbc.password");
driver=pro.getProperty("jdbc.driverClassName");
} catch (IOException e) {
e.printStackTrace();
}
}

public void OpenConn() {
try {
Class.forName(this.driver);
con = DriverManager.getConnection(this.url, this.username, this.password);
} catch (Exception e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql) {
stmt = null;
rs = null;
try {
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}



public void closeConn(){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

}