📄 goodsinstorelist.java
字号:
package com.wl.actionimpl;
/**
* tian 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.LoginDAO;
import com.wl.dao.StockInDAO;
import com.wl.dao.TypeDAO;
import com.wl.entity.GoodsInfo;
import com.wl.entity.GoodsType;
import com.wl.entity.Login;
import com.wl.entity.StockInInfo;
import com.wl.entity.Type;
public class GoodsinstoreList implements Action{
public String doExcute(HttpServletRequest request,
HttpServletResponse response) {
StockInDAO stockindao=new StockInDAO();
List<StockInInfo> stockinList=stockindao.selectAllStockInInfo();
List<StockInInfo> stockinInfoList=new ArrayList<StockInInfo>();
StockInInfo stockininfomanager=null;
for(int i=0;i<stockinList.size();i++){
StockInInfo stockininfo=stockinList.get(i);
int stockid=stockininfo.getId();
String stockInId=stockininfo.getStockInId();
/**
* 得到商品名称
*/
int goodsId=stockininfo.getGoodsId();
GoodsInfoDAO goodsinfodao=new GoodsInfoDAO();
GoodsInfo goodsinfo=goodsinfodao.selectGoodsInfoById(goodsId);
String goodsName=goodsinfo.getGoodsName();
/**
* 得到商品等级名称
*/
int commodityId=stockininfo.getCommodityId();
GoodsTypeDAO goodstypedao=new GoodsTypeDAO();
GoodsType goodstype=goodstypedao.selectCommcateById(commodityId);
String goodsCommecteName=goodstype.getCommodityName();
/**
* 得到商品类型名称
*/
int typeId=stockininfo.getTypeId();
TypeDAO typedao=new TypeDAO();
Type type=typedao.selectTypeById(typeId);
String goodsTypeName=type.getTypeName();
/**
* 得到负责人名称
*/
int chargeId=stockininfo.getChargeId();
LoginDAO logindao=new LoginDAO();
Login login=logindao.selectLoginById(chargeId);
String goodsChargeName=login.getLoginName();
String stockInDate=stockininfo.getStockInDate();
int goodsInNumber=stockininfo.getGoodsInNumber();
String goodsInMemo=stockininfo.getGoodsInMemo();
stockininfomanager=new StockInInfo(stockid,stockInId,stockInDate,goodsChargeName,goodsName,goodsInNumber,
goodsTypeName,goodsCommecteName,goodsInMemo,chargeId,goodsId,typeId,commodityId);
stockinInfoList.add(stockininfomanager);
}
request.getSession().setAttribute("stockinInfoList", stockinInfoList);
return "/jsp/goodsinstorelist.jsp";
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -