goodslist.java

老牌java开发的物流管理系统 详细的我也没有怎么看 好像是恒基的

package com.wl.actionimpl;
/**
 * tisn xiaoshun
 */
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.wl.action.Action;
import com.wl.dao.GoodsInfoDAO;
import com.wl.dao.GoodsTypeDAO;
import com.wl.dao.StockRegionInfoDAO;
import com.wl.dao.SupplyDAO;
import com.wl.dao.TypeDAO;
import com.wl.entity.GoodsInfo;
import com.wl.entity.Type;

public class GoodsList implements Action{

	public String doExcute(HttpServletRequest request,
			HttpServletResponse response) {
		GoodsInfoDAO goodsinfodao=new GoodsInfoDAO();
		List<GoodsInfo> goodslist=goodsinfodao.selectAllGoodsInfo();
		GoodsInfo goodsinfo=null;
		List<GoodsInfo> allgoodslist=new ArrayList<GoodsInfo>();
  for(int i=0;i<goodslist.size();i++){
			goodsinfo=goodslist.get(i);
	int id=goodsinfo.getId();	
	String goodsId=goodsinfo.getGoodsId();
	String goodsName=goodsinfo.getGoodsName();
	String goodsABC=goodsinfo.getGoodsABC();
	String goodsProvince=goodsinfo.getGoodsProvince();
	String goodsCity=goodsinfo.getGoodsCity();
	float goodsPrice=goodsinfo.getGoodsPrice();
	int goodsStockNumber=goodsinfo.getGoodsStockNumber();
	String goodsOrderDate=goodsinfo.getGoodsOrderDate();
	String goodsStockInDate=goodsinfo.getGoodsStockInDate();
	String goodsUnit=goodsinfo.getGoodsUnit();
	 /**
	 * 查询商品类型名字
	 */
	  int typeId=goodsinfo.getTypeId();
	  GoodsTypeDAO goodstypedao=new GoodsTypeDAO();
	  String goodstypeName=goodstypedao.selectCommcateById(typeId).getCommodityName();
	  /**
	   * 查询供应商名字
	   */
	  int goodsSupplyId=goodsinfo.getGoodsSupplyId();
	  SupplyDAO supplydao=new SupplyDAO();
	  String goodsSupplyName=supplydao.querySupplyId(goodsSupplyId).getSupplyName();
		/**
		 * 查询入库位置名字
		 */
	  int goodsStockId=goodsinfo.getGoodsStockId();
	  StockRegionInfoDAO stockregioninfodao=new StockRegionInfoDAO();
	  String goodsPostionName=stockregioninfodao.selectStockRegionInfoById(goodsStockId).getStockRegionName();
		/**
		 * 查询商品类别名字
		 */
		int goodsCateId=goodsinfo.getGoodsCateId();
		TypeDAO typedao=new TypeDAO();
		Type type=typedao.selectTypeById(goodsCateId);
		String goodsCommectName=type.getTypeName();
		GoodsInfo tian=new GoodsInfo(id,goodsId,goodsName,goodsCateId,goodsSupplyId,goodsABC,goodsProvince,goodsCity,
				  goodsStockId,goodsPrice,goodsStockNumber,goodsOrderDate,goodsStockInDate,goodsUnit,
	              typeId,goodstypeName,goodsSupplyName,goodsPostionName,goodsCommectName);
		allgoodslist.add(tian);
       }	
		request.getSession().setAttribute("allgoodslist",allgoodslist);
		return "/jsp/goodslist.jsp";
	}

}