Mybatis-plus使用注解@Update时使用in批量操作的写法

mybatis-plus-boot-starter版本

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.3.0</version>
</dependency>

用法举例

import com.abc.ms.manager.order.entity.OrderInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.Set;

@Mapper
public interface OrderInfoMapper extends BaseMapper<OrderInfo> {

    @Update("<script>"
            + "update ORDER_INFO set TRACKING_STATUS=#{trackingStatus} ,  VERSION=VERSION+1, MODIFIED_TIME=CURRENT_TIMESTAMP  "
            + "where ORDER_ID in "
            + "<foreach item='id' index='index' collection='signdIds' open='(' separator=',' close=')'>"
            + "#{id}"
            + "</foreach>"
            + " and YN = 1"
            + "</script>")
    void batchUpdateTrackingStatus(@Param("signdIds") Set<String> signdIds, @Param("trackingStatus") String trackingStatus);

}

其中，OrderInfo类是实体类，里面配置了表已经字段影视，如图：