conn.java

来自「一个完善的班级网站的实现」· Java 代码 · 共 42 行

//conn.java
package classnet;
import java.sql.*;
public class conn{
  String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr="jdbc:odbc:ClassDB";
  Connection connect=null;
  ResultSet rs=null;
  public conn(){
      try{

            Class.forName(sDBDriver);
         }
      catch(java.lang.ClassNotFoundException e){
       System.err.print(e.getMessage());
       }
    }
  public ResultSet executeQuery(String sql){
      try{
          connect=DriverManager.getConnection(sConnStr);
          Statement stmt=connect.createStatement();
          rs=stmt.executeQuery(sql);
       }
      catch(SQLException ex){
       System.err.print(ex.getMessage());
       }
       return rs;
    }
  public int executeUpdate(String sql){
  	int temp=0;
      try{
          connect=DriverManager.getConnection(sConnStr);
          Statement stmt=connect.createStatement();
          temp=stmt.executeUpdate(sql);
       }
      catch(SQLException ex){
       System.err.print(ex.getMessage());
       }
       return temp;
    }
}