returnbook.java

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

package book;

import java.sql.*;
import database.DataBase;
import book.Books;
import admin.admin;
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 returnBook {

  private String errMsg;
  private javax.servlet.http.HttpServletRequest request; //建立页面请求
  private javax.servlet.http.HttpSession session; //接收页面SESSION

  public String getErrMsg() {
    return errMsg;
  }

  public boolean returnBook(HttpServletRequest res, HttpSession ses) throws
      Exception {

    DataBase db = new DataBase();

    //获取页面请求信息
    request = res;
    String newBookSN = request.getParameter("bookSN");

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

    db.close();

    //查询是否有借阅信息
    admin admin = new admin();
    if (admin.isAdminRB(supervisor)) {
      Books book = new Books();
      if (book.isBorrow(newBookSN)) {
        return true;
      }
      else {
        errMsg = "没有编号为" + newBookSN + "图书的借阅信息!";
        return false;
      }
    }
    else {
      errMsg = "编号为" + supervisor + "的管理员没有权限进行归还图书的操作!";
      return false;
    }

  }

  public boolean exeReturn(HttpServletRequest res) throws
      Exception {

    try {

      DataBase db = new DataBase();

      //获取页面请求信息
      request = res;
      String newBookSN = db.toSql(request.getParameter("bookSN"));

      //更新图书在库状态
      db.prepareStatement("update Book set 是否在库 = '1' where 图书编号 = ?");
      db.setString(1, newBookSN);
      db.executeUpdate();

      //删除图书借阅信息
      db.prepareStatement("delete from Borrow where 图书编号 = ?");
      db.setString(1, newBookSN);
      db.executeUpdate();

      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }
  }

}