?? jdbcconn.java~3~
字號:
package xscjgl;import java.sql.*;import java.io.*;import java.lang.*;public class Jdbcconn{ private Connection db=null; private Statement stmt=null; ResultSet result=null; public Jdbcconn(){} public void OpenConn(String dsn, String uid, String pwd) throws Exception { try { String strdsn = "jdbc:odbc:mydb;DatabaseName=" + dsn; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); db = DriverManager.getConnection(strdsn, uid, pwd); } catch (Exception e) { e.printStackTrace(); } } public ResultSet getResults(String sproc) throws Exception { Statement stmt = db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet result = stmt.executeQuery(sproc); result.last(); return result; } public void executeUpdate(String sql) { //stmt=null; //result=null; try { stmt = db.createStatement(); stmt.executeQuery(sql); stmt.close(); stmt = null; } catch (SQLException ex) { System.err.println("aq.executeQuery: " + ex.getMessage()); } } public void closeStmt() { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } public void closeConn() { try { db.close(); } catch (SQLException e) { e.printStackTrace(); } }}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -