mybatis insert foreach

最新推荐文章于 2024-04-11 15:00:53 发布

ReSab

最新推荐文章于 2024-04-11 15:00:53 发布

阅读量3.6k

点赞数

分类专栏： ssm

本文链接：https://blog.csdn.net/qq_41895021/article/details/115758034

版权

ssm 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

本文探讨了在使用MyBatis进行批量插入时遇到的'Parameter 'statusInfoId' not found'错误，通过实例展示了如何正确设置参数类型和foreach标签，确保mapper接口和SQL语句的匹配，避免此类常见问题。

摘要由CSDN通过智能技术生成

项目场景：

报错，找不到参数
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> {

    int insertList(@Param(value = "list") List<PatrolRecord> list);
}

mapper 换了很多种写法

    <insert id="insertList" parameterType="com.iricto.soft.patrol.entity.PatrolRecord">
        insert into patrol_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 into patrol_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 into patrol_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>