mybatis foreach 出错

来源：互联网发布：arduino json 编辑：程序博客网时间：2024/06/05 14:41

环境： 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类字段不一致造成的。
总结：不能一味的死钻牛角尖，有时候管事，有时候不管事，要学会变通

阅读全文

0 0