?? jdbconnection.java
字號:
package com.victor.tool;import java.sql.SQLException;import java.sql.Statement;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Connection;public class JDBConnection { //JDBC類 String sd = "sun.jdbc.odbc.JdbcOdbcDriver"; String sc = "jdbc:odbc:db_news"; ResultSet rs = null; Connection conect = null; public JDBConnection() { try { Class.forName(sd); } catch (java.lang.ClassNotFoundException e) { System.err.println(e.getMessage()); } } public ResultSet executeQuery(String sql) { try { conect = DriverManager.getConnection(sc); Statement stmt = conect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery(sql); } catch (SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public int executeUpdate(String sql) { int result = 0; try { conect = DriverManager.getConnection(sc); Statement stmt = conect.createStatement(); result = stmt.executeUpdate(sql); } catch (SQLException er) { System.err.println(er.getMessage()); } return result; } public void close() { try { if (conect != null) { conect.close(); } } catch (Exception e) { System.out.println(e); } }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -