在EditStock页面中
<input type="hidden" name="commodityId" value="${stockForm.commodityId}"/>
<input type="hidden" name="commodityName" value="${stockForm.commodityName}"/>//显示前要先将值传过来
${stockForm.commodityName} //直接显示商品名称
在StockController里
@RequestMapping(value = "initEditStock", method = RequestMethod.GET)
public String initEditStock(Model model, StockForm stockForm) {
log.info("修改库存单据信息初始化");
StockForm re = stockService.searchEditStock(stockForm);
model.addAttribute("stockForm", re); 将查询的值传回stockForm里
return "manager/stock/editStock";
}
在stockService里
public StockForm searchEditStock(StockForm re) {
return queryDao.executeForObject("Stock.selectEditStock", re, StockForm.class);
}
对应的SQL文
<select id="selectEditStock"
parameterClass="cn.agriculture.web.form.StockForm"
resultClass="cn.agriculture.web.form.StockForm">
SELECT stock.stock_id as stockId,
commodity.commodity_name as commodityName,
commodity.commodity_id as commodityId,
stock.stock as stock,
stock.note as note
FROM stock,commodity
WHERE stock.commodity_id=commodity.commodity_id
AND stock.stock_id=#stockId#
</select>