returnbook.java~1~

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

package book;

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

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

  public String getErrMsg() {
    return errMsg;
  }

  public boolean returnBook(HttpServletRequest res) throws
      Exception {

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

    //查询是否有借阅信息
    if (book.isBorrow(newBookSN)) {
      return true;
    }
    else {
      errMsg = "没有编号为" + newBookSN + "图书的借阅信息!";
      return false;
    }

  }

  public boolean exeReturn(HttpServletRequest res) throws
      Exception {

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

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

    try {

      //更新图书在库状态
      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;
    }
  }

}