添加商品时选择类别时的下拉列表 (适合新手。请高手改正)
一、
---shan+flyinke
在类的form.jsp 添加 快捷方便 不须修改controller类
<%@ page import="java.io.*,java.util.*,java.sql.*"%> <%@ page import="javax.servlet.http.*,javax.servlet.*" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <html> <head> <title>JSTL sql:query Tag</title> </head> <body> <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/TEST" user="root" password="pass123"/> <sql:query dataSource="${snapshot}" var="result"> SELECT * from Employees; </sql:query> <div class="control-group"> <label class="control-label">所属分类 category_no:</label> <div class="controls"> <form:select path="categoryno" class="input-xlarge">
<form:option value="" label="请选择"/>
<c:forEach var="row" items="${result.rows}" >
修改时获得所选类别名称
<option value="${row.categoryno}" ${row.categoryno eq llShopGoods.categoryno ?'selected':''}>${row.categoryname}</option>
</c:forEach>
</form:select>
</div></div>
二、
修改controller 类
/**
* 编辑Controller
* @author 王俊山
* @version 2016-05-14
*/
@Controller
@RequestMapping(value = "${adminPath}/shopgoods/llShopGoods")
public class LlShopGoodsController extends BaseController {
@Autowired
private LlShopGoodsService llShopGoodsService;
添加下拉列表关联service @Autowired private LlShopGoodsCategoryService llShopGoodsCategoryService; 修改form方法 @RequiresPermissions("shopgoods:llShopGoods:view") @RequestMapping(value = "form") public String form(LlShopGoods llShopGoods,LlShopGoodsCategory llShopGoodsCategory, Model model) { List<LlShopGoodsCategory> list =llShopGoodsCategoryService.findList(llShopGoodsCategory); model.addAttribute("llShopGoods", llShopGoods); model.addAttribute("list",list); return "modules/shopgoods/llShopGoodsForm"; }
form.jsp
<div class="control-group">
<label class="control-label">所属分类 category_no:</label>
<div class="controls">
<form:select path="categoryno" class="input-xlarge">
<form:option value="" label="请选择"/>
<c:forEach var="row" items="${list}" >
<option value="${row.categoryno}" ${row.categoryno eq llShopGoods.categoryno ?'selected':''}>${row.categoryname}</option>
</c:forEach>
</form:select>
</div>
</div>