?? sql_data.java~3~
字號:
package bean;import java.sql.*;public class sql_data { String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; String sConnStr = "jdbc:odbc:TSR"; Connection conn = null; ResultSet rs = null; public sql_data() { try { Class.forName(sDBDriver);//加載驅(qū)動(dòng)程序 } catch(java.lang.ClassNotFoundException e) { System.err.println("sql_data(): " + e.getMessage()); } } public void executeInsert(String sql) { try { conn = DriverManager.getConnection(sConnStr);//建立與數(shù)據(jù)庫的連接 Statement stmt = conn.createStatement();//創(chuàng)建Statement對象 stmt.executeUpdate(sql);//執(zhí)行SQL語句 } catch(SQLException ex) { System.err.println("sql_data.executeUpdate:"+ex.getMessage()); } } public ResultSet executeQuery(String sql) { rs = null;//定義結(jié)果集 try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println("sql_data.executeQuery:"+ex.getMessage()); } return rs; } public void executeDelete(String sql) { try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(); stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println("sql_data.executeDelete:"+ex.getMessage()); } }}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -