package?com.svse.dao;

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

import?com.svse.db.DBConnection;
import?com.svse.vo.BookInfo;

public?class?BookInfoDao?{

	//?定義Connection對象
	private?Connection?conn?=?null;
	//?定義?PreparedStatement對象
	private?PreparedStatement?ps?=?null;
	//?定義ResultSet對象
	private?ResultSet?rs?=?null;

	/**
	?*?功能：查詢所有圖書對象，存放于List集合中
	?*?
	?*?@return
	?*/
	public?List?findAll（）?{
		//?定義List集合對象
		List?list?=?new?ArrayList（）;
		//?定義sql語句
		String?sql?=?“select?*?from?book“;
		try?{
			//?獲得數據庫連接對象
			conn?=?DBConnection.getConnection（）;
			//?執行sql語句
			ps?=?conn.prepareStatement（sql）;
			//?返回結果集
			rs?=?ps.executeQuery（）;
			//?循環遍歷結果集
			while?（rs.next（））?{
				BookInfo?book?=?new?BookInfo（）;
				book.setBookId（rs.getInt（“bookId“））;
				book.setBookName（rs.getString（“bookName“））;
				book.setIsbn（rs.getString（“isbn“））;
				book.setAuthor（rs.getString（“author“））;
				book.setPrice（rs.getFloat（“price“））;
				book.setStock（rs.getInt（“stock“））;
				list.add（book）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			DBConnection.closeResultSet（rs）;?//?釋放資源
			DBConnection.closeStatement（ps）;
			DBConnection.closeConnection（conn）;
		}
		return?list;
	}
}

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

?????文件????????563??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\.classpath

?????文件????????300??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\.mymetadata

?????文件???????1415??2009-05-25?09:28??Java動態生成PDF格式報表\ITextDemo\.project

?????文件????????406??2009-05-24?17:18??Java動態生成PDF格式報表\ITextDemo\.settings\.jsdtscope

?????文件????????629??2009-05-25?10:07??Java動態生成PDF格式報表\ITextDemo\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2009-05-24?17:18??Java動態生成PDF格式報表\ITextDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2009-05-24?17:18??Java動態生成PDF格式報表\ITextDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????967??2009-05-25?10:03??Java動態生成PDF格式報表\ITextDemo\src\book.sql

?????文件???????1466??2009-05-25?10:08??Java動態生成PDF格式報表\ITextDemo\src\com\svse\dao\BookInfoDao.java

?????文件???????2005??2009-06-24?15:17??Java動態生成PDF格式報表\ITextDemo\src\com\svse\db\DBConnection.java

?????文件???????1590??2009-05-25?14:35??Java動態生成PDF格式報表\ITextDemo\src\com\svse\itext\Demo1.java

?????文件???????2439??2009-05-25?08:56??Java動態生成PDF格式報表\ITextDemo\src\com\svse\itext\Demo2.java

?????文件???????2274??2009-05-25?15:10??Java動態生成PDF格式報表\ITextDemo\src\com\svse\itext\Demo3.java

?????文件???????1281??2009-05-25?10:15??Java動態生成PDF格式報表\ITextDemo\src\com\svse\itext\Demo4.java

?????文件???????4997??2009-06-24?18:14??Java動態生成PDF格式報表\ITextDemo\src\com\svse\servlet\PdfServlet.java

?????文件????????904??2009-05-25?10:04??Java動態生成PDF格式報表\ITextDemo\src\com\svse\vo\BookInfo.java

?????文件???????1044??2009-05-25?09:46??Java動態生成PDF格式報表\ITextDemo\WebRoot\demo1.jsp

?????文件????????866??2009-05-25?10:09??Java動態生成PDF格式報表\ITextDemo\WebRoot\index.jsp

?????文件?????????39??2009-05-24?17:18??Java動態生成PDF格式報表\ITextDemo\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1247??2009-05-25?11:15??Java動態生成PDF格式報表\ITextDemo\WebRoot\show.jsp

?????文件????????967??2009-05-25?10:03??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\book.sql

?????文件???????2309??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\dao\BookInfoDao.class

?????文件???????2267??2009-06-24?15:17??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\db\DBConnection.class

?????文件???????1674??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\itext\Demo1.class

?????文件???????2209??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\itext\Demo2.class

?????文件???????2828??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\itext\Demo3.class

?????文件???????2257??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\itext\Demo4.class

?????文件???????5512??2009-06-24?18:14??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\servlet\PdfServlet.class

?????文件???????1497??2009-06-24?15:16??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\classes\com\svse\vo\BookInfo.class

?????文件????1563708??2007-12-10?09:43??Java動態生成PDF格式報表\ITextDemo\WebRoot\WEB-INF\lib\itext-1.5.2.jar

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