package?cn.ncut.dao;

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

import?cn.ncut.domain.Book;
import?cn.ncut.utils.JdbcUtils;

public?class?BookDao?{
	
	Connection?conn?=?null;
	PreparedStatement?ps?=?null;
	ResultSet?rs?=?null;
	
	//分頁查詢所有學(xué)生信息
		public?List?getBooks（）?{
			List?list?=?new?ArrayList（）;
			try?{
				conn?=?JdbcUtils.getConnection（）;
				String?sql?=?“select?*?from?books“;
				ps?=?conn.prepareStatement（sql）;
				rs?=?ps.executeQuery（）;
				while（rs.next（））{
					Book?book?=?new?Book（）;
					book.setId（rs.getInt（“id“））;
					book.settitle（rs.getString（“title“））;
					book.setAuthor（rs.getString（“author“））;
					book.setPrice（rs.getFloat（“price“））;
					book.setDescription（rs.getString（“description“））;
					book.setYr（rs.getString（“yr“））;
					book.setSale_amount（rs.getInt（“sale_amount“））;
					list.add（book）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
			return?list;
		}

		public?Book?find（int?id）?{
			try?{
				conn?=?JdbcUtils.getConnection（）;
				String?sql?=?“select?*?from?books?where?id=‘“+id+“‘“;
				ps?=?conn.prepareStatement（sql）;
				rs?=?ps.executeQuery（）;
				while（rs.next（））{
					Book?book?=?new?Book（）;
					book.setId（rs.getInt（“id“））;
					book.settitle（rs.getString（“title“））;
					book.setAuthor（rs.getString（“author“））;
					book.setPrice（rs.getFloat（“price“））;
					book.setDescription（rs.getString（“description“））;
					book.setYr（rs.getString（“yr“））;
					book.setSale_amount（rs.getInt（“sale_amount“））;
					return?book;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
			return?null;
		}
		
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-11-29?13:43??mvc_user\
?????文件?????????607??2015-11-29?14:42??mvc_user\.classpath
?????目錄???????????0??2015-11-29?13:43??mvc_user\.myeclipse\
?????文件?????????297??2015-11-29?13:43??mvc_user\.mymetadata
?????文件????????1751??2015-12-02?15:58??mvc_user\.project
?????目錄???????????0??2015-12-02?17:57??mvc_user\.settings\
?????文件?????????500??2015-11-29?13:43??mvc_user\.settings\.jsdtscope
?????文件??????????72??2015-12-03?12:55??mvc_user\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2015-11-29?13:43??mvc_user\.settings\org.eclipse.jdt.core.prefs
?????文件?????????462??2015-11-29?13:43??mvc_user\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-11-29?13:43??mvc_user\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-11-29?13:43??mvc_user\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-11-29?13:43??mvc_user\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-11-30?16:01??mvc_user\src\
?????目錄???????????0??2015-11-29?14:07??mvc_user\src\cn\
?????目錄???????????0??2015-12-02?17:03??mvc_user\src\cn\ncut\
?????目錄???????????0??2015-12-02?21:34??mvc_user\src\cn\ncut\dao\
?????文件????????1813??2015-12-03?16:36??mvc_user\src\cn\ncut\dao\BookDao.java
?????文件????????2154??2015-12-03?11:14??mvc_user\src\cn\ncut\dao\UserDao.java
?????目錄???????????0??2015-12-03?16:07??mvc_user\src\cn\ncut\domain\
?????文件????????1058??2015-12-02?21:31??mvc_user\src\cn\ncut\domain\Book.java
?????文件?????????981??2015-12-03?16:23??mvc_user\src\cn\ncut\domain\Cart.java
?????文件?????????557??2015-12-03?16:18??mvc_user\src\cn\ncut\domain\CartItem.java
?????文件????????1009??2015-12-02?15:24??mvc_user\src\cn\ncut\domain\User.java
?????目錄???????????0??2015-11-29?16:24??mvc_user\src\cn\ncut\exception\
?????文件?????????362??2015-11-29?16:24??mvc_user\src\cn\ncut\exception\UserExistException.java
?????目錄???????????0??2015-11-29?16:38??mvc_user\src\cn\ncut\junit\
?????文件?????????635??2015-12-02?15:31??mvc_user\src\cn\ncut\junit\daoTest.java
?????文件?????????762??2015-12-03?09:54??mvc_user\src\cn\ncut\junit\ServiceTest.java
?????目錄???????????0??2015-12-02?21:51??mvc_user\src\cn\ncut\service\
?????文件?????????711??2015-12-03?21:56??mvc_user\src\cn\ncut\service\BookService.java
............此處省略75個文件信息