📄 selectallstockout.java
字号:
package com.wl.actionimpl;
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.StockoutinfoDAO;
import com.wl.dao.TypeDAO;
import com.wl.entity.GoodsInfo;
import com.wl.entity.GoodsType;
import com.wl.entity.Login;
import com.wl.entity.StockOutInfo;
import com.wl.entity.Type;
public class SelectAllStockOut implements Action{
public String doExcute(HttpServletRequest request,
HttpServletResponse response) {
List<StockOutInfo> allstockout=new ArrayList<StockOutInfo>();
StockoutinfoDAO stockoutinfodao=new StockoutinfoDAO();
List<StockOutInfo> stockoutlist=stockoutinfodao.selectStockoutinfo();
for(int i=0;i<stockoutlist.size();i++){
StockOutInfo stockoutinfo=stockoutlist.get(i);
int id=stockoutinfo.getId();
String stockOutId=stockoutinfo.getStockOutId();
String stockOutDate=stockoutinfo.getStockOutDate();
int chargeId=stockoutinfo.getChargeId();
int goodsOutNumber=stockoutinfo.getGoodsOutNumber();
String goodsReceive=stockoutinfo.getGoodsReceive();
String goodsOutMemo=stockoutinfo.getGoodsOutMemo();
/**
* 得到商品名称
*/
int goodsId=stockoutinfo.getGoodsId();
GoodsInfoDAO goodsinfodao=new GoodsInfoDAO();
GoodsInfo goodsinfo=goodsinfodao.selectGoodsInfoById(goodsId);
String goodsoutName=goodsinfo.getGoodsName();
/**
* 得到商品等级名称
*/
int CommodityId=stockoutinfo.getCommodityId();
GoodsTypeDAO goodstypedao=new GoodsTypeDAO();
GoodsType goodstype=goodstypedao.selectCommcateById(CommodityId);
String commodityName=goodstype.getCommodityName();
/**
* 得到商品类型名称
*/
int typeId=stockoutinfo.getTypeId();
TypeDAO typedao=new TypeDAO();
Type type=typedao.selectTypeById(typeId);
String typeName=type.getTypeName();
/**
* 得到负责人名字
*/
LoginDAO logindao=new LoginDAO();
Login login=logindao.selectLoginById(chargeId);
String chargename=login.getLoginName();
StockOutInfo stockout=new StockOutInfo(id,stockOutId,stockOutDate,chargeId,goodsId,goodsOutNumber,goodsReceive,
typeId,CommodityId,goodsOutMemo,goodsoutName,typeName,commodityName,chargename);
allstockout.add(stockout);
}
request.getSession().setAttribute("allstockout",allstockout);
return "/jsp/goodsoutstorelist.jsp";
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -