mybatis批量修改

Mapper
void updateStatusAuto(@Param(value = "orderCodes") List orderCodes);

Mapper.xml
<update id="updateStatusAuto" parameterType="java.util.List">
    UPDATE
    表名
    SET
    trade_status = "98",
    order_state = "3"
    ...
    WHERE
    order_code
    IN
    <foreach separator="," index="index" item="name" collection="orderCodes" close=")" open="(">
        #{name}
    </foreach>
</update>