package?dao;

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

import?util.DatabaseUtil;
import?vo.Book;

public?class?BookDao?{

	/**
	?*?獲取所有的教材信息列表
	?*?@return?教材對象Book列表
	?*/
	public?List?listBook（）?{
		List?list?=?new?Vector（）;
		Book?book?=?null;
		Connection?conn?=?null;
		PreparedStatement?pstmt?=?null;
		ResultSet?rs?=?null;
		DatabaseUtil?util?=?new?DatabaseUtil（）;
		try?{
			
			conn?=?util.getConnection（）;
			if?（conn?!=?null）?{
				String?sql?=?“select?*?from?t_book?order?by?id?desc?“;
				pstmt?=?conn.prepareStatement（sql）;
				rs?=?pstmt.executeQuery（）;
				while?（rs.next（））?{
					book?=?new?Book（）;
					

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-19?11:11??jwc\
?????文件????????1238??2017-12-17?20:48??jwc\.classpath
?????文件????????1328??2017-11-20?22:18??jwc\.project
?????目錄???????????0??2017-12-19?11:11??jwc\.settings\
?????文件?????????536??2017-12-17?20:48??jwc\.settings\.jsdtscope
?????文件?????????103??2017-11-14?15:38??jwc\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????189??2017-12-14?19:17??jwc\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-11-14?13:48??jwc\.settings\org.eclipse.jdt.core.prefs
?????文件??????????90??2017-11-20?22:14??jwc\.settings\org.eclipse.m2e.core.prefs
?????文件?????????448??2017-12-17?20:48??jwc\.settings\org.eclipse.wst.common.component
?????文件?????????163??2017-12-17?20:48??jwc\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????462??2017-12-17?20:48??jwc\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-11-14?13:48??jwc\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-11-14?13:48??jwc\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-12-19?11:11??jwc\src\
?????目錄???????????0??2017-12-19?11:11??jwc\src\dao\
?????文件????????4683??2017-12-05?14:56??jwc\src\dao\BookDao.java
?????文件????????9289??2017-12-17?20:24??jwc\src\dao\CourseDao.java
?????文件????????1379??2017-12-05?13:58??jwc\src\dao\NewsDao.java
?????文件????????1505??2017-12-09?15:08??jwc\src\dao\UserDao.java
?????目錄???????????0??2017-12-19?11:11??jwc\src\servlet\
?????文件????????2541??2017-12-05?14:20??jwc\src\servlet\BookDeleteServlet.java
?????文件????????2337??2017-12-05?14:37??jwc\src\servlet\BookEditServlet.java
?????文件????????2947??2017-12-05?15:04??jwc\src\servlet\BookSaveServlet.java
?????文件????????2084??2017-12-05?14:06??jwc\src\servlet\BookServlet.java
?????文件????????2686??2017-12-05?13:38??jwc\src\servlet\CheckLoginServlet.java
?????文件????????2580??2017-12-09?16:01??jwc\src\servlet\CourseDeleteServlet.java
?????文件????????2411??2017-12-09?15:13??jwc\src\servlet\CourseEditServlet.java
?????文件????????2713??2017-12-09?17:28??jwc\src\servlet\CourseSaveServlet.java
?????文件????????2880??2017-12-17?20:24??jwc\src\servlet\CourseServlet.java
?????文件????????2086??2017-11-28?15:04??jwc\src\servlet\IndexServlet.java
............此處省略94個文件信息