userlogin.java

只是一网站项目不错的可以看看的不看会后悔啊

package com.hygj.sunqi.j2ee.bean;
import org.apache.log4j.Logger;
import com.hygj.sunqi.j2ee.util.DBConn;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class UserLogin {
  private String userName = "";
  private String passWord = "";
  private boolean isSucc = false;
  private Connection conn = null;
  private PreparedStatement pstmt = null;
  private ResultSet rs = null;
  private String sql = null;
  private static Logger log = null;
  private DBConn dbConn = null;
  public UserLogin() {
  }
  public void setUserName(String parUserName){
    userName = parUserName;
  }
  public void setPassWord(String parPassWord){
    passWord = parPassWord;
  }
  public String getUserName(){
    return userName;
  }
  public String getPassWord(){
    return passWord;
  }
  public boolean isSuc(){
    this.exec();
    return isSucc;
  }
  private void exec(){
    try{
      conn = dbConn.getConn();
      sql = "SELECT passWord FROM users WHERE userName=?";
      pstmt = conn.prepareStatement(sql);
      pstmt.setString(1,userName);
      rs = pstmt.executeQuery();
      if(rs.next()){
        if(rs.getString("passWord").equals(passWord)){
          isSucc = true;
        }
      }
      rs.close();
      pstmt.close();
      conn.close();
    }catch(Exception e){
      log = Logger.getLogger(UserLogin.class);
      log.error("sdfd");
      log.error(e);
    }
  }


}