borrow.java~9~

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

package book;

import database.DataBase;
import database.DateTime;
import java.sql.ResultSet;

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

public class borrow {

  private String Err;
  private String readerSN;
  private String bookSN;

  public String getBookSN() {
    return bookSN;
  }

  public String getReaderSN() {
    return readerSN;
  }

  public boolean borrow() {

    return true;
  }


  public boolean isExpBook(String newReaderSN) throws Exception {
    String BD; //借书日期
    String RD; //还书日期

    DataBase db = new DataBase();

    //获取该读者的图书借阅情况
    db.prepareStatement("select * from Borrow where 读者编号 = ?");
    db.setString(1, db.toSql(newReaderSN));
    ResultSet rs = db.executeQuery();

    if (rs.next()) {
      DateTime dt = new DateTime();
      rs.beforeFirst();

      String CD=dt.getDate();
      while (rs.next()) {

        RD = rs.getString(5);

        if (dt.compareDate(CD, RD)) {
          bookSN = rs.getString(1);
          readerSN = rs.getString(2);
          rs.close(); //关闭结果集
          return true;
        }

      }

      rs.close(); //关闭结果集
      return false;
    }
    else {
      rs.close(); //关闭结果集
      return false;
    }

  }
}