最近在项目中遇到,通过截取字符串,获取编号, 去数据库查询,结果因为截取的编号有空格,导致数据查询不到。
String applyno = "L181106000182, L181107000252";
String[] applynoArr = applyno.split(",");
// 截取后
applynoArr[0]="L181106000182";
applynoArr[1]=" L181107000252";// 有空格,因此去数据库查不到对应记录
// 在sql中处理 ltrim(rtrim(#{item, jdbcType=VARCHAR}))
select
MIN(create_time) AS beginTime,MAX(create_time) AS endTime
from
payment_histor
where
result=1
AND
apply_no in
<foreach item="item" collection="loanNoList" separator="," open="(" close=")" index="">
ltrim(rtrim(#{item, jdbcType=VARCHAR}))
</foreach>