loginhander.java

来自「这个是j2eejava web 编程精要十五讲的全部源码。对学习java web」· Java 代码 · 共 37 行

package login;

/* 模型组件 */
import java.sql.*;
import java.util.*;

class LoginHandler {
  public LoginHandler() {  }

Connection conn;
  PreparedStatement ps;
  ResultSet rs;
 //检查是否已注册
  public boolean checkLogin(ArrayList arr)
  {
    //从数据访问组件DBPool中取得连接
    conn = DBPool.getConnection();
    String name = (String)arr.get(0);
    String password = (String)arr.get(1);
    try {
      String sql = "select * from T_UserInfo where username=? and password=?";
      ps = conn.prepareStatement(sql);
      ps.setString(1,name);
      ps.setString(2,password);
      rs = ps.executeQuery();
      if(rs.next()) {
         DBPool.dbClose(conn,ps,rs); //释放资源
          return true;
        }
      else {
        DBPool.dbClose(conn,ps,rs);
        return false;
      }
    } catch (SQLException e) {return false;}
  }
}