1.报错org.apache.ibatis.binding.BindingException: Parameter ‘orderitems’ not found. Available parameters are [arg0, collection, list]
<insert id="insertBatch">
insert into orderitem
(orderItemId, quantity, subtotal,bid, bname, currPrice,image_b, oid)
values
<foreach collection="orderitems" separator="," item="item" >
( (SELECT REPLACE(UUID(), '-', '') AS orderItemId),
#{item.quantity},#{item.subtotal},#{item.bid},#{item.bname},
#{item.currprice},#{item.imageB},#{item.oid})
</foreach>
</insert>
问题说明:OrderitemMapper.xml找不到orderitems
原因:在OrderitemMapper未专门声明orderitems
void insertBatch(List<Orderitem> orderitems);
解决:添加@Param(“orderitems”) 注解专门声明
void insertBatch(@Param("orderitems") List<Orderitem> orderitems);