books.java~

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

package book;

import java.sql.*;
import java.util.Vector;
import database.*;
import book.bookInfo;
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 Books
    extends DataBase {
  private Vector bookList; //图书列表
  private javax.servlet.http.HttpServletRequest request; //建立页面请求

  public Vector getBookList() {
    return bookList;
  }

  public boolean getAllBook() throws Exception {
    try {
      rs = stmt.executeQuery("select * from Book");
      bookList = new Vector();
      while (rs.next()) {
        bookInfo bookinfo = new bookInfo();
        bookinfo.setBookSN(rs.getString(1));
        bookinfo.setBookName(rs.getString(2));
        bookinfo.setBookAuthor(rs.getString(3));
        bookinfo.setBookPress(rs.getString(4));
        bookinfo.setBookISBN(rs.getString(5));
        bookinfo.setBookClass(rs.getString(6));
        bookinfo.setBookLevel(rs.getString(7));
        bookinfo.setBookIn(rs.getString(8));
        bookinfo.setBookPrice(rs.getString(9));
        bookinfo.setBookComment(rs.getString(10));
        bookList.addElement(bookinfo);
      }
      rs.close();
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }
  }

  public boolean getOneBook(String newBookSN) throws Exception {
    rs = stmt.executeQuery("select * from Book where 图书编号 = '" + newBookSN +
                           "'");
    if (rs.next()) {
      bookList = new Vector();
      bookInfo bookinfo = new bookInfo();
      bookinfo.setBookSN(rs.getString(1));
      bookinfo.setBookName(rs.getString(2));
      bookinfo.setBookAuthor(rs.getString(3));
      bookinfo.setBookPress(rs.getString(4));
      bookinfo.setBookISBN(rs.getString(5));
      bookinfo.setBookClass(rs.getString(6));
      bookinfo.setBookLevel(rs.getString(7));
      bookinfo.setBookIn(rs.getString(8));
      bookinfo.setBookPrice(rs.getString(9));
      bookinfo.setBookComment(rs.getString(10));
      bookList.addElement(bookinfo);
    }
    else {
      rs.close();
      return false;
    }
    rs.close();
    return true;
  }

  public boolean searchBook(HttpServletRequest res) throws
      Exception {
    request = res;
    /*
         String newBookSN = request.getParameter("bookSN");
         String newBookName = request.getParameter("bookName");
         String newBookAuthor = request.getParameter("bookAuthor");
         String newBookPress = request.getParameter("bookPress");
     */
    String bookName = request.getParameter("bookName");
    String bookAuthor = request.getParameter("bookAuthor");
    String bookPress = request.getParameter("bookPress");
    String bookISBN = request.getParameter("bookISBN");
    String bookClass = request.getParameter("bookClass");
    String bookSN = request.getParameter("bookSN");

    bookSN = new String(bookSN.getBytes("ISO-8859-1"), "GBK");
    bookName = new String(bookName.getBytes("ISO-8859-1"), "GBK");
    bookAuthor = new String(bookAuthor.getBytes("ISO-8859-1"), "GBK");
    bookPress = new String(bookPress.getBytes("ISO-8859-1"), "GBK");
    bookISBN= new String(bookISBN.getBytes("ISO-8859-1"), "GBK");
    bookClass= new String(bookClass.getBytes("ISO-8859-1"), "GBK");

    String searchSql = "select * from Book where 图书编号 like '%" + bookSN +
        "%'";

    if (!bookName.equals("")) {
      searchSql = searchSql + " and 书名 like '%" + bookName + "%'";
    }
    if (!bookAuthor.equals("")) {
      searchSql = searchSql + " and 作者 like '%" + bookAuthor + "%'";
    }
    if (!bookPress.equals("")) {
      searchSql = searchSql + " and 出版社 like '%" + bookPress + "%'";
    }

    if (!bookISBN.equals("")) {
      searchSql = searchSql + " and ISBN like '%" + bookISBN + "%'";
    }

    if (!bookClass.equals("")) {
      searchSql = searchSql + " and 分类 like '%" + bookClass + "%'";
    }



    try {
      rs = stmt.executeQuery(searchSql);
      bookList = new Vector();
      while (rs.next()) {
        bookInfo bookinfo = new bookInfo();
        bookinfo.setBookSN(rs.getString(1));
        bookinfo.setBookName(rs.getString(2));
        bookinfo.setBookAuthor(rs.getString(3));
        bookinfo.setBookPress(rs.getString(4));
        bookinfo.setBookISBN(rs.getString(5));
        bookinfo.setBookClass(rs.getString(6));
        bookinfo.setBookLevel(rs.getString(7));
        bookinfo.setBookIn(rs.getString(8));
        bookinfo.setBookPrice(rs.getString(9));
        bookinfo.setBookComment(searchSql);
        bookList.addElement(bookinfo);
      }
      rs.close();
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }

  }
}