package?bookshop;

import?java.sql.*;
import?bookshop.*;

public?class?Book{
	protected?String?isbn;		//書的ISBN編號
	protected?String?title;		//書名
	protected?float?price;		//價格
	protected?int?buynum;		//購買數量
	
	public?Book（String?_isbn?int?_buynum）?{
		try
		{
			DBSQLManager?dbsm?=?new?DBSQLManager（）;
?			String?sql=“SELECT?ISBNtitlePRICE?FROM?bookinfo?WHERE?ISBN=‘“+_isbn+“‘“;
?			dbsm.setSqlStr（sql）;
			dbsm.executeQuery（）;
			ResultSet?rs?=??dbsm.getRs（）;
			rs.next（）;
			isbn?=?_isbn;
			title?=?rs.getString（“title“）;
			price?=?rs.getFloat（“PRICE“）;
			buynum?=?_buynum;
			dbsm.close（）;
		}
		catch?（Exception?e）?{
			System.out.println（e.toString（））;
		}
		
	}
	
	public?void?setIsbn（String?newIsbn）?{
	????????this.isbn?=?newIsbn;
	????	}
	????	
	public?String?getIsbn（）?{
		return?isbn;
	}

	public?void?settitle（String?newtitle）?{
	????????this.title?=?newtitle;
	????	}
	????	
	public?String?gettitle（）?{
		return?title;
	}

	public?void?setPrice（float?newPrice）?{
	????????this.price?=?newPrice;
	????	}
	????	
	public?float?getPrice（）?{
		return?price;
	}

	public?void?setBuynum（int?newBuynum）?{
	????????this.buynum?=?newBuynum;
	????	}
	????	
	public?int?getBuynum（）?{
		return?buynum;
	}
};

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

?????文件????????189??2011-01-01?12:39??網上書店\說明.txt

?????文件????????340??2010-12-20?23:19??網上書店\yy\.classpath

?????文件????????279??2010-12-26?22:57??網上書店\yy\.mymetadata

?????文件???????1408??2010-12-21?11:30??網上書店\yy\.project

?????文件???????1219??2010-12-20?23:19??網上書店\yy\WebRoot\adduser.jsp

?????文件???????2519??2010-12-21?14:04??網上書店\yy\WebRoot\bookdetail.jsp

?????文件???????1536??2010-12-21?14:04??網上書店\yy\WebRoot\booklist.jsp

?????文件????????990??2010-12-20?23:19??網上書店\yy\WebRoot\buybook.jsp

?????文件???????1796??2010-12-21?14:06??網上書店\yy\WebRoot\checkout.jsp

?????文件????????820??2010-12-20?23:19??網上書店\yy\WebRoot\chklogin.jsp

?????文件???????5090??2010-12-21?14:47??網上書店\yy\WebRoot\index.jsp

?????文件???????2563??2010-12-21?14:05??網上書店\yy\WebRoot\login.jsp

?????文件???????2981??2010-12-21?14:06??網上書店\yy\WebRoot\modifyuserinfo.jsp

?????文件???????2143??2010-12-21?10:20??網上書店\yy\WebRoot\myshop.jsp

?????文件???????1846??2010-12-21?14:06??網上書店\yy\WebRoot\orderitem.jsp

?????文件???????3429??2010-12-21?10:22??網上書店\yy\WebRoot\register.jsp

?????文件???????1232??2010-12-26?22:20??網上書店\yy\WebRoot\saveuser.jsp

?????文件???????1974??2010-12-26?22:19??網上書店\yy\WebRoot\search.jsp

?????文件???????1725??2010-12-21?14:05??網上書店\yy\WebRoot\shopcar.jsp

?????文件????????615??2010-12-26?22:17??網上書店\yy\WebRoot\sousuo.jsp

?????文件???????1865??2010-12-21?14:06??網上書店\yy\WebRoot\userinfo.jsp

?????文件????????375??2010-12-20?23:19??網上書店\yy\WebRoot\WEB-INF\web.xml

?????文件?????301290??2010-12-20?23:19??網上書店\yy\WebRoot\WEB-INF\lib\msbase.jar

?????文件??????69118??2010-12-20?23:19??網上書店\yy\WebRoot\WEB-INF\lib\mssqlserver.jar

?????文件??????64039??2010-12-20?23:19??網上書店\yy\WebRoot\WEB-INF\lib\msutil.jar

?????文件???????2156??2010-12-26?22:57??網上書店\yy\WebRoot\WEB-INF\classes\bookshop\Book.class

?????文件???????1803??2010-12-26?22:57??網上書店\yy\WebRoot\WEB-INF\classes\bookshop\DBConnectionManager.class

?????文件???????1953??2010-12-26?22:57??網上書店\yy\WebRoot\WEB-INF\classes\bookshop\DBSQLManager.class

?????文件?????????39??2010-12-20?23:19??網上書店\yy\WebRoot\meta-INF\MANIFEST.MF

?????文件????????154??2010-12-20?23:19??網上書店\yy\WebRoot\incoming\check.jsp

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