package?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?entity.Items;
import?util.DBUtil;

public?class?ItemsDao?{
	//獲取所有的商品信息
	public?ArrayList?getAllItems（）{
		ArrayList?result=new?ArrayList（）;
		Connection?conn=DBUtil.getConnection（）;
	
		String?sql=“select?*from?items?;“;
		try?{
			PreparedStatement?ptmt=conn.prepareStatement（sql）;
			ResultSet?rs=ptmt.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.getStri

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-05-19?10:28??0\
?????文件?????????362??2020-05-19?10:05??0\.classpath
?????目錄???????????0??2020-05-19?10:05??0\.myeclipse\
?????文件?????????303??2020-05-19?10:05??0\.mymetadata
?????文件????????1620??2020-05-19?10:05??0\.project
?????目錄???????????0??2020-05-19?10:28??0\.settings\
?????文件?????????613??2020-05-19?10:05??0\.settings\.jsdtscope
?????文件?????????395??2020-05-19?10:05??0\.settings\org.eclipse.jdt.core.prefs
?????文件?????????465??2017-11-13?17:35??0\.settings\org.eclipse.wst.common.component
?????文件?????????339??2017-11-13?17:35??0\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2020-05-19?10:05??0\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2020-05-19?10:05??0\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2020-05-19?10:28??0\build\
?????目錄???????????0??2020-05-19?10:28??0\build\classes\
?????目錄???????????0??2020-05-19?10:28??0\build\classes\dao\
?????文件????????3085??2017-11-13?17:35??0\build\classes\dao\ItemsDao.class
?????目錄???????????0??2020-05-19?10:28??0\build\classes\entity\
?????文件????????1443??2017-11-13?17:35??0\build\classes\entity\Items.class
?????目錄???????????0??2020-05-19?10:28??0\build\classes\util\
?????文件????????1726??2017-11-13?17:35??0\build\classes\util\DBUtil.class
?????文件???????35147??2017-11-13?17:35??0\LICENSE
?????目錄???????????0??2020-05-19?10:28??0\src\
?????目錄???????????0??2020-05-19?10:28??0\src\dao\
?????文件????????2060??2020-05-19?10:10??0\src\dao\ItemsDao.java
?????目錄???????????0??2020-05-19?10:28??0\src\entity\
?????文件?????????851??2017-11-13?17:35??0\src\entity\Items.java
?????目錄???????????0??2020-05-19?10:28??0\src\util\
?????文件????????1036??2020-05-19?10:07??0\src\util\DBUtil.java
?????目錄???????????0??2020-05-19?10:28??0\WebRoot\
?????文件????????4398??2020-05-19?10:26??0\WebRoot\detail.jsp
?????目錄???????????0??2020-05-19?10:28??0\WebRoot\images\
............此處省略26個文件信息