Mybatis的批量操作增删改查

参考：连接

xml的写法

//根据id查
 <select id="findMoreByalumniUserId" parameterType="int" resultMap="BaseResultMap">
        select *
        from exchange_news
        <foreach close=")" collection="array" item="ids" open="(" separator=",">
            #{ids}
        </foreach>
    </select>
    //对象批量修改
    <update id="updateMoreExchangeNews" parameterType="java.util.List">
        <foreach collection="list" item="item" index="index">
            update exchange_news
            set receiver_alumniuser_id=#{item.receiverAlumniuserId}
            where 1=1 and exchange_news_id=#{item.exchangeNewsId}
        </foreach>
    </update>
//批量新增
    <insert id="bashInsertExchangeNews" parameterType="java.util.List">
        insert into exchange_news (exchanger_id, receiver_alumniuser_id, leave_message, create_time, `status`) VALUES
        <foreach collection="list" separator="," item="item">
            (
            #{item.exchangerId,jdbcType=INTEGER},#{item.receiverAlumniuserId,jdbcType=VARCHAR},#{item.leaveMessage,jdbcType=VARCHAR},#{item.createTime,jdbcType=TIMESTAMP},#{item.status,jdbcType=TIMESTAMP})
        </foreach>

    </insert>
//批量删除
    <delete id="bashDeleteByid" parameterType="java.util.List">
        delete from exchange_news where exchange_news_id=
        <foreach close=")" collection="list" item="item" open="(" separator=",">
            #{item.exchangeNewsId}
        </foreach>
    </delete>

dao层

//批量根据id查
    List<ExchangeNews> findMoreByalumniUserId(@Param("ids") Integer[] ids);
//批量修改
    int updateMoreExchangeNews(List<ExchangeNews> exchangeNewsList);
//批量新增
    int bashInsertExchangeNews(List<ExchangeNews> listNews);
//批量删除
    int bashDeleteByid(List<ExchangeNews> newsList);