mybatis insert foreach

2022-07-11 07:56:25

项目场景:

报错 ,找不到参数
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘statusInfoId’ not found. Available parameters are [collection, list]

  @Mapper
public interface PatrolRecordMapper extends BaseMapper<PatrolRecord>{intinsertList(@Param(value="list") List<PatrolRecord> list);}

mapper 换了很多种写法

<insert id="insertList" parameterType="com.iricto.soft.patrol.entity.PatrolRecord">
        insert intopatrol_record(status_info_id,route_id,place_name,patrol_time,
        patrol_user,patrol_class,`status`)
        VALUES<foreach collection="list" item="patrolRecord" separator=",">(patrolRecord.#{statusInfoId},
            patrolRecord.#{routeId},
            patrolRecord.#{placeName},
            patrolRecord.#{patrolTime},
            patrolRecord.#{patrolUser},
            patrolRecord.#{patrolClass},
            patrolRecord.#{status})</foreach></insert>

mapper

<insert id="insertList" parameterType="com.iricto.soft.patrol.entity.PatrolRecord">
        insert intopatrol_record(status_info_id,route_id,place_name,patrol_time,
        patrol_user,patrol_class,`status`)
        VALUES<foreach collection="list" item="list"
                 open="(" separator="," close=")">
            list.#{statusInfoId},
            list.#{routeId},
            list.#{placeName},
            list.#{patrolTime},
            list.#{patrolUser},
            list.#{patrolClass},
            list.#{status}</foreach></insert>

最后应该这么写才对 : mapper

<insert id="insertList" parameterType="com.iricto.soft.patrol.entity.PatrolRecord">
        insert intopatrol_record(status_info_id,route_id,place_name,patrol_time,
        patrol_user,patrol_class,`status`)
        VALUES<foreach collection="list" item="patrolRecord" separator=",">(
            #{patrolRecord.statusInfoId},
            #{patrolRecord.routeId},
            #{patrolRecord.placeName},
            #{patrolRecord.patrolTime},
            #{patrolRecord.patrolUser},
            #{patrolRecord.patrolClass},
            #{patrolRecord.status})</foreach></insert>
  • 作者:ReSab
  • 原文链接:https://blog.csdn.net/qq_41895021/article/details/115758034
    更新时间:2022-07-11 07:56:25