admin.java~16~

图书管理系统,B/S,C/S都有,附有源代码

package admin;

import java.sql.ResultSet;
import java.util.Vector;
import database.*;
import javax.servlet.http.HttpServletRequest;

/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class admin {

  private javax.servlet.http.HttpServletRequest request; //建立页面请求

  private String adminId; //管理员编号
  private String adminName; //管理员昵称
  private String adminPwd; //管理员密码
  private int adminPower; //管理员的管理等级
  private String adminLocked; //管理员是否被锁定
  private String adminCT; //管理员创建时间
  private int adminAvail; //管理员有效期限
  private String adminLLT; //管理员上一次登录时间
  private String adminComment; //管理员备注

  private String adminBB; //管理员图书借阅操作权限
  private String adminRB; //管理员图书归还操作权限
  private String adminCB; //管理员图书续借操作权限
  private String adminSB; //管理员图书查询权限
  private String adminSR; //管理员读者查询权限
  private String adminBO; //管理员图书修改权限
  private String adminRO; //管理员读者修改权限
  private String adminSS; //管理员馆藏统计权限
  private String adminBA; //管理员借阅分析权限
  private String adminBS; //管理员修改系统基本设置权限
  private String adminSA; //管理员管理管理员权限
  private String adminTag; //管理员等级说明权限

  public void setAdminId(String newId) {
    adminId = newId;
  }

  public String getAdminId() {
    return adminId;
  }

  public String getAdminName() {
    return adminName;
  }

  public void setAdminPwd(String newPwd) {
    adminPwd = newPwd;
  }

  public int getAdminPower() {
    return adminPower;
  }

  public String getAdminLocked() {
    return adminLocked;
  }

  public String getAdminCT() {
    return adminCT;
  }

  public int getAdminAvail() {
    return adminAvail;
  }

  public String getAdminLLT() {
    return adminLLT;
  }

  public String getAdminComment() {
    return adminComment;
  }

  public String getAdminBB() {
    return adminBB;
  }

  public String getAdminRB() {
    return adminRB;
  }

  public String getAdminCB() {
    return adminCB;
  }

  public String getAdminSB() {
    return adminSB;
  }

  public String getAdminSR() {
    return adminSR;
  }

  public String getAdminBO() {
    return adminBO;
  }

  public String getAdminRO() {
    return adminRO;
  }

  public String getAdminSS() {
    return adminSS;
  }

  public String getAdminBA() {
    return adminBA;
  }

  public String getAdminBS() {
    return adminBS;
  }

  public String getAdminSA() {
    return adminSA;
  }

  public String getAdminTag() {
    return adminTag;
  }

  public boolean adminLogin(HttpServletRequest res) throws
      Exception {

    //获取页面请求信息
    request = res;

    DataBase db = new DataBase();
    DateTime dt = new DateTime();
    MD5 md5 = new MD5();

    adminId = request.getParameter("adminId");
    adminPwd = db.toSql(md5.getMD5ofStr(request.getParameter("adminPwd")));

    db.prepareStatement("select * from Admin where 管理编号 = ? and 密码 = ?");
    db.setString(1, adminId);
    db.setString(2, adminPwd);

    ResultSet rs = db.executeQuery();
    if (rs.next()) {
      adminName = rs.getString(2);
      adminPower = Integer.parseInt(rs.getString(4));
      adminLocked = rs.getString(5);
      adminCT = rs.getString(6);
      adminAvail = Integer.parseInt(rs.getString(7));
      adminLLT = rs.getString(8);
      adminComment = rs.getString(9);
      rs.close();

      //更新最后登录时间
      String newLLT = dt.getDateTime();
      db.executeUpdate("update Admin set 上次登录 = '" + newLLT +
                       "' where 管理编号 = '" +
                       adminId + "'");
      //关闭连接
      db.close();

      return true;
    }
    else {
      rs.close();
      return false;
    }
  }

  public boolean adminInfo(String newId) throws
      Exception {
    DataBase db = new DataBase();
    adminId = db.toSql(newId);
    db.prepareStatement("select * from Admin where 管理编号 = ?");
    db.setString(1, adminId);
    ResultSet rs = db.executeQuery();
    if (rs.next()) {
      adminName = rs.getString(2);
      adminPower = Integer.parseInt(rs.getString(4));
      adminLocked = rs.getString(5);
      adminCT = rs.getString(6);
      adminAvail = Integer.parseInt(rs.getString(7));
      adminLLT = rs.getString(8);
      adminComment = rs.getString(9);
    }
    else {
      return false;
    }
    db.prepareStatement("select * from AdminLevel where 管理权限 = ?");
    db.setString(1, Integer.toString(adminPower));
    rs = db.executeQuery();
    if (rs.next()) {
      adminBB = rs.getString(2); //管理员图书借阅操作权限
      adminRB = rs.getString(3); //管理员图书归还操作权限
      adminCB = rs.getString(4); //管理员图书续借操作权限
      adminSB = rs.getString(5); //管理员图书查询权限
      adminSR = rs.getString(6); //管理员读者查询权限
      adminBO = rs.getString(7); //管理员图书修改权限
      adminRO = rs.getString(8); //管理员读者修改权限
      adminSS = rs.getString(9); //管理员馆藏分析权限
      adminBA = rs.getString(10); //管理员借阅分析权限
      adminBS = rs.getString(11); //管理员修改系统基本设置权限
      adminSA = rs.getString(12); //管理员管理管理员权限
      adminTag = rs.getString(13); //管理员等级说明权限
      rs.close();
      return true;
    }
    else {
      return false;
    }
  }

}