非必传参数写法

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;
}