非必传参数写法
controler
@ApiParam(required = false, name = "aae135", value = "身份证号") @RequestParam(required = false) String aae135,
@ApiParam(required = false, name = "aac003", value = "姓名") @RequestParam(required = false) String aac003,
if (aac003 == null || aac003.trim().equals("") || aac003.trim().equals("\"\"")
|| aac003.trim().equals("null")) {
aac003 = null;
}
if (aae135 == null || aae135.trim().equals("") || aae135.trim().equals("\"\"")
|| aae135.trim().equals("null")) {
aae135 = null;
}
service
public List<Af41Dto> findAllByAab301AndAab300(String aab301, String aab300){
StringBuilder sb = new StringBuilder();
List paramsList = new ArrayList();
sb.append("select af41.aab301,\n" +
" AAB300,\n" +
" AAE006,\n" +
" AAE007,\n" +
" AAA146,\n" +
" (SELECT aae005\n" +
" from ic88\n" +
" where aae036 =\n"
if (StringUtils.isNotBlank(aab301)) {
sb.append(" and af41.aab301 = ? ");
paramsList.add(aab301);
}
if (StringUtils.isNotBlank(aab300)) {
sb.append(" and af41.aab300 like ? ");
paramsList.add(aab300+"%");
}
List<Af41Dto> af41Dto = toolCache.excuteNativeQueryToDto(sb.toString(), paramsList.toArray(), Af41Dto.class);
return af41Dto;
}