Mybatis批量插入

林雨涵

已于 2023-05-30 10:27:43 修改

阅读量676

点赞数

分类专栏： Mybatis-Plus 文章标签： java mybatis

于 2021-12-18 10:40:42 首次发布

本文链接：https://blog.csdn.net/qq_43718048/article/details/121942481

版权

Mybatis-Plus 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

批量插入List的属性

int insertTakeGoodsType(@Param(value = "goodsId") Long goodsId, @Param(value = "goodsTakeMode") List<Integer> goodsTakeMode);

    <insert id="insertTakeGoodsType" >
        insert into t_goods_take_mode(goods_id, take_goods_mode) values
        <foreach collection="param2" item="item" index="index" separator=",">
            <if test="item != null">
                (#{param1},#{item})
            </if>
        </foreach>
    </insert>

批量插入List<对象>的属性

int insertGoodsSpe(@Param(value = "goodsId") Long goodsId, @Param(value = "goodsSpecificationDbDTOs") List<GoodsSpecificationDbDto> goodsSpecificationDbDTOs , @Param(value = "date") Date date);

    <insert id="insertGoodsSpe">
        insert into t_goods_specification(goods_id, spe_url, spe_name, spe_price, spe_stock, limit_buy, state, create_time, update_time) values
        <foreach collection="param2" item="item" index="index" separator=",">
            <if test="item != null">
                (#{param1}, #{item.speUrl}, #{item.speName}, #{item.spePrice}, #{item.speStock}, #{item.limitBuy}, #{item.state}, #{param3} ,#{param3})
            </if>
        </foreach>
    </insert>

a.colum in ()


   public List<PigFarmInfoVo> selectPigFarmInfoRemindVOList(@Param("farmTypes") List<String> farmTypes,
                                                             @Param("nowDate") Date nowDate);
                                                             
    <select id="selectPigFarmInfoRemindVOList" resultType="com.higentec.system.domain.pig.vo.PigFarmInfoVo">
    select <include refid="entity"/>, b.phonenumber, c.corral_id, d.corral_name
        ,datediff(#{nowDate}, e.farm_date) as pig_birth_day
        from pig_farm_info a
            left join sys_user b on a.farm_user_id = b.user_id
            left join pig_farm_corral c on c.farm_id = a.id
            left join pig_corral_info d on d.id = c.corral_id
            left join pig_batch_no e on d.id = e.corral_id
        where a.farm_status = '0'
            and a.farm_type in
                 <foreach item="item" collection="param1" open="(" separator="," close=")">
                    <if test="item != null and item != ''">
                        #{item}
                    </if>
                 </foreach>
    </select>