borrowtableoperation.java

一个用JSP写的基于了B/S的图书馆管理系统

package web;
import lms.*;
import java.util.Vector;

public class BorrowTableOperation extends DataBase
{
  private String UserID;
  private int sum;

  public BorrowTableOperation()
  {
    super();
    this.sum=0;
  }

  public void setUserID(String UserID)
  {
    this.UserID = UserID;
  }
  public String getUserID()
  {
    return this.UserID;
  }

  /*用户总借书数,包括已还和未还的*/
  public int getNumBorrowBook()
  {
    String sql = "select count(*) Sum from BorrowRecord where UserID='"+UserID+"'";
    //System.out.println(sql+"---");
    try
    {
      rs = stm.executeQuery(sql);
      //System.out.println("b");
      //sum = Integer.parseInt();
      if(rs.absolute(1))
      {
        //System.out.println(rs.getString("Sum"));
        //System.out.println(String.valueOf(rs.getInt("bll")));
        sum = Integer.parseInt(rs.getString("Sum"));
      }
      //System.out.println(rs.getInt("Sum"));
      //System.out.println("a");
    }
    catch(Exception ex)
    {
      return 0;
      //System.out.println(ex.getMessage());
    }
    return sum;
  }
  /*得到借书历史记录*/
  public Vector getReturnedBook()
  {
    Vector v = new Vector();
    String sql = "select BookName,BorrowRecord.BookIndex,Summary,OutDay,InDay"
        +" from BorrowRecord,Book,BookInf where BorrowRecord.BookIndex=Book.BookIndex"
       +" and Book.ISBN=BookInf.ISBN and BorrowRecord.UserID='"+UserID+"' and event=1";
    try
    {
      //System.out.println(sql);
      rs = stm.executeQuery(sql);
      while(rs.next())
      {
        BorrowRecord br = new BorrowRecord();
        br.setBookName(rs.getString("BookName"));
        //System.out.println("a");
        br.setBookIndex(rs.getString("BookIndex"));
        //System.out.println("b");
        br.setSummary(rs.getString("Summary"));
        //System.out.println("c");
        br.setOutDay(rs.getString("OutDay").substring(0,10));
        //System.out.println("d");
        br.setInDay(rs.getString("InDay").substring(0,10));
        //System.out.println("e");
        //System.out.println("test-add");
        v.addElement(br);
      }
      //System.out.println("test");
    }
    catch(Exception ex)
    {
      System.out.println(ex.getMessage());
      return null;
    }
    return v;
  }
  /*借阅书籍。。。未还*/
  public Vector getBorrowingBook()
  {
    Vector v = new Vector();
    String sql = "select BookName,BorrowRecord.BookIndex,Summary,OutDay,BackDay"
        +" from BorrowRecord,Book,BookInf where BorrowRecord.BookIndex=Book.BookIndex"
       +" and Book.ISBN=BookInf.ISBN and BorrowRecord.UserID='"+UserID+"' and event=0";
    try
    {
      //System.out.println(sql);
      rs = stm.executeQuery(sql);
      while(rs.next())
      {
        BorrowRecord br = new BorrowRecord();
        br.setBookName(rs.getString("BookName"));
        br.setBookIndex(rs.getString("BookIndex"));
        br.setSummary(rs.getString("Summary"));
        br.setOutDay(rs.getString("OutDay").substring(0,10));
        br.setBackDay(rs.getString("BackDay").substring(0,10));

        v.addElement(br);
      }
      //System.out.println("test");
    }
    catch(Exception ex)
    {
      System.out.println(ex.getMessage());
      return null;
    }
    return v;
  }
  /*test*/
  public static void main(String[] args)
  {
    BorrowTableOperation bt =new BorrowTableOperation();
    bt.setUserID("33060423");
    bt.getReturnedBook().firstElement().toString();
  }

}