mybatis 标签有两种写法
一种是
<foreach collection="companyIdList" open="(" close=")" separator="," index="index" item="item">
#{item}
</foreach>
第二种是
<foreach collection="busMemberIdList" open="(" close=")" separator="," index="index" item="item">
'${item}'
</foreach>
注意${item}两边要有引号
如果我们的分页用了 com.github.miemiedev.mybatis.paginator.domain; 的pageBonus插件,则foreach标签只能用第二种写法,第一种写法会报错
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause:java.lang.reflect.UndeclaredThrowableException
Cause: java.lang.reflect.UndeclaredThrowableException
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
org.apache.ibatis.reflection.ReflectionException: There is no getter for property named '__frch_item_0' in
记录坑爹的一次bug