?? database.java
字號:
import java.sql.*;/** * 連接數據庫的類 */public class Database { private Statement stmt=null; ResultSet rs=null; private Connection conn=null; String sql; String strurl="jdbc:odbc:scmanage"; public Database(){ } /** * 打開數據庫連接 */ public void OpenConn()throws Exception{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.getConnection(strurl); } catch(Exception e){ System.err.println("OpenConn:"+e.getMessage()); } } /** * 執行sql語句，返回結果集rs */ public ResultSet executeQuery(String sql){ stmt = null; rs=null; try{ stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); } catch(SQLException e){ System.err.println("executeQuery:"+e.getMessage()); } return rs; } /** * 執行sql語句 */ public void executeUpdate(String sql){ stmt=null; rs=null; try{ stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt.executeQuery(sql); conn.commit(); } catch(SQLException e){ System.err.println("executeUpdate:"+e.getMessage()); } } public void closeStmt(){ try{ stmt.close(); } catch(SQLException e){ System.err.println("closeStmt:"+e.getMessage()); } } /** * 關閉數據庫連接 */ public void closeConn(){ try{ conn.close(); } catch(SQLException ex){ System.err.println("aq.closeConn:"+ex.getMessage()); } } /* *轉換編碼 */ public static String toGBK(String str){ try { if(str==null) str = ""; else str=new String(str.getBytes("ISO-8859-1"),"GBK"); } catch (Exception e) {System.out.println(e);} return str; }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -