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(sql);      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);    }  }}