一、
HTML
<div class="form-group">
<label class="control-label">${text('单据类型')}:</label>
<div class="control-inline width-120">
<#form:select name="fbilltype" items="${billTypeFilter}" itemLabel="text" itemValue="id" blankOption="false" blankOption="true" class="form-control"/>
</div>
</div>
二、
Controller:
model.addAttribute("billTypeFilter", dictDataSelectService.getBillTypeData("'401','402'"));
Service:
public List<DictDataSelect> getBillTypeData(String data) {
DictDataSelect dictDataSelect = new DictDataSelect();
dictDataSelect.setValues(data);
return dao.getBillTypeData(dictDataSelect);
}
Dao :
public List<DictDataSelect> getBillTypeData(DictDataSelect dictDataSelect);
XML :
<select id="getBillTypeData" resultType="DictDataSelect">
SELECT
T.DICT_VALUE AS "id",
T.DICT_LABEL AS "text"
FROM JS_SYS_DICT_DATA T
WHERE T.DICT_TYPE = '字典类型'
AND T.DICT_VALUE IN (${values})
ORDER BY T.DICT_CODE
</select>
实体:
public class DictDataSelect extends DataEntity<DictDataSelect>{
private String id;
private String text;
private String values;
private String type;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public String getValues() {
return values;
}
public void setValues(String values) {
this.values = values;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
}