报错代码:
StringBuilder sb = new StringBuilder("select * from table where 1=1");
MapSqlParameterSource parameterSource = new MapSqlParameterSource();
if (null != detail.getTaskTitle() && !detail.getTaskTitle().equals("")) {
String msg=""+detail.getTaskTitle();
parameterSource.addValue("msg", msg);
sb.append(" and msg like concat('%', :msg ,'%')");
}
将最后一句改为
sb.append(" and msg like concat(concat('%', :msg ),'%')");
执行成功