mybatis foreach 出错

最新推荐文章于 2022-03-15 11:58:45 发布

花开的世界

最新推荐文章于 2022-03-15 11:58:45 发布

阅读量1k

点赞数

分类专栏：经验文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/gaods033/article/details/73187721

版权

经验专栏收录该内容

4 篇文章

订阅专栏

环境： mybatis 3.2.2
代码：

  <insert id="insertRiskFreezeList" parameterType="java.util.List">
            INSERT INTO risk_batch_freeze
                 (enterprise_id,enterprise_name,pop_vender_id,shop_name,
             freeze_amount,freeze_account,freeze_cause,create_time,
            operator_erp,opera_result,batch_no,dr,ts)
                VALUES
        <foreach collection ="param1" item="i" separator =",">
                (#{i.enterpriseId},
                 #{i.enterpriseName},
                 #{i.popVenderId},
                 #{i.shopName},
                 #{i.freezeAmount},
                 #{i.freezeAccount},
                 #{i.freezeCause},
                 #{i.createTime},#{i.operatorErp},
                 #{i.operaResult},
                 #{i.batchNo},0,now())
            </foreach >

在用foreach批量插入的时候报了下面的错误：


Caused by: org.apache.ibatis.binding.BindingException: Parameter '__frch_i_0' not found. Available parameters are [param1]
    at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:160) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:41) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.reflection.MetaObject.metaObjectForProperty(MetaObject.java:135) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:106) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:72) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:77) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:58) ~[mybatis-3.2.2.jar:3.2.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_45]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_45]
    at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59) ~[mybatis-3.2.2.jar:3.2.2]
    at com.sun.proxy.$Proxy78.parameterize(Unknown Source) ~[na:na]
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:71) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:44) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148) ~[mybatis-3.2.2.jar:3.2.2]
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137) ~[mybatis-3.2.2.jar:3.2.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_45]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_45]
    at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354) ~[mybatis-spring-1.2.0.jar:1.2.0]
    ... 44 common frames omitted

解决方案：
1、一开始跟代码，跟的一头雾水，
最后跟到


  private static String itemizeItem(String item, int i) {
    return new StringBuilder(ITEM_PREFIX).append(item).append("_").append(i).toString();
  }

2、要本着一个原则：复杂的问题简单化
我坚信是自己的sql写错了，我就一个一个删掉的试试最后发现：freezeAccount字段有问题，经查是和自己的VO类字段不一致造成的。
总结：不能一味的死钻牛角尖，有时候管事，有时候不管事，要学会变通