borrow.java~4~

图书管理系统,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();
    newReaderSN = db.toSql(newReaderSN);

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

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

      while (rs.next()) {

        BD = rs.getString(4);
        RD = rs.getString(5);

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

      }

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

  }
}