package?com.action;



import?java.util.ArrayList;
import?java.util.List;
import?java.util.Map;

import?org.apache.struts2.ServletActionContext;

import?com.dao.TCatelogDAO;
import?com.dao.TGoodsDAO;
import?com.dao.TOrderItemDAO;
import?com.model.TGoods;
import?com.opensymphony.xwork2.ActionSupport;

public?class?indexAction?extends?ActionSupport
{
	private?TGoodsDAO?goodsDAO;
	
	private?TOrderItemDAO?orderItemDAO;
	
	
	public?String?index（）
	{
		Map?request=（Map）ServletActionContext.getContext（）.get（“request“）;
		
		
		
		String?sql=“from?TGoods?where?goodsDel=‘no‘?and?goodsIsnottejia=‘yes‘?order?by?goodsId?desc“;
		List?goodsYesTejiaList=goodsDAO.getHibernateTemplate（）.find（sql）;
		if（goodsYesTejiaList.size（）>5）
		{
			goodsYesTejiaList=goodsYesTejiaList.subList（0?5）;
		}
		request.put（“goodsYesTejiaList“?goodsYesTejiaList）;
		
		
		
		sql=“from?TGoods?where?goodsDel=‘no‘?and?goodsIsnottejia=‘no‘?order?by?goodsId?desc“;
		List?goodsNoTejiaList=goodsDAO.getHibernateTemplate（）.find（sql）;
		if（goodsNoTejiaList.size（）>5）
		{
			goodsNoTejiaList=goodsNoTejiaList.subList（0?5）;
		}
		request.put（“goodsNoTejiaList“?goodsNoTejiaList）;
		
		
		//paihangbang
		List?goodsList=new?ArrayList（）;
		sql=“select?sum（goodsQuantity）goodsId?from?TOrderItem?group?by?goodsId?order?by?sum（goodsQuantity）?desc“;
		List?list=orderItemDAO.getHibernateTemplate（）.find（sql）;
		for（int?i=0;i		{
			object[]?b=（object[]）list.get（i）;
			int?goodsId=Integer.parseInt（b[1].toString（））;
			System.out.println（goodsId+“&&“）;
			TGoods?goods=goodsDAO.findById（goodsId）;
			goodsList.add（goods）;
		}
		if（goodsList.size（）>5）
		{
			goodsList=goodsList.subList（0?5）;
		}
		request.put（“goodsList“?goodsList）;
		//paihangbang
		
		
		return?ActionSupport.SUCCESS;
	}
	

	public?TGoodsDAO?getGoodsDAO（）
	{
		return?goodsDAO;
	}

	public?void?setGoodsDAO（TGoodsDAO?goodsDAO）
	{
		this.goodsDAO?=?goodsDAO;
	}


	public?TOrderItemDAO?getOrderItemDAO（）
	{
		return?orderItemDAO;
	}


	public?void?setOrderItemDAO（TOrderItemDAO?orderItemDAO）
	{
		this.orderItemDAO?=?orderItemDAO;
	}
	
	
}

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

?????文件????6794752??2015-05-13?10:35??596JSP+MYSQL汽車銷售系統\JSP汽車銷售系統錄像.avi

?????文件???????5186??2011-05-08?18:13??596JSP+MYSQL汽車銷售系統\wlgw\.classpath

?????文件????????527??2011-04-01?03:20??596JSP+MYSQL汽車銷售系統\wlgw\.myhibernatedata

?????文件????????285??2015-05-13?10:29??596JSP+MYSQL汽車銷售系統\wlgw\.mymetadata

?????文件???????1632??2011-04-01?03:20??596JSP+MYSQL汽車銷售系統\wlgw\.project

?????文件????????330??2010-07-16?17:19??596JSP+MYSQL汽車銷售系統\wlgw\.settings\org.eclipse.jdt.core.prefs

?????文件????????273??2010-09-16?14:38??596JSP+MYSQL汽車銷售系統\wlgw\.springBeans

?????文件???????2189??2011-03-10?15:48??596JSP+MYSQL汽車銷售系統\wlgw\src\com\action\indexAction.java

?????文件???????4153??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\dao\TLiuyanDAO.java

?????文件???????4475??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\dao\TOrderDAO.java

?????文件???????2327??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\model\TGonggao.hbm.xml

?????文件???????3782??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\model\TGonggao.java

?????文件???????1510??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\model\TOrder.hbm.xml

?????文件???????2183??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\model\TOrder.java

?????文件???????2622??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\service\loginService.java

?????文件???????2922??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\util\upload.java

?????文件???????2534??2011-03-03?18:12??596JSP+MYSQL汽車銷售系統\wlgw\src\com\util\Util.java

?????文件???????1589??2010-08-08?19:54??596JSP+MYSQL汽車銷售系統\wlgw\src\log4j.properties

?????文件??????????0??2010-07-17?10:44??596JSP+MYSQL汽車銷售系統\wlgw\src\messages_en_US.properties

?????文件??????????8??2010-07-17?10:44??596JSP+MYSQL汽車銷售系統\wlgw\src\messages_zh_CN.properties

?????文件???????3526??2010-07-17?10:44??596JSP+MYSQL汽車銷售系統\wlgw\src\struts.properties

?????文件???????8324??2011-04-02?00:28??596JSP+MYSQL汽車銷售系統\wlgw\src\struts.xml

?????文件???????2800??2011-04-18?09:38??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\catelog\catelogAdd.jsp

?????文件???????2975??2011-04-18?09:39??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\catelog\catelogEditPre.jsp

?????文件???????3016??2011-04-18?09:39??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\catelog\catelogMana.jsp

?????文件???????2979??2011-03-03?18:17??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\gonggao\gonggaoAdd.jsp

?????文件???????1134??2011-03-03?18:17??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\gonggao\gonggaoDetail.jsp

?????文件???????3040??2011-03-03?18:17??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\gonggao\gonggaoMana.jsp

?????文件???????2812??2011-03-03?18:17??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\index\adminAdd.jsp

?????文件???????2897??2011-03-03?18:17??596JSP+MYSQL汽車銷售系統\wlgw\WebRoot\admin\index\adminManage.jsp

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