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