?? dbmanager.java~4~
字號:
package bookmanager;import java.sql.*;public class DBManager { ResultSet rs ; //定義結果集 String strurl="jdbc:odbc:myBook"; public DBManager() { } public ResultSet getResult(String sql){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; Connection conn=DriverManager.getConnection(strurl) ; Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs=stmt.executeQuery(sql); return rs; } catch(Exception e){ System.out.println( "getResult------"+e.toString() ); } return rs; } public boolean executeSql(String sql){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; Connection conn=DriverManager.getConnection(strurl) ; Statement stmt=conn.createStatement(); stmt.executeUpdate(sql); conn.commit(); return true; } catch(Exception e){ System.out.println( "executeSql------"+e.toString() ); return false; } } public int executeSqlupdate(String sql){ try{ int intreturn=0; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; Connection conn=DriverManager.getConnection(strurl) ; Statement stmt=conn.createStatement(); intreturn= stmt.executeUpdate(sql); conn.commit(); return intreturn; } catch(Exception e){ System.out.println( "executeSql------"+e.toString() ); return 0; } } }?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -