学习文章:mybatis高效率批量update - liuxinyu123 - 博客园 (cnblogs.com)
mapper
package com.wanshun.configservice.cardatamodel.mapper;
import com.wanshun.common.mapper.CommonBaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Repository
@Mapper
public interface NoticeBaseinfoMapper extends CommonBaseMapper<NoticeBaseinfoDo> {
/**
*更新待生效的为已上架状态
* @param noticeIds
* @return
*/
int updateNoticeStatusEffect(@Param("noticeIds") List<Long> noticeIds);
}
xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD M