package espc;import java.io.*;import java.sql.*;import java.util.Properties;public class DbConnection{    Connection conn=null;    Statement stmt=null;    ResultSet rset=null;    //構(gòu)造方法    public DbConnection()    {    }    public boolean openConnection()    {    //-----------------------------------------------------------------    //裝載數(shù)據(jù)庫的Property文件：其中包括數(shù)據(jù)庫驅(qū)動，數(shù)據(jù)庫URL，即用戶ID和密碼    //-----------------------------------------------------------------      Properties prop = new Properties();        try        {            InputStream is = getClass().getResourceAsStream("Db.properties");            prop.load(is);            if(is != null)             is.close();        }        catch(IOException e)        {            System.out.println("[DbConnection]打開文件時出現(xiàn)錯誤！");        }        String jdbc = prop.getProperty("drivers");        String url = prop.getProperty("url");        String user = prop.getProperty("user");        String password = prop.getProperty("password");        System.out.println(String.valueOf(String.valueOf((new StringBuffer("jdbc＝[")).append(jdbc).append("]"))));        System.out.println(String.valueOf(String.valueOf((new StringBuffer("url＝[")).append(url).append("]"))));        System.out.println(String.valueOf(String.valueOf((new StringBuffer("user＝[")).append(user).append("]"))));        System.out.println(String.valueOf(String.valueOf((new StringBuffer("password＝[")).append(password).append("]"))));        try        {            Class.forName(jdbc);            System.out.println("驅(qū)動程序加載成功！");        }        catch(ClassNotFoundException e)        {            System.out.println("JDBC登陸過程中出現(xiàn)錯誤".concat(String.valueOf(String.valueOf(e.getMessage()))));            boolean flag = false;            return flag;        }        try        {            conn = DriverManager.getConnection(url, user, password);            System.out.println("數(shù)據(jù)庫連接成功！！");        }        catch(SQLException e)        {            System.out.println("數(shù)據(jù)庫連接過程中出現(xiàn)錯誤".concat(String.valueOf(String.valueOf(e.getMessage()))));            boolean flag1 = false;            return flag1;        }        return true;    }    public ResultSet executeQuery(String query)        throws SQLException    {        stmt = conn.createStatement(1004, 1007);        rset = stmt.executeQuery(query);        return rset;    }    public void executeUpdate(String query)        throws SQLException    {        stmt = conn.createStatement(1004, 1008);        stmt.executeUpdate(query);        if(stmt != null)            stmt.close();    }    public void close()        throws SQLException    {        if(conn != null)            conn.close();        if(rset != null)            rset.close();        if(stmt != null)            stmt.close();    }    protected void finalize()        throws Throwable    {        close();    }}