JqGrid添加时的下拉菜单实现

 

添加时的下拉菜单中的值需要从数据库中查出来，后台拼接字符串传给前台

 

前台代码：

                    {name: 'guruId',editable : true, edittype:'select',
                        editoptions: {
                            dataUrl:'${ctx}/guru/findAll'
                        },
                        formatter:function (value, options, row) {
                            return row.guru.dharma;
                        }
                    }

后台代码：

@RestController
@RequestMapping("/guru")
public class GuruController {

    @Autowired
    private GuruService guruService;

    @RequestMapping("findAll")
    //直接将拼接好的下拉框返回
    public String findAll(String dharma){
        List<Guru> gurus = guruService.selectList(null);
        StringBuilder sbu = new StringBuilder("<select class='form-control' name='guruId' >");
        //添加了默认选中
        for (Guru guru : gurus) {
            if(guru.getDharma().equals(dharma)){
                String option = "<option value='" + guru.getId() + "' selected>" + guru.getDharma() + "</option>";
                sbu.append(option);
            }else{
                String option = "<option value='" + guru.getId() + "'>" + guru.getDharma() + "</option>";
                sbu.append(option);
            }
        }
        sbu.append("</select>");
        System.out.println(sbu.toString());
        return sbu.toString();
    }

}