opendb.java

基于jsp和javabean,实现了选择聊天室

package CHAT;
import java.sql.*;
public class opendb
{
  String sdbdriver="sun.jdbc.odbc.JdbcOdbcDriver";
  String sconnstr="jdbc:odbc:VMWEB";
  Connection conn=null;
  ResultSet rs=null;
  public opendb()
  { try
    { Class.forName(sdbdriver);
    }
    catch(Exception e)
    { System.err.println(e.getMessage());}
  }
  public ResultSet executeQuery(String sql)
  { rs=null;
    try
    { conn=DriverManager.getConnection(sconnstr,"SYSADM","SIM");
      Statement stmt=conn.createStatement();
      rs=stmt.executeQuery(sql);
    }
    catch(Exception e)
    {System.err.println(e.getMessage());}
    return rs;
  }
}