package?com.haiersoft.db;

import?com.haiersoft.entity.Book;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.*;

public?class?BookDao?extends?DBOper?{
	//?返回所有圖書(shū)列表
	public?List?getAllBook（）?{
		List?bookList?=?new?ArrayList（）;
		String?sql?=?“SELECT?*?FROM?books“;
		try?{
			ResultSet?rs?=?this.executeQuery（sql?null）;
			while?（rs.next（））?{
				Book?book?=?new?Book（）;
				book.setIsbn（rs.getString（“isbn“））;
				book.setBookName（rs.getString（“bookName“））;
				book.setPublisherID（rs.getInt（“publisherID“））;
				book.setPrice（rs.getDouble（“price“））;
				book.setCount（rs.getInt（“count“））;
				book.setPic（rs.getString（“pic“））;
				book.setDescription（rs.getString（“description“））;
				bookList.add（book）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			this.closeAll（）;
		}

		return?bookList;
	}

	//?根據(jù)ISBN查找一本圖書(shū)
	public?Book?getBookByIsbn（String?isbn）?{
		Book?book?=?null;
		String?sql?=?“SELECT?*?FROM?books?WHERE?isbn=?“;
		try?{
			ResultSet?rs?=?this.executeQuery（sql?new?String[]?{?isbn?}）;
			if?（rs.next（））?{
				book?=?new?Book（）;
				book.setIsbn（rs.getString（“isbn“））;
				book.setBookName（rs.getString（“bookName“））;
				book.setPublisherID（rs.getInt（“publisherID“））;
				book.setPrice（rs.getDouble（“price“））;
				book.setCount（rs.getInt（“count“））;
				book.setPic（rs.getString（“pic“））;
				book.setDescription（rs.getString（“description“））;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			this.closeAll（）;
		}
		return?book;
	}

	//?根據(jù)書(shū)名查找圖書(shū)列表
	public?List?getBookByName（String?name）?{
		List?bookList?=?new?ArrayList（）;
		String?sql?=?“SELECT?*?FROM?books?WHERE?bookName?LIKE?‘%“?+?name?+?“%‘“;
		try?{
			ResultSet?rs?=?this.executeQuery（sql?null）;
			while?（rs.next（））?{
				Book?book?=?new?Book（）;
				book.setIsbn（rs.getString（“isbn“））;
				book.setBookName（rs.getString（“bookName“））;
				book.setPublisherID（rs.getInt（“publisherID“））;
				book.setPrice（rs.getDouble（“price“））;
				book.setCount（rs.getInt（“count“））;
				book.setPic（rs.getString（“pic“））;
				book.setDescription（rs.getString（“description“））;
				bookList.add（book）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			this.closeAll（）;
		}

		return?bookList;
	}

	//?根據(jù)出版社ID查找圖書(shū)列表
	public?List?getBookByPublisher（int?pid）?{
		List?bookList?=?new?ArrayList（）;
		String?sql?=?“SELECT?*?FROM?books?WHERE?publisherID=“?+?pid;
		try?{
			ResultSet?rs?=?this.executeQuery（sql?null）;
			while?（rs.next（））?{
				Book?book?=?new?Book（）;
				book.setIsbn（rs.getString（“isbn“））;
				book.setBookName（rs.getString（“bookName“））;
				book.setPublisherID（rs.getInt（“publisherID“））;
				book.setPrice（rs.getDouble（“price“））;
				book.setCount（rs.getInt（“count“））;
				book.setPic（rs.getString（“pic“））;
				book.setDescription（rs.getString（“description“））;
				bookLi

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????8429??2010-11-29?17:16??haier.sql
?????目錄???????????0??2012-06-26?20:52??ph08\
?????文件?????????826??2010-10-21?16:38??ph08\.classpath
?????文件????????1037??2010-10-21?16:38??ph08\.project
?????目錄???????????0??2012-06-26?20:52??ph08\.settings\
?????文件?????????454??2010-10-21?16:38??ph08\.settings\.jsdtscope
?????文件?????????330??2010-10-21?16:38??ph08\.settings\org.eclipse.jdt.core.prefs
?????文件?????????414??2010-10-21?16:38??ph08\.settings\org.eclipse.wst.common.component
?????文件?????????308??2010-10-21?16:38??ph08\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2010-10-21?16:38??ph08\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2010-10-21?16:38??ph08\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-06-26?20:52??ph08\build\
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\db\
?????文件????????6224??2010-10-21?16:38??ph08\build\classes\com\haiersoft\db\BookDao.class
?????文件????????3798??2010-10-21?16:38??ph08\build\classes\com\haiersoft\db\DBOper.class
?????文件????????3797??2010-10-21?16:38??ph08\build\classes\com\haiersoft\db\UserDao.class
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\entity\
?????文件????????1712??2010-10-21?16:38??ph08\build\classes\com\haiersoft\entity\Book.class
?????文件????????1313??2010-10-21?16:38??ph08\build\classes\com\haiersoft\entity\User.class
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\filter\
?????文件????????2248??2010-10-21?16:38??ph08\build\classes\com\haiersoft\filter\CheckUserFilter.class
?????文件????????2063??2010-10-21?16:38??ph08\build\classes\com\haiersoft\filter\CompressFilter.class
?????文件????????1955??2010-10-21?16:38??ph08\build\classes\com\haiersoft\filter\CompressResponse.class
?????文件?????????778??2010-10-21?16:38??ph08\build\classes\com\haiersoft\filter\GzipServletOutputStream.class
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\listener\
?????文件????????2480??2010-10-21?16:38??ph08\build\classes\com\haiersoft\listener\ListenLognum.class
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\servlet\
?????目錄???????????0??2012-06-26?20:52??ph08\build\classes\com\haiersoft\servlet\admin\
............此處省略209個(gè)文件信息