1.获取勾选值
function exportRow(){
table.set();
$.modal.confirm("确定导出选择的数据吗?", function() {
var data = $("#" + table.options.id).bootstrapTable('getSelections');
var woNums = [];
for(var i =0; i< data.length;i++){
woNums.push(data[i].woNum);
}
$.modal.loading("正在导出数据,请稍后...");
$.ajax({
url: prefix + "/exportChoose",
data: {
"woNum":woNums
},
type:"post",
success: function (data) {
window.location.href = ctx + "common/download?fileName=" + encodeURI(data.msg) + "&delete=" + true;
$.modal.closeLoading();
},
error: function (data) {
$.modal.alertError("出错啦!");
}
})
});
}
2.mybatis in 查询
<select id="getListByWoNumList" resultMap="VisaDetailsResult">
//这里是你的sql查询语句
<include refid="selectVisaDetailsVo" />
WHERE wo_num IN
<foreach collection="list" item="woNum" index="index" open="(" close=")" separator=",">
#{woNum}
</foreach>
</select>
3.java controller代码
@PostMapping("/exportChoose")
@ResponseBody
public AjaxResult exportChoose(@RequestParam(value = "woNum[]") String[] ids)
{
System.out.println("参数:ids:"+ JSON.toJSONString(ids));
List tbList = JSON.parseArray(JSON.toJSONString(ids));
List<VisaDetails> list = visaDetailsService.getListByWoNumList(tbList);
ExcelUtil<VisaDetails> util = new ExcelUtil<VisaDetails>(VisaDetails.class);
return util.exportExcel(list, "details");
}