dbbean.java

Java实例入门

package jspreg;

import java.sql.*;
/**
 * Title:
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:
 * @author
 * @version 1.0
 */

public class dbBean {
  static final String DBDriver  ="sun.jdbc.odbc.JdbcOdbcDriver";
  static final String strConn   ="jdbc:odbc:Java";
  static final String DBusername="sa";
  static final String DBpassword="java";
  private Connection dbCon;
  private Statement  sqlStatement;
  public dbBean() {
  }
  public boolean connect(){
    try {
         DriverManager.registerDriver((Driver)(Class.forName(DBDriver).newInstance()));
         dbCon=DriverManager.getConnection(strConn , DBusername, DBpassword);
         sqlStatement=dbCon.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    }
    catch (Exception e) {
        return false;
    }
    return true ;
  }
  public ResultSet openRs(String sql) throws java.sql.SQLException {
    ResultSet rs = sqlStatement.executeQuery(sql);
    return (rs);
  }
  public boolean  executeSql(String sql){
    try{
        sqlStatement.execute(sql);
    }catch (Exception e) {
        return false;
    }
    return true ;
  }
  public boolean checkLogin(String user,String password) {
    try{
        String sql="select * from users where user_login='"+user+"' and user_password='"+password+"'";
        ResultSet rs = sqlStatement.executeQuery(sql);
        if(rs.next() )
           return true;
        else
           return false;
    }catch (Exception e) {
        return false;
    }
  }
  public void close(){
    try {
         dbCon.close();
         sqlStatement=null;
         dbCon=null;
    }
    catch (Exception e) {
    }
  }
}