Jeesite下拉列表显示

备注：学习笔记，自己能看懂。

本模块是商品表  关联商家表 

1.前端  ListFrom中写
<#form:select path="businessId" items="${businessList}" itemLabel="businessName" itemValue="id" class="form-control required" blankOption="true"/>

2，后台需要定义businessList

/** * 查看编辑表单 */

@RequiresPermissions("businesssku:zepodBusinessSku:view") @RequestMapping(value = "form")

public String form(ZepodBusinessSku zepodBusinessSku, Model model){

List<ZepodBusiness> list = zepodBusinessService.listBusinessSelect();
商家模块里有listBusinessSelect()方法

model.addAttribute("businessList",list);

model.addAttribute("zepodBusinessSku", zepodBusinessSku); return "modules/businesssku/zepodBusinessSkuForm"; }

3，商家dao.xml中有sql语句
<!-- 查询商家信息列表 --> <select id="listBusinessSelect" resultType="com.jeesite.modules.business.entity.ZepodBusiness"> SELECT id,business_name FROM zepod_business WHERE del_flag = 0 </select>

查出需要用到的2个数据，查到商家id跟名字