package?mypack;
import?java.sql.*;
import?java.util.*;
public?class?BookDB?
{
	int?totalPage;
	Connection?con?=?null;
	Statement?stat?=?null;
	PreparedStatement?pstat?=?null;
	ResultSet?rs?=?null;
	public?BookDB（）?throws?Exception?{
		Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
	}
	public?Connection?getCon（）?{
		String?driverName?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
		String?userName?=?“sa“;
		String?userPasswd?=?““;
		String?dbName?=?“BookDb“;

		String?conurl?=?“jdbc:odbc:“?+?dbName;
		try?{
			Class.forName（driverName）;
			con?=?DriverManager.getConnection（conurl?userName?userPasswd）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		System.out.println（“創(chuàng)建連接成功“）;
		return?con;
	}

	public?ResultSet?query（String?sql）?{
		try?{
			con?=?getCon（）;
			stat?=?con.createStatement（）;
			rs?=?stat.executeQuery（sql）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?rs;
	}
	public?ArrayList?getBooks（）?throws?SQLException
	{
		ArrayList?bl?=?new?ArrayList（）;
		rs?=?query（“select?*?from?books“）;
		while（rs.next（））
		{
			BookDetails?bd?=?new?BookDetails（rs.getString（“id“）
											rs.getString（“name“）rs.getString（“title“）
											rs.getFloat（“price“）rs.getInt（“yr“）
											rs.getString（“description“）rs.getInt（“saleAmount“））;
			bl.add（bd）;
		}
		return?bl;
	}
	public?ArrayList?getBooks（int?curPage?int?pageSize）?throws?SQLException
	{
		ArrayList?bl?=?getBooks（）;
		ArrayList?newBl=?new?ArrayList（）;
		for（int?i=0;i		{
			if（i>=curPage*pageSize&&i<（curPage+1）*pageSize）
			{
				newBl.add（bl.get（i））;
			}
		}
		totalPage=（int）Math.ceil（bl.size（）/pageSize）;
		return?newBl;
	}
	public?int?getTotalPage（）
	{
		return?totalPage;?
	}
	public?int?getNumberOfBooks（）
	{
		
		return?1;
	}
	public?BookDetails?getBookDetails（String?bookId）?throws?SQLException
	{
		BookDetails?book?=?null;
		rs?=?query（“select?*?from?books?where?id=“+bookId）;
		while（rs.next（））
		{
			book=?new?BookDetails（rs.getString（“id“）
											rs.getString（“name“）rs.getString（“title“）
											rs.getFloat（“price“）rs.getInt（“yr“）
											rs.getString（“description“）rs.getInt（“saleAmount“））;
		}
		return?book;
	}

	public?void?buyBooks（ShoppingCart?shoppingcart?）?throws?Exception
	{
		Connection?con?=?null;
		Collection?c?=?shoppingcart.getItems（）;
		Iterator?i?=?c.iterator（）;?
		?
		con?=?getCon（）;
		con.setAutoCommit（false）;
		while?（i.hasNext（））?{
			ShoppingCartItem?item?=?i.next（）;
			BookDetails?book?=item.getItem（）;
			String?id?=?book.getBookId（）;
			int?quantity?=?item.getQuantity（）;
			String?change?=?“update?books?set?saleamount?=?saleamount?+???where?id?=??“;
			PreparedStatement?prepStmt?=?con.prepareStatement（change）;
			prepStmt.setInt（1?quantity）;
			prepStmt.setString（2?id）;
			prepStmt.

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

?????文件??????21504??2008-06-29?12:47??網(wǎng)上書店\網(wǎng)上書店說明書.doc

?????文件????????945??2008-05-11?15:20??網(wǎng)上書店\book\bookdetails.jsp

?????文件????????548??2008-05-11?13:50??網(wǎng)上書店\book\bookstore.jsp

?????文件????????851??2008-05-11?15:21??網(wǎng)上書店\book\cashier.jsp

?????文件???????1933??2008-05-11?15:11??網(wǎng)上書店\book\catalog.jsp

?????文件????????263??2008-05-11?14:38??網(wǎng)上書店\book\common.jsp

?????文件????????683??2008-05-11?16:15??網(wǎng)上書店\book\deal.jsp

?????文件????????421??2008-05-11?13:49??網(wǎng)上書店\book\receipt.jsp

?????文件???????2101??2008-05-11?16:03??網(wǎng)上書店\book\showcart.jsp

?????文件????????296??2008-05-11?10:40??網(wǎng)上書店\book\WEB-INF\web.xml

?????文件????1001984??2008-05-10?10:07??網(wǎng)上書店\book\WEB-INF\database\BookDB

?????文件???????3335??2008-05-11?13:42??網(wǎng)上書店\book\WEB-INF\classes\BookDB.java

?????文件???????1329??2008-05-10?10:12??網(wǎng)上書店\book\WEB-INF\classes\BookDetails.java

?????文件???????1272??2008-05-11?16:24??網(wǎng)上書店\book\WEB-INF\classes\ShoppingCart.java

?????文件????????710??2008-05-11?15:30??網(wǎng)上書店\book\WEB-INF\classes\ShoppingCartItem.java

?????文件???????4399??2008-05-11?16:05??網(wǎng)上書店\book\WEB-INF\classes\mypack\BookDB.class

?????文件???????1238??2008-05-11?16:05??網(wǎng)上書店\book\WEB-INF\classes\mypack\BookDetails.class

?????文件???????2022??2008-05-11?16:05??網(wǎng)上書店\book\WEB-INF\classes\mypack\ShoppingCart.class

?????文件???????1052??2008-05-11?16:05??網(wǎng)上書店\book\WEB-INF\classes\mypack\ShoppingCartItem.class

?????文件???????1136??2008-05-10?14:40??網(wǎng)上書店\book\imag\book.jpg

?????文件???????4096??2008-05-10?21:09??網(wǎng)上書店\book\imag\Thumbs.db

?????文件????????139??2008-06-29?12:52??網(wǎng)上書店\readme.txt

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book\WEB-INF\classes\mypack

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book\WEB-INF\database

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book\WEB-INF\classes

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book\WEB-INF

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book\imag

?????目錄??????????0??2008-06-29?12:47??網(wǎng)上書店\book

?????目錄??????????0??2008-05-11?16:55??網(wǎng)上書店

-----------?---------??----------?-----??----

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