signup.java

JSP主页基地管理系统

package com.gbsource.homepage.admin;

import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;

/**
 * Title:       华源网络主页基地管理
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      Gbsource Studio
 * @author fishwu
 * @version 1.0
 */

public class Signup {
  private static BeansConstants CONST;

  private static String userid = null;
  private static String password = null;
  public static int checklogin(HttpServletRequest request)
  {
    int value;
    HttpSession session = request.getSession(false);
    userid = request.getParameter(CONST.Userid);
    password = request.getParameter(CONST.Passwd);
    if(userid == null || "".equals(userid)) return CONST.USERID_NULL_ERR;
    if(password == null || "".equals(userid)) return CONST.PASSWORD_NULL_ERR;
    String sql = "select * from admin where userid = ?";
    try{
      Database db = new Database(sql);
      db.setString(1,userid);
      ResultSet rs = db.executeQuery();
      if(rs.next())
      {
        if(rs.getString("password").equalsIgnoreCase(password))
        {
          session.setAttribute(CONST.SUserid,userid);
          value = CONST.RUN_OK;
        }
        else
        {
          value = CONST.PASSWORD_ERR;
        }
      }
      else
      {
        value = CONST.USERID_ERR;
      }
      rs.close();
      rs = null;
      db.close();
      db = null;
    }catch(Exception e){
      value = CONST.DB_ERR;
    }
    sql = null;
    return value;
  }
}