dbjspbean.java

一个聊天系统

package chatroomweb;
import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class DbJspBean {
  static final String DbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  static final String strConn="jdbc:odbc:chatroom";
  private Connection dbCon;
  private Statement stl;

  public DbJspBean()
  {

  }
  public boolean connect()
  {
    try{
      DriverManager.registerDriver((Driver)(Class.forName(DbDriver).newInstance()));
      dbCon=DriverManager.getConnection(strConn);
      stl=dbCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
    }
    catch(Exception e)
    {
      return false;
    }
    return true;
  }
  public ResultSet openRs(String sql) throws java.sql.SQLException {
    ResultSet rs = stl.executeQuery(sql);
    return (rs);
  }
  public boolean  executeSql(String sql){
    try{
        stl.execute(sql);
    }catch (Exception e) {
        return false;
    }
    return true ;
  }
  public boolean checkLogin(String user,String password) {
    try{
      String sql="select * from admin_info where admin_name='"
                +user+"'and admin_pwd='"+password+"'";
            ResultSet rs=stl.executeQuery(sql);
        if(rs.next() )
           return true;
        else
           return false;
    }catch (Exception e) {
        return false;
    }
  }
  public void close(){
    try {
         dbCon.close();
         stl=null;
         dbCon=null;
    }
    catch (Exception e) {
    }
  }

}