package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?entity.BookBean;
import?entity.OrderBean;

public?class?BookBeanDao?extends?ConnectionManager?{
	Connection?conn?=?null;
	PreparedStatement?pstmt?=?null;
	ResultSet?rs?=?null;
	String?sql?=null;	
	//訂單id
	int?orderid?=?0;
	/**
	?*?得到集合
	?*?
	?*?@return
	?*/
	public?List?getStoreList（）?{
		List?list?=?new?ArrayList（）;
		sql?=?“select?*?from?titles?“;
		try?{
			conn?=?getConn（）;
			pstmt?=?conn.prepareStatement（sql）;
			rs?=?pstmt.executeQuery（）;
			while?（rs.next（））?{
				BookBean?bookBean?=?new?BookBean（）;
				bookBean.setIsbn（rs.getString（“isbn“））;
				bookBean.settitle（rs.getString（“title“））;
				bookBean.setEditionNumber（rs.getInt（“editionNumber“））;
				bookBean.setCopyright（rs.getString（“copyright“））;
				bookBean.setPublisherID（rs.getInt（“publisherID“））;
				bookBean.setImageFile（rs.getString（“imageFile“））;
				bookBean.setPrice（rs.getDouble（“price“））;
				list.add（bookBean）;
			}
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			closeAll（conn?pstmt?rs）;
		}

		return?list;

	}

	/**
	?*?根據(jù)sibn得到信息
	?*?
	?*?@param?sibn
	?*?@return
	?*/
	public?BookBean?getStoreBySibn（String?isbn）?{
		BookBean?bookBean?=?new?BookBean（）;
		sql?=?“select?*?from?titles?where?isbn=“?+?isbn;
		try?{
			conn?=?getConn（）;
			pstmt?=?conn.prepareStatement（sql）;
			rs?=?pstmt.executeQuery（）;
			if?（rs.next（））?{

				bookBean.setIsbn（rs.getString（“isbn“））;
				bookBean.settitle（rs.getString（“title“））;
				bookBean.setEditionNumber（rs.getInt（“editionNumber“））;
				bookBean.setCopyright（rs.getString（“copyright“））;
				bookBean.setPublisherID（rs.getInt（“publisherID“））;
				bookBean.setImageFile（rs.getString（“imageFile“））;
				bookBean.setPrice（rs.getDouble（“price“））;
			}
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			closeAll（conn?pstmt?rs）;
		}

		return?bookBean;

	}
	
	/**
	?*?添加訂單
	?*?@param?orderBean
	?*?@param?book
	?*?@return
	?*/
	public?int?addOrder（OrderBean?orderBeanString?bookdouble?price）?{			
		sql=“insert?into?BookOrder（usernamezipcodephonecreditcardaddress）?values（?????）“;
		try?{
			conn?=?getConn（）;
			//?手動(dòng)提交
			conn.setAutoCommit（false）;
			pstmt?=?conn.prepareStatement（sqlStatement.RETURN_GENERATED_KEYS）;
			pstmt.setString（1?orderBean.getUsername（））;
			pstmt.setString（2?orderBean.getZipcode（））;
			pstmt.setString（3?orderBean.getPhone（））;
			pstmt.setString（4?or

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????432??2009-08-20?19:10??網(wǎng)上書店系統(tǒng)\Store\.classpath

?????文件????????288??2009-08-28?10:48??網(wǎng)上書店系統(tǒng)\Store\.mymetadata

?????文件???????1223??2009-08-20?19:10??網(wǎng)上書店系統(tǒng)\Store\.project

?????文件????2293760??2009-09-03?09:56??網(wǎng)上書店系統(tǒng)\Store\bookDB\books.mdf

?????文件??????10710??2007-10-24?16:26??網(wǎng)上書店系統(tǒng)\Store\bookDB\books.sql

?????文件?????573440??2009-09-03?09:56??網(wǎng)上書店系統(tǒng)\Store\bookDB\books_log.LDF

?????文件???????4121??2009-09-02?17:09??網(wǎng)上書店系統(tǒng)\Store\src\dao\BookBeanDao.java

?????文件???????2158??2009-08-26?19:11??網(wǎng)上書店系統(tǒng)\Store\src\dao\ConnectionManager.java

?????文件????????944??2009-08-21?12:08??網(wǎng)上書店系統(tǒng)\Store\src\dao\UserDao.java

?????文件???????1658??2009-08-21?17:01??網(wǎng)上書店系統(tǒng)\Store\src\entity\BookBean.java

?????文件????????589??2009-08-21?16:17??網(wǎng)上書店系統(tǒng)\Store\src\entity\CartItemBean.java

?????文件???????1290??2009-09-02?16:42??網(wǎng)上書店系統(tǒng)\Store\src\entity\OrderBean.java

?????文件????????742??2009-08-21?12:02??網(wǎng)上書店系統(tǒng)\Store\src\entity\User.java

?????文件???????1675??2009-09-03?08:43??網(wǎng)上書店系統(tǒng)\Store\src\servlet\AddBookToCart.java

?????文件???????2493??2009-09-01?12:32??網(wǎng)上書店系統(tǒng)\Store\src\servlet\ChangeNum.java

?????文件???????1762??2009-09-02?21:52??網(wǎng)上書店系統(tǒng)\Store\src\servlet\DeleteBook.java

?????文件???????1987??2009-09-02?21:20??網(wǎng)上書店系統(tǒng)\Store\src\servlet\HelloServlet.java

?????文件???????2678??2009-09-02?17:20??網(wǎng)上書店系統(tǒng)\Store\src\servlet\SaveOrder.java

?????文件???????1220??2009-09-03?09:49??網(wǎng)上書店系統(tǒng)\Store\src\servlet\ValidateLogin.java

?????文件???????2455??2005-07-12?10:48??網(wǎng)上書店系統(tǒng)\Store\WebRoot\css\main.css

?????文件??????19111??2007-06-07?15:38??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\advjhtp1.jpg

?????文件???????1940??2005-07-12?10:40??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bg.jpg

?????文件???????6521??2005-07-12?10:40??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bk.gif

?????文件??????39707??2007-08-31?10:44??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bn01.jpg

?????文件??????50076??2007-07-27?11:13??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bn01~.gif

?????文件??????50076??2007-07-27?11:13??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bn01~.jpg

?????文件?????????92??2005-07-12?10:40??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\bnbg1.gif

?????文件??????11415??2007-06-07?15:38??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\chtp2.jpg

?????文件??????17519??2007-06-07?15:38??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\chtp3.jpg

?????文件???????8561??2007-06-07?15:38??網(wǎng)上書店系統(tǒng)\Store\WebRoot\images\cppctc3.jpg

............此處省略82個(gè)文件信息