?? sql_data.java
字號:
package webtest;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: 天津財經學院 信息管理與信息系統——高職升本0101班 * @author 王剛 * @version 1.0 */public class Sql_data { String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver"; //String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String sConnStr="jdbc:odbc:SQLServer"; //String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test"; Connection conn=null; ResultSet rs=null; public Sql_data() { try{ Class.forName(sDBDriver); } catch(java.lang.ClassNotFoundException e) { System.err.println("Sql_data():"+e.getMessage()); } } public void getConn() { try {conn=DriverManager.getConnection(sConnStr,"sa","");} catch(SQLException ex) {System.err.println("Sql_data.executeUpdate:"+ex.getMessage());} } public void insert(String sql) { try { Statement stmt=conn.createStatement(); stmt.executeUpdate(sql); } catch(SQLException e) { System.err.println("Sql_data.insert:"+e.getMessage()); } } public ResultSet query(String sql) { try { Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery(sql); } catch(SQLException e) { System.err.println("Sql_data.query()"+e.getMessage()); } return rs; } public void executeInsert(String sql) { try { conn=DriverManager.getConnection(sConnStr,"sa",""); Statement stmt=conn.createStatement(); stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println("Sql_data.executeUpdate:"+ex.getMessage()); } } public ResultSet executeQuery(String sql) { rs=null; try { conn=DriverManager.getConnection(sConnStr,"sa",""); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); 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,"sa",""); Statement stmt=conn.createStatement(); stmt.executeUpdate(sql); } catch(SQLException ex) { System.err.println("Sql_data.executeDelete:"+ex.getMessage()); } } public void close() { try { rs.close(); conn.close(); } catch (SQLException e) { System.err.println(e.getMessage()); } } public void closeconn() { try{ conn.close(); } catch(SQLException e) { System.err.println(e.getMessage()); } };}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -