newbook.java

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

package web;
import lms.*;
import java.sql.*;
import java.util.Vector;
import java.util.Date;
public class NewBook extends DataBase
{

  public NewBook()
  {
    super();
  }

  public Vector GetBookToday(Date today)
  {
    Vector v = new Vector();
    sqlstr = "select * from BookInf where ";
    sqlstr += "";
    try{
      rs = stm.executeQuery(sqlstr);
      while(rs.next())
      {
        Book book = new Book();
        String bn = rs.getString("BookName");
        String pr =rs.getString("Press");
        String wr =rs.getString("Writer");

        book.setBookName(bn);
        book.setPress(pr);
        book.setWriter(wr);
        v.addElement(book);
      }
    }catch(SQLException e)
    {
      System.out.println(e.getMessage());
    }
    return v;
  }
  /*
  public static void main(String[] args)
  {
    NewBook nb = new NewBook();
    nb.GetBookToday(new Date());
  }*/
}