admin.java

用Java WEB写的图书管理系统

package book;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class Admin {

	private ArrayList<Book> books = new ArrayList<Book>();

	public Admin() {
		getAllBook();
	}

	public ArrayList<Book> getBooks() {
		return books;
	}

	public void setBooks(ArrayList<Book> books) {
		this.books = books;
	}

	public static Book getBookInfo(String bookId) {
		String sql = "SELECT * FROM book WHERE id=" + bookId;
		ResultSet rs = DbConnect.query(sql);
		Book aBook = new Book();
		try {
			while (rs.next()) {
				aBook.setBookId(rs.getString("id"));
				aBook.setBookName(rs.getString("book_name"));
				aBook.setPublish(rs.getString("publish"));
				aBook.setAuthor(rs.getString("author"));
				aBook.setISBN(rs.getString("ISBN"));
				aBook.setDianSort(rs.getString("Dian_sort"));
				aBook.setStandardSort(rs.getString("standard_sort"));
				aBook.setPrice(rs.getFloat("price"));
				aBook.setCheckInTime(rs.getDate("checkin_time"));
				aBook.setIntroduce(rs.getString("introduce"));
				aBook.setRemark(rs.getString("remark"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return aBook;
	}

	private void getAllBook() {
		String sqlOne = "SELECT book.*,borrow_time,return_time FROM book,borrow,user "
				+ "WHERE book.id = bookid AND"
				+ " user.id = borrowid "
				+ "AND book.Id NOT IN(SELECT book.Id FROM book,booking,user "
				+ "WHERE book.id = bookid AND user.id = bookingid)";

		ResultSet rs = DbConnect.query(sqlOne);

		try {
			while (rs.next()) {
				Book aBook = new Book();
				aBook.setBookId(rs.getString("id"));
				aBook.setBookName(rs.getString("book_name"));
				aBook.setPublish(rs.getString("publish"));
				aBook.setAuthor(rs.getString("author"));
				aBook.setISBN(rs.getString("ISBN"));
				aBook.setDianSort(rs.getString("Dian_sort"));
				aBook.setStandardSort(rs.getString("standard_sort"));
				aBook.setPrice(rs.getFloat("price"));
				aBook.setCheckInTime(rs.getDate("checkin_time"));
				aBook.setIntroduce(rs.getString("introduce"));
				aBook.setRemark(rs.getString("remark"));
				aBook.setBorrowTime(rs.getDate("borrow_time"));
				aBook.setReturnTime(rs.getDate("return_time"));
				// 处于借阅状态
				aBook.setState(1);
				books.add(aBook);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		String sqlTwo = "SELECT book.*,booking_time FROM book,booking,user WHERE book.id = bookid AND"
				+ " user.id = bookingid";

		rs = DbConnect.query(sqlTwo);

		try {
			while (rs.next()) {
				Book aBook = new Book();
				aBook.setBookId(rs.getString("id"));
				aBook.setBookName(rs.getString("book_name"));
				aBook.setPublish(rs.getString("publish"));
				aBook.setAuthor(rs.getString("author"));
				aBook.setISBN(rs.getString("ISBN"));
				aBook.setDianSort(rs.getString("Dian_sort"));
				aBook.setStandardSort(rs.getString("standard_sort"));
				aBook.setPrice(rs.getFloat("price"));
				aBook.setCheckInTime(rs.getDate("checkin_time"));
				aBook.setIntroduce(rs.getString("introduce"));
				aBook.setRemark(rs.getString("remark"));
				aBook.setBookingTime(rs.getDate("booking_time"));
				// 处于预约状态
				aBook.setState(2);
				books.add(aBook);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		String sqlThree = "SELECT book.* FROM book WHERE book.Id NOT IN(SELECT book.id FROM book,borrow,user "
				+ "WHERE book.id = bookid AND user.id = borrowid) AND book.Id NOT IN(SELECT book.Id FROM book,booking,user "
				+ "WHERE book.id = bookid AND user.id = bookingid)";

		rs = DbConnect.query(sqlThree);

		try {
			while (rs.next()) {
				Book aBook = new Book();
				aBook.setBookId(rs.getString("id"));
				aBook.setBookName(rs.getString("book_name"));
				aBook.setPublish(rs.getString("publish"));
				aBook.setAuthor(rs.getString("author"));
				aBook.setISBN(rs.getString("ISBN"));
				aBook.setDianSort(rs.getString("Dian_sort"));
				aBook.setStandardSort(rs.getString("standard_sort"));
				aBook.setPrice(rs.getFloat("price"));
				aBook.setCheckInTime(rs.getDate("checkin_time"));
				aBook.setIntroduce(rs.getString("introduce"));
				aBook.setRemark(rs.getString("remark"));
				// 处于书架上
				aBook.setState(0);
				books.add(aBook);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}