user.java

用Java WEB写的图书管理系统

package book;

import java.util.ArrayList;
import java.sql.*;

public class User {
	private String userName = "";
	private String trueName = "";
	private ArrayList<Book> books = new ArrayList<Book>();

	public User(String userName) {
		this.userName = userName;
		getTrueNameFromDb();
		getBooksFromDb();
	}

	private void getTrueNameFromDb() {
		String sql = "SELECT truename FROM personalinfo,user WHERE user.id = userid AND username = '"
				+ userName + "'";

		ResultSet rs = DbConnect.query(sql);

		try {
			while (rs.next()) {
				trueName = rs.getString("truename");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	private void getBooksFromDb() {
		String sqlOne = "SELECT book.*,borrow_time,return_time FROM book,borrow,user "
				+ "WHERE book.id = bookid AND"
				+ " user.id = borrowid AND username = '" + userName + "'";

		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 AND username = '" + userName + "'";

		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();
		}

	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

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

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

	public String getTrueName() {
		return trueName;
	}

	public void setTrueName(String trueName) {
		this.trueName = trueName;
	}

}