?? dbconnection.java~9~
字號:
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(); }}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -