dbconn.java~3~

来自「java语言写的」· JAVA~3~ 代码 · 共 41 行

package scoremis;
import java.sql.*;
import java.io.*;
public class dbconn{
  public Connection conn;
  public Statement stmt;
  public ResultSet rs=null;
  public dbconn(){
    this.connect();
  }
  public boolean connect(){
    try{
      Class.forName("sun.jdbc.odbc.jdbcodbcdriver");
      conn=DriverManager.getConnection("jdbc:odbc:stu","","");
      stmt=conn.createStatement();
    }catch(Exception ee){
      return false;
    }
    return true;
  }
  public ResultSet Query(String sql){
    try{
      rs=stmt.executeQuery(sql);
    }catch(Exception e){}
     return rs;
  }
    public int Update(String sql){
      int i = 0;
      try {
        i = stmt.executeUpdate(sql);
      }
      catch (Exception e){}
      return i;
     }
     public void close (){
       try{
      stmt.close();
         conn.close();
       }catch(Exception e){}
     }
}