/*?*BuyerBean.Java???1.10.2001?
*Copyright???2000?2001?by?cuug?llp.
*本Bean中的各個方法的功能介紹如下:
*setBookISBN（）:設置圖書的編號，同時根據編號更新相應的書名、作者、出版社、價格*和簡介
*getBookList（）—?取得書庫中全部書的書名、出版社、價格、作者等信息；
*getBookISBN（）—?取得當前圖書的編號?；
???	*getBookName（）—取得當前圖書的書名；
	*getBookAuthor（）—取得當前圖書的作者；
	*getPublisher（）—取得當前圖書的出版社信息；
	*getPrice（）—取得當前圖書的價格；
*?getIntroduce（）取得當前圖書的簡介信息。
	*main（）方法用于將BEAN作為一個?Application進行測試時使用，正式發布時可以刪除。
??	**/

package?cuug;

import?java.sql.*;
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（））;
		}	
	}
	//取當前書庫中全部圖書信息
	public?ResultSet?getBookList（）{
		String?strSql?=?null;
		try{
			//建立與數據庫的連接
			conn?=?DriverManager.getConnection（strDBUrl）;
			Statement?stmt?=?conn.createStatement（）;
			strSql?=?“Select?bookISBNbookNamebookAuthorpublisherprice?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.getBookList（）:“?+?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.set

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1608??2017-06-19?21:18??bookstore6\.classpath

?????文件???????1043??2017-06-19?00:26??bookstore6\.project

?????文件????????503??2017-06-19?00:26??bookstore6\.settings\.jsdtscope

?????文件????????236??2017-06-19?20:50??bookstore6\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-06-19?00:26??bookstore6\.settings\org.eclipse.jdt.core.prefs

?????文件????????482??2017-06-19?00:26??bookstore6\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-06-19?00:26??bookstore6\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-06-19?00:26??bookstore6\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-06-19?00:26??bookstore6\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4136??2017-06-20?10:09??bookstore6\src\cuug\BookBean.java

?????文件???????2901??2017-06-20?09:04??bookstore6\src\cuug\BuyerBean.java

?????文件???????5200??2017-06-20?10:09??bookstore6\src\cuug\OrderBean.java

?????文件???????1428??2017-06-20?10:27??bookstore6\WebContent\addcart.jsp

?????文件???????2454??2017-06-20?10:00??bookstore6\WebContent\bookinfo.jsp

?????文件???????2004??2017-06-20?09:45??bookstore6\WebContent\booklist.jsp

?????文件???????1085??2017-06-20?09:39??bookstore6\WebContent\Checklogon.jsp

?????文件????????590??2017-06-20?09:35??bookstore6\WebContent\default.html

?????文件????????624??2017-06-19?00:45??bookstore6\WebContent\delbook.jsp

?????文件????????647??2017-06-19?00:46??bookstore6\WebContent\emptycart.jsp

?????文件?????????39??2017-06-19?00:26??bookstore6\WebContent\meta-INF\MANIFEST.MF

?????文件???????4913??2017-06-20?09:50??bookstore6\WebContent\order.jsp

?????文件???????2178??2017-06-20?09:46??bookstore6\WebContent\shoppingcart.jsp

?????文件???????3950??2017-06-20?11:17??bookstore6\WebContent\WEB-INF\classes\cuug\BookBean.class

?????文件???????3169??2017-06-20?11:17??bookstore6\WebContent\WEB-INF\classes\cuug\BuyerBean.class

?????文件???????5544??2017-06-20?11:17??bookstore6\WebContent\WEB-INF\classes\cuug\OrderBean.class

?????文件????????715??2017-06-19?17:29??bookstore6\WebContent\WEB-INF\web.xml

?????目錄??????????0??2017-06-20?11:17??bookstore6\WebContent\WEB-INF\classes\cuug

?????目錄??????????0??2017-06-20?11:17??bookstore6\WebContent\WEB-INF\classes

?????目錄??????????0??2017-06-19?00:26??bookstore6\WebContent\WEB-INF\lib

?????目錄??????????0??2017-06-19?00:47??bookstore6\src\cuug

............此處省略12個文件信息