package?dao;

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

import?util.DBHelper;

import?entity.Items;

//商品的業務邏輯類
public?class?ItemsDAO?{

	//?獲得所有的商品信息
	public?ArrayList?getAllItems（）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		ArrayList?list?=?new?ArrayList（）;?//?商品集合
		try?{
			conn?=?DBHelper.getConnection（）;
			String?sql?=?“select?*?from?items;“;?//?SQL語句
			stmt?=?conn.prepareStatement（sql）;
			rs?=?stmt.executeQuery（）;
			while?（rs.next（））?{
				Items?item?=?new?Items（）;
				item.setId（rs.getInt（“id“））;
				item.setName（rs.getString（“name“））;
				item.setCity（rs.getString（“city“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getInt（“price“））;
				item.setPicture（rs.getString（“picture“））;
				list.add（item）;//?把一個商品加入集合
			}
			return?list;?//?返回集合。
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放數據集對象
			if?（rs?!=?null）?{
				try?{
					rs.close（）;
					rs?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
			//?釋放語句對象
			if?（stmt?!=?null）?{
				try?{
					stmt.close（）;
					stmt?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
		}

	}

	//?根據商品編號獲得商品資料
	public?Items?getItemsById（int?id）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBHelper.getConnection（）;
			String?sql?=?“select?*?from?items?where?id=?;“;?//?SQL語句
			stmt?=?conn.prepareStatement（sql）;
			stmt.setInt（1?id）;
			rs?=?stmt.executeQuery（）;
			if?（rs.next（））?{
				Items?item?=?new?Items（）;
				item.setId（rs.getInt（“id“））;
				item.setName（rs.getString（“name“））;
				item.setCity（rs.getString（“city“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getInt（“price“））;
				item.setPicture（rs.getString（“picture“））;
				return?item;
			}?else?{
				return?null;
			}

		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放數據集對象
			if?（rs?!=?null）?{
				try?{
					rs.close（）;
					rs?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}
			//?釋放語句對象
			if?（stmt?!=?null）?{
				try?{
					stmt.close（）;
					stmt?=?null;
				}?catch?（Exception?ex）?{
					ex.printStackTrace（）;
				}
			}

		}
	}
	//獲取最近瀏覽的前五條商品信息
	public?ArrayList?getViewList（String?list）
	{
		System.out.println（“list:“+list）;
		ArrayList?itemlist?=?new?ArrayList（）;
		int?iCount=5;?//每次返回前五條記錄
		if（list!=null&&list.length（）>0）
		{
		????String[]?arr?=?list.split（““）;
		????System.out.println（“arr.length=“+arr.length）;
		????//如果商品記錄大于等于5條
		????if（arr.length>=5）
		????{
		???????for（int?i=arr.length-1;i>=arr.length-iCount;i--）
		???????{
		????	??itemlist.add（getItemsById（Integer.parseInt（arr[i]）））;??
		??

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????1407??2018-06-02?19:35??ServletCartDemo\.classpath
?????目錄???????????0??2014-09-28?09:23??ServletCartDemo\.myeclipse\
?????文件?????????318??2015-01-13?22:40??ServletCartDemo\.mymetadata
?????文件????????1758??2015-01-13?22:40??ServletCartDemo\.project
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\dao\
?????文件????????3359??2014-09-28?11:49??ServletCartDemo\src\dao\ItemsDAO.java
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\entity\
?????文件????????2205??2015-01-20?22:26??ServletCartDemo\src\entity\Cart.java
?????文件????????1849??2015-01-20?22:24??ServletCartDemo\src\entity\Items.java
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\meta-INF\
?????文件??????????40??2018-05-26?01:16??ServletCartDemo\src\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\servlet\
?????文件????????4037??2015-01-27?22:27??ServletCartDemo\src\servlet\CartServlet.java
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\src\util\
?????文件????????1215??2014-09-28?10:14??ServletCartDemo\src\util\DBHelper.java
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\WebRoot\
?????文件????????2863??2018-05-26?07:42??ServletCartDemo\WebRoot\cart.jsp
?????目錄???????????0??2018-06-02?16:48??ServletCartDemo\WebRoot\css\
?????文件????????4148??2015-01-20?20:23??ServletCartDemo\WebRoot\css\blue.css
?????文件????????1905??2015-01-20?20:23??ServletCartDemo\WebRoot\css\init.JS
?????文件????????7409??2015-01-20?20:23??ServletCartDemo\WebRoot\css\jscal2.css
?????文件???????34377??2015-01-20?20:23??ServletCartDemo\WebRoot\css\jscal2.js
?????文件????????1396??2015-01-20?20:23??ServletCartDemo\WebRoot\css\lk.css
?????文件????????1782??2015-01-20?20:31??ServletCartDemo\WebRoot\css\main.css
?????文件????????1187??2015-01-20?20:23??ServletCartDemo\WebRoot\css\oa.css
?????文件????????2029??2015-01-20?20:23??ServletCartDemo\WebRoot\css\style.css
?????文件????????1786??2015-01-20?20:23??ServletCartDemo\WebRoot\css\style_left.css
?????文件????????1433??2015-01-19?21:47??ServletCartDemo\WebRoot\css\style1.css
?????文件????????6252??2015-01-27?22:15??ServletCartDemo\WebRoot\details.jsp
?????文件?????????963??2015-01-27?20:46??ServletCartDemo\WebRoot\failure.jsp
............此處省略79個文件信息