xqbm 的精确查询:
if(StringUtils.isNotBlank(params.get("xqbm"))){
wrapper.eq(GjWiredNetwork::getXqbm,params.get("xqbm"));
}
xqmc 的模糊查询:
if(org.apache.commons.lang.StringUtils.isNotBlank(params.get("xqmc")) && "1" == params.get("xqmc")){
wrapper.likeRight(GjWiredNetwork::getXqmc, params.get("xqmc").substring(0,2));
}else if(org.apache.commons.lang.StringUtils.isNotBlank(params.get("xqmc")) && "2" == params.get("xqmc")){
wrapper.likeRight(GjWiredNetwork::getXqmc, params.get("xqmc"));
}else if(org.apache.commons.lang.StringUtils.isNotBlank(params.get("xqmc")) && "3" == params.get("xqmc")){
wrapper.likeRight(GjWiredNetwork::getXqmc, params.get("xqmc").substring(0,6));
}
前端往后端传值:
前端写法:
window.open("/workApi/poimjku/ewopi/iuiehk?&xqbm="+params.xqbm+"&xqmc="+params.xqmc+"&type="+params.type+"&xzc="+params.xzc+"&navKey="+params.navKey+"&fileName="+sheetName);
后端写法(使用Map将数据进行封装):
@ApiOperation
@GetMapping("/ewopi/iuiehk")
public void wiredNetworkrolldaochu(HttpServletResponse response, @RequestParam("xqbm") String xqbm, @RequestParam("xqmc") String xqmc,
@RequestParam("xzc") String xzc, @RequestParam("type") String type,
@RequestParam("navKey") String navKey, @RequestParam("fileName") String fileName
) throws IOException {
Map<String,String> params = new HashMap<>();
params.put("navKey",navKey);
params.put("xqbm",xqbm);
params.put("xqmc",xqmc);
params.put("xzc",xzc);
params.put("type",type);