继上一篇省份问题

1、在common.sql

<select id="selectExpressPriceProvince" parameterClass="java.lang.String"

resultClass="cn.agriculture.web.form.Item">

SELECT province_name as label,

province_id as valueFROM province

WHERE not exists(

SELECT express_price.province_idFROM express_price,express

WHERE express_price.province_id=province.province_id

AND express.express_id = express_price.express_id

AND express.express_id=#value#) 用此条语句获取值

</select>

利用 快递商的快递商ID（express.express_id）和快递商价格的快递商ID（express_price.express_id）是否是同一个express.express_id = express_price.express_id得出是同一快递商express_price.province_id=province.province_id

利用快递商价格的省份ID（ express_price.province_id） 和省份的省份ID（province.province_id）一样 express_price.province_id=province.province_id得出快递商已添加此省份。

2、ExpressPriceController.java

 @RequestMapping(value = "initAddExpressPrice", method = RequestMethod.GET)

    public String initAddExpressPrice(Model model, ExpressPriceForm expressPriceForm) {

    log.info("追加快递商所属价格初始化");

    List<Item> provinceList = itemListComponent.getProvinceList1(expressPriceForm.getExpressId());

用此条语句获取快递商id 

    model.addAttribute("provinceList", provinceList);

    model.addAttribute("expressPriceForm", expressPriceForm);

        return "manager/expressPrice/addExpressPrice";

    }

3、 ItemListComponent.java

public List<Item> getProvinceList1(String expressId) {  用一个值传入  

return queryDao.executeForObjectList("Common.selectExpressPriceProvince", expressId);

}

转载于:https://my.oschina.net/u/2411775/blog/485682