loginhandler.java

典型的JSP编程,使用了MVC模式设计.很有学习价值,给大家共享

package login;

/* 模型组件 */

import java.sql.*;
import java.util.*;

public 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;}
  }

}