admin.java

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

package admin;

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

/**
 * <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 javax.servlet.http.HttpSession session; //接收页面SESSION

  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 boolean isAdminBB() {
    if (adminBB.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  public boolean isAdminRB() {
    if (adminRB.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminCB() {
    if (adminCB.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminSB() {
    if (adminSB.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminSR() {
    if (adminSR.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminBO() {
    if (adminBO.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminRO() {
    if (adminRO.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminSS() {
    if (adminSS.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminBA() {
    if (adminBA.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminBS() {
    if (adminBS.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  public boolean isAdminSA() {
    if (adminSA.equals("1")) {
      return true;
    }
    else {
      return false;
    }

  }

  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(HttpSession ses) throws
      Exception {
    DataBase db = new DataBase();

    //从SESSION中获取管理员ID
    session = ses;
    String supervisor = db.toSql( (String) session.getAttribute("supervisor"));

    adminId = db.toSql(supervisor);
    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);

      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();
        db.close();
        return true;
      }
      else {
        //关闭数据库连接
        rs.close();
        db.close();
        return false;
      }

    }
    else {
      //关闭数据库连接
      rs.close();
      db.close();
      return false;
    }

  }

  public boolean checkAdminPower(HttpSession ses) throws Exception {

    DataBase db = new DataBase();

    //从SESSION中获取管理员ID
    session = ses;
    String supervisor = db.toSql( (String) session.getAttribute("supervisor"));

    db.prepareStatement(
        "select * from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, supervisor);
    ResultSet rs = db.executeQuery();
    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); //管理员读者修改权限
    rs.close();
    db.close();
    return true;
  }

  //管理员是否具有图书借阅操作权限
  public boolean isAdminBB(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 借阅 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminBB = rs.getString(1);
    rs.close();
    db.close();
    if (adminBB.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有图书归还操作权限
  public boolean isAdminRB(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 还书 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminRB = rs.getString(1);
    rs.close();
    db.close();
    if (adminRB.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有图书续借操作权限
  public boolean isAdminCB(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 续借 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminCB = rs.getString(1);
    rs.close();
    db.close();
    if (adminCB.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有查询图书权限
  public boolean isAdminSB(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 查询图书 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminSB = rs.getString(1);
    rs.close();
    db.close();
    if (adminSB.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有查询读者权限
  public boolean isAdminSR(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 查询读者 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminSR = rs.getString(1);
    rs.close();
    db.close();
    if (adminSR.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有图书修改权限
  public boolean isAdminBO(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 图书操作 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminBO = rs.getString(1);
    rs.close();
    db.close();
    if (adminBO.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

  //管理员是否具有读者修改权限
  public boolean isAdminRO(String newId) throws
      Exception {
    DataBase db = new DataBase();
    db.prepareStatement(
        "select 读者操作 from AdminLevel where 管理权限 = (select 管理权限 from Admin where 管理编号 = ?)");
    db.setString(1, newId);
    ResultSet rs = db.executeQuery();
    rs.next();
    adminRO = rs.getString(1);
    rs.close();
    db.close();
    if (adminRO.equals("1")) {
      return true;
    }
    else {
      return false;
    }
  }

}