package?com.dao;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?com.model.Good;
import?com.mysql.jdbc.PreparedStatement;
import?com.util.DBHelper;

/*
?*?2018.4.16
?*?業(yè)務(wù)邏輯類：用于操縱數(shù)據(jù)庫(kù)
?*/
public?class?GoodDao?{

	
	//獲取所有的商品信息
	public?ArrayList?getAllGoods（）?
	{
		Connection?conn=null;
		PreparedStatement?prep=null;
		ResultSet?rs=null;
		ArrayList?result=new?ArrayList（）;
		
		try?{
			conn=DBHelper.getConnection（）;
			String?sql=“select?*?from?good“;
			prep=（PreparedStatement）?conn.prepareStatement（sql）;
			rs=prep.executeQuery（）;
			
			while（rs.next（））
			{
				Good?good=new?Good（）;
				good.setId（rs.getInt（“id“））;
				good.setName（rs.getString（“name“））;
				good.setPrice（rs.getDouble（“price“））;
				good.setInfor（rs.getString（“infor“））;
				good.setImage（rs.getString（“image“））;
				result.add（good）;
			}
			return?result;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}
	
	//根據(jù)商品的id獲取數(shù)據(jù)
	public?Good?getGoodById（int?id）{
		Connection?conn=null;
		PreparedStatement?prep=null;
		ResultSet?rs=null;
		Good?good=new?Good（）;
		
		try?{
			conn=DBHelper.getConnection（）;
			String?sql=“select?*?from?good?where?id=?“;
			prep=（PreparedStatement）?conn.prepareStatement（sql）;
			prep.setInt（1?id）;
			rs=prep.executeQuery（）;
			
			if（rs.next（））
			{
				good.setId（rs.getInt（“id“））;
				good.setName（rs.getString（“name“））;
				good.setPrice（rs.getDouble（“price“））;
				good.setInfor（rs.getString（“infor“））;
				good.setImage（rs.getString（“image“））;
			}
			return?good;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}
	
		//獲取最近瀏覽的前五條商品信息
		public?ArrayList?getViewList（String?list）
		{
			//在控制臺(tái)輸出一下我們的list：測(cè)試用
			System.out.println（“l(fā)ist:“+list）;
	
			//返回的結(jié)果集
			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--）
			???????{
			????	???System.out.println（“當(dāng)前l(fā)ist的數(shù)字：“+arr[i]）;
			????	???itemlist.add（getGoodById（Integer.parseInt（arr[i]）））;??
			???????}
			????}
			????else
			????{
			????	for（int?i=arr.length-1;i>=0;i--）
			????	{
			????		System.out.println（“當(dāng)前l(fā)ist的數(shù)字：“+arr[i]）;
			????		itemlist.add（getGoodById（Integer.parseInt（arr[i]）））;
			????	}
			????}
			????return?itemlist;
			}
			else
			{
				return?null;
			}
			
		}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????1093??2018-04-27?15:39??ServletShoppingDemo\.classpath
?????文件????????1069??2018-04-27?15:39??ServletShoppingDemo\.project
?????文件?????????564??2018-04-27?15:39??ServletShoppingDemo\.settings\.jsdtscope
?????文件?????????364??2018-04-27?15:39??ServletShoppingDemo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????516??2018-04-27?15:39??ServletShoppingDemo\.settings\org.eclipse.wst.common.component
?????文件?????????414??2018-04-27?15:39??ServletShoppingDemo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-04-27?15:39??ServletShoppingDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-04-27?15:39??ServletShoppingDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????1910??2018-04-27?17:41??ServletShoppingDemo\WebRoot\Good.sql
?????文件??????????39??2018-04-27?15:39??ServletShoppingDemo\WebRoot\meta-INF\MANIFEST.MF
?????文件????????3616??2018-05-22?08:27??ServletShoppingDemo\WebRoot\WEB-INF\classes\com\dao\GoodDao.class
?????文件????????2420??2018-05-22?08:27??ServletShoppingDemo\WebRoot\WEB-INF\classes\com\model\Cart.class
?????文件????????2054??2018-05-22?08:27??ServletShoppingDemo\WebRoot\WEB-INF\classes\com\model\Good.class
?????文件????????1276??2018-05-22?08:27??ServletShoppingDemo\WebRoot\WEB-INF\classes\com\servlet\CartServlet.class
?????文件????????1255??2018-05-22?08:31??ServletShoppingDemo\WebRoot\WEB-INF\classes\com\util\DBHelper.class
?????文件?????1004840??2018-04-16?15:29??ServletShoppingDemo\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.46-bin.jar
?????文件?????1004838??2018-04-16?15:29??ServletShoppingDemo\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.46.jar
?????文件????????1292??2018-05-22?08:51??ServletShoppingDemo\WebRoot\addGood.jsp
?????文件??????????49??2018-04-16?09:03??ServletShoppingDemo\WebRoot\blank.gif
?????文件????????3456??2018-05-22?10:33??ServletShoppingDemo\WebRoot\cart.jsp
?????文件???????13341??2018-05-21?09:41??ServletShoppingDemo\WebRoot\details.jsp
?????文件?????????926??2018-05-21?09:35??ServletShoppingDemo\WebRoot\detlete.jsp
?????文件??????????42??2018-04-16?09:03??ServletShoppingDemo\WebRoot\iecss.css
?????文件????????1804??2018-04-16?09:03??ServletShoppingDemo\WebRoot\iepngfix.htc
?????文件????????6529??2018-04-16?08:56??ServletShoppingDemo\WebRoot\images\1.gif
?????文件????????3835??2018-04-16?08:56??ServletShoppingDemo\WebRoot\images\2.gif
?????文件????????6052??2018-04-16?08:56??ServletShoppingDemo\WebRoot\images\3.gif
?????文件???????21361??2018-04-16?15:50??ServletShoppingDemo\WebRoot\images\4.jpg
?????文件???????24972??2018-04-16?15:50??ServletShoppingDemo\WebRoot\images\5.jpg
?????文件???????23445??2018-04-16?15:50??ServletShoppingDemo\WebRoot\images\6.jpg
?????文件??????122368??2018-04-16?08:56??ServletShoppingDemo\WebRoot\images\Thumbs.db
............此處省略70個(gè)文件信息