/*  *setBookISBN():設置圖書的編號，同時根據編號更新相應的書名、作者、出版社、價格*和簡介
 *getBookList()— 取得書庫中全部書的書名、出版社、價格、作者等信息；
 *getBookISBN()— 取得當前圖書的編號 ；
 *getBookName()—取得當前圖書的書名；
 *getBookAuthor()—取得當前圖書的作者；
 *getPublisher()—取得當前圖書的出版社信息；
 *getPrice()—取得當前圖書的價格；
 *getIntroduce（）取得當前圖書的簡介信息。
 *main()方法用于將BEAN作為一個 Application進行測試時使用，正式發布時可以刪除。
 **/

package wdm;

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

public class BookBean {
	private String bookISBN = null; // 圖書編號

	private String bookName = null; // 書名

	private String bookAuthor = null; // 作者

	private String publisher = null; // 出版社

	private String introduce = null; // 簡介

	private String price = null; // 價格

	private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";

	private static String strDBUrl = "jdbc:odbc:bookstore";

	private Connection conn = null;

	private ResultSet rs = null;

	public BookBean() {
		// 加載驅動
		try {
			Class.forName(strDBDriver);
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println("BookBean ():" + e.getMessage());
			System.err.println(11);
		}
	}

	// 取當前書庫中全部圖書信息
	public ResultSet getBookList() {
		String strSql = null;
		try {
			// 建立與數據庫的連接
			conn = DriverManager.getConnection(strDBUrl);
			Statement stmt = conn.createStatement();
			strSql = "Select bookISBN,bookName,bookAuthor,publisher,price from bookInfo ";
			rs = stmt.executeQuery(strSql);
		}
		// 捕獲異常
		catch (SQLException e) {
			System.err.println("BookBean.getBookList():" + e.getMessage());
		}
		return rs;
	}

	// 根據圖書的編號給圖書的其他信息賦值
	private void getBookInfo(String ISBN) {
		String strSql = null;
		bookName = null;
		bookAuthor = null;
		publisher = null;
		introduce = null;
		price = null;
		try {
			// 建立和數據庫的連接
			conn = DriverManager.getConnection(strDBUrl);
			Statement stmt = conn.createStatement();
			strSql = "Select * from bookInfo where bookISBN = '" + ISBN + "'";
			rs = stmt.executeQuery(strSql);
			while (rs.next()) {
				bookName = rs.getString("bookName");
				bookAuthor = rs.getString("bookAuthor");
				publisher = rs.getString("publisher");
				introduce = rs.getString("introduce");
				price = rs.getString("price");
			}
		}
		// 捕獲異常
		catch (SQLException e) {
			System.err.println("BookBean.getBookInfo():" + e.getMessage());
		}
	}

	// 給圖書的編號賦值，同時調用函數給圖書的其他信息賦值
	public void setBookISBN(String ISBN) {
		this.bookISBN = ISBN;
		getBookInfo(bookISBN);
	}

	// 取圖書編號
	public String getBookISBN() {
		return bookISBN;
	}

	// 取書名
	public String getBookName() {
		return bookName;
	}

	// 取作者信息
	public String getBookAuthor() {
		return bookAuthor;
	}

	// 取出版社信息
	public String getPublisher() {
		return publisher;
	}

	// 取圖書簡介
	public String getIntroduce() {
		return introduce;
	}

	// 取圖書價格
	public String getPrice() {
		return price;
	}

	/*
	 * 將Bean作為一個application進行測試用 public static void main(String args[]) {
	 * BookBean book = new BookBean(); book.setBookISBN("7-5053-5316-4");
	 * 
	 * System.out.println(book.getBookName());
	 * System.out.println(book.getBookAuthor());
	 * System.out.println(book.getPublisher());
	 * System.out.println(book.getIntroduce());
	 * System.out.println(book.getPrice()); try { ResultSet tmpRS =
	 * book.getBookList(); while (tmpRS.next()) {
	 * System.out.println(tmpRS.getString("bookname")); } tmpRS.close(); } //
	 * 捕獲異常 catch (Exception e) { System.err.println("main()" + e.getMessage()); } }
	 */
	public List getAllBook() {
		Statement stmt;
		String strSql = "";
		BookBean book = null;// new UserBean();
		List list = new ArrayList();
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "select * from bookInfo";
			// System.out.println(strSql);
			ResultSet rs = stmt.executeQuery(strSql);
			while (rs.next()) {
				book = new BookBean();
				book.setBookISBN(rs.getString("bookISBN"));
				book.setBookName(rs.getString("bookName"));
				book.setBookAuthor(rs.getString("bookAuthor"));
				book.setIntroduce(rs.getString("introduce"));
				book.setPrice(rs.getString("price"));
				book.setPublisher(rs.getString("publisher"));

				list.add(book);
			}

		} catch (Exception e) {
			System.out.println(e);
			// return false;
		}
		return list;
	}
	
	public void del(String bookISBN) {
		Statement stmt;
		String strSql = "";
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "delete from bookInfo where bookISBN='" + bookISBN + "'";
			stmt.executeUpdate(strSql);

		} catch (Exception e) {
			System.out.println(e);
			// return false;
		}
	}

	public void add(BookBean book){
		Statement stmt;
		String strSql = "";
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "insert into bookInfo values('"+book.getBookISBN()+
			"','"+book.getBookName()+
			"','"+book.getBookAuthor()+
			"','"+book.getPublisher()+
			"','"+book.getPrice()+
			"','"+book.getIntroduce()+"')";
			
			System.out.println(strSql);
			
			stmt.executeUpdate(strSql);

		} catch (Exception e) {
			System.out.println(e);
			// return false;
		}
	}

	public static String getStrDBDriver() {
		return strDBDriver;
	}

	public static void setStrDBDriver(String strDBDriver) {
		BookBean.strDBDriver = strDBDriver;
	}

	public static String getStrDBUrl() {
		return strDBUrl;
	}

	public static void setStrDBUrl(String strDBUrl) {
		BookBean.strDBUrl = strDBUrl;
	}

	public Connection getConn() {
		return conn;
	}

	public void setConn(Connection conn) {
		this.conn = conn;
	}

	public ResultSet getRs() {
		return rs;
	}

	public void setRs(ResultSet rs) {
		this.rs = rs;
	}

	public void setBookAuthor(String bookAuthor) {
		this.bookAuthor = bookAuthor;
	}

	public void setBookName(String bookName) {
		this.bookName = bookName;
	}

	public void setIntroduce(String introduce) {
		this.introduce = introduce;
	}

	public void setPrice(String price) {
		this.price = price;
	}

	public void setPublisher(String publisher) {
		this.publisher = publisher;
	}

}