package?com.dao;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;

import?com.db.DBUtil;
import?com.entity.Items;

public?class?ItemsDAO?{
	public?ArrayList?getAllItems（）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		ArrayList?list?=?new?ArrayList（）;?//?動態數組，存儲所有商品
		try?{
			conn?=?DBUtil.getConnection（）;
			String?sql?=?“select?*?from?items;“;?
			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.setOrigin（rs.getString（“origin“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getFloat（“price“））;
				item.setPicture（rs.getString（“picture“））;
				item.setDescription（rs.getString（“description“））;
				list.add（item）;//?把每一個商品添加至動態數組
			}
			return?list;?//?返回數組
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放資源
			closeSrc（rsstmtconn）;
		}

	}

	//?通過商品id查找商品
	public?Items?getItemsById（int?id）?{
		Connection?conn?=?null;
		PreparedStatement?stmt?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBUtil.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.setOrigin（rs.getString（“origin“））;
				item.setNumber（rs.getInt（“number“））;
				item.setPrice（rs.getFloat（“price“））;
				item.setPicture（rs.getString（“picture“））;
				item.setDescription（rs.getString（“description“））;
				return?item;
			}?else?{
				return?null;
			}

		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
			return?null;
		}?finally?{
			//?釋放資源
			closeSrc（rsstmtconn）;

		}
	}
	//?釋放資源
	private?void?closeSrc（ResultSet?rsPreparedStatement?stmtConnection?conn）
	{
		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（）;
			}
		}
	}
	

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????6148??2018-01-05?15:37??MallDemo\.DS_Store
?????文件????????1165??2018-01-07?19:16??MallDemo\.classpath
?????文件??????????64??2018-01-05?15:48??MallDemo\.myumldata
?????文件????????1333??2018-01-05?17:16??MallDemo\.project
?????文件?????????522??2015-12-29?10:33??MallDemo\.settings\.jsdtscope
?????文件?????????175??2018-01-05?15:43??MallDemo\.settings\com.genuitec.eclipse.core.prefs
?????文件??????????86??2018-01-05?15:48??MallDemo\.settings\com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs
?????文件??????????45??2018-01-05?15:48??MallDemo\.settings\com.spket.js.prefs
?????文件?????????364??2015-12-29?10:33??MallDemo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????475??2015-12-29?10:33??MallDemo\.settings\org.eclipse.wst.common.component
?????文件?????????414??2015-12-29?10:33??MallDemo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-12-29?10:33??MallDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-12-29?10:33??MallDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????88??2015-12-29?10:33??MallDemo\.settings\org.skyway.core.prefs
?????文件??????????66??2015-12-29?10:33??MallDemo\.tern-project
?????文件??????????39??2015-12-29?10:34??MallDemo\WebRoot\meta-INF\MANIFEST.MF
?????文件????????3150??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\dao\ItemsDAO.class
?????文件????????1206??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\db\DBUtil.class
?????文件????????2472??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\entity\Cart.class
?????文件????????2071??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\entity\Items.class
?????文件?????????714??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\po\Users.class
?????文件????????3158??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\servlet\CartServlet.class
?????文件????????2214??2018-01-17?17:00??MallDemo\WebRoot\WEB-INF\classes\com\servlet\LoginServlet.class
?????文件??????893229??2017-11-19?16:29??MallDemo\WebRoot\WEB-INF\lib\sqljdbc41.jar
?????文件????????6148??2018-01-08?15:33??MallDemo\WebRoot\assets\.DS_Store
?????文件????????4096??2018-01-08?15:33??MallDemo\WebRoot\assets\._.DS_Store
?????文件????????2817??2018-01-08?15:33??MallDemo\WebRoot\assets\input.png
?????文件????????2831??2018-01-08?15:33??MallDemo\WebRoot\assets\loginbg.png
?????文件???????15584??2018-01-08?15:33??MallDemo\WebRoot\assets\logo.png
?????文件????????2825??2018-01-08?15:33??MallDemo\WebRoot\assets\rep1.png
?????文件????????5345??2018-01-17?17:29??MallDemo\WebRoot\cart.jsp
............此處省略82個文件信息