dbconn.java~2~

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

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 ture;
  }
  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){}
   }
}