package chatroom;
import java.sql.*;

/**
 * Title:        JSP聊天室
 * Description:  Java語言演示程序：JSP聊天室，用于北京師范大學計算機系Java課程教學示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京師范大學計算中心
 * @author 張慶利
 * @version 1.0
 */

public class DBconn {
   String DBDriver="interbase.interclient.Driver";
   String ConnStr="dbc:interbase:chatroom.gdb";
   String User="SYSDBA";
   String Password="masterkey";
   Connection conn = null;
   ResultSet rs = null;
   public DBconn(){
      try{
        Class.forName(DBDriver);
      }
      catch(java.lang.ClassNotFoundException e){
        System.err.println("加載驅動失敗：" + e.getMessage());
      }
   }
   public ResultSet executeQuery(String sql){
     rs = null;
      try{
        conn = DriverManager.getConnection(ConnStr,User,Password);
         Statement stmt = conn.createStatement();
         rs = stmt.executeQuery(sql);
        }
      catch(SQLException ex){
        System.err.println("連接數據庫失敗："+ex.getMessage());
      }
      return rs;
   }
}