conn.java

一个完善的班级网站的实现

//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;
    }
}