renewbook.java~7~

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

package book;

import database.DataBase;
import database.DateTime;
import java.sql.ResultSet;
import reader.Readers;
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 renewBook {

  private String errMsg;
  private String readerSN;
  private String bookSN;
  private javax.servlet.http.HttpServletRequest request; //建立页面请求

  public String getErrMsg() {
    return errMsg;
  }

  public String getBookSN() {
    return bookSN;
  }

  public String getReaderSN() {
    return readerSN;
  }

  public boolean renewBook(HttpServletRequest res) throws Exception {

    //获取页面请求信息
    request = res;
    DataBase db = new DataBase();

    String newBookSN = db.toSql(request.getParameter("bookSN"));

    Readers reader = new Readers();
    Books book = new Books();

    if (book.isBorrow(newBookSN)) {
      if (!book.isBookExp(newBookSN)) {
        if (!book.isCBRL(newBookSN)) {
          return true;
        }
        else {
          errMsg = "编号为" + newBookSN + "的图书续借次数已满,无法续借!";
          return false;
        }
      }
      else {
        errMsg = "编号为" + newBookSN + "逾期未还,无法进行续借手续!";
        return false;
      }
    }
    else {
      errMsg = "没有编号为" + newBookSN + "的借阅信息!";
      return false;
    }

  }

  public boolean exeRenew(HttpServletRequest res) throws Exception {

    //获取页面请求信息
    request = res;
    DataBase db = new DataBase();
    DateTime dt = new DateTime();
    Readers reader = new Readers();
    Books book = new Books();

    String newBookSN = db.toSql(request.getParameter("bookSN"));

    try {
      //获取图书借阅信息
      db.prepareStatement("select 读者编号,还书日期,续借 from Borrow where 图书编号 = ?");
      db.setString(1, newBookSN);
      ResultSet rs = db.executeQuery();
      String newReaderSN = db.toSql(rs.getString(1));
      String RD = rs.getString(2);
      int CB = Integer.parseInt(rs.getString(3));
      rs.close();

      //获取续借次数和续借期限
      reader.getReaderPower(newReaderSN);
      int RPCT = reader.getRPCT(); //续借期限

      //更新还书日期和续借次数
      String newRD = dt.gainMonth(RD, RPCT);
      String newCB = Integer.toString(CB++);

      //写入还书日期和续借次数
      db.prepareStatement("update Borrow set 还书日期 = ? ,续借 = ? where 图书编号 = ?");
      db.setString(1, newRD);
      db.setString(2, newCB);
      db.setString(3, newBookSN);
      db.executeUpdate();

      return true;
    }
    catch (Exception e) {
      errMsg = "编号为" + newBookSN + "的图书续借失败!"+e;
      return false;
    }

  }

}