MyBatis实现数据的批量新增和删除的操作

package com.pjb.mapper; 
import com.pjb.entity.UserInfo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository; 
import java.util.List;
 
/**
 * 用户信息Mapper动态代理接口
 * @author pan_junbiao
 **/
@Repository
public interface UserMapper
{
 /**
 * 批量新增用户
 */
 @Insert({""})
 public int addUserBatch(@Param("userInfoList") List userInfoList);
 
 /**
 * 批量删除用户
 */
 @Delete({""})
 public int deleteUserBatch(int[] userIds);
 
 /**
 * 批量获取用户
 */
 @Select({""})
 public List getUserBatch(int[] userIds);
}

@Autowired
private UserMapper userMapper;
 
/**
 * 批量新增用户
 * @author pan_junbiao
 */
@Test
public void addUserBatch()
{
 //创建新用户列表
 List userInfoList = new ArrayList();
 userInfoList.add(new UserInfo("pan_junbiao的博客_01","您好，欢迎访问 pan_junbiao的博客"));
 userInfoList.add(new UserInfo("pan_junbiao的博客_02","https://blog.csdn.net/pan_junbiao"));
 userInfoList.add(new UserInfo("pan_junbiao的博客_03","您好，欢迎访问 pan_junbiao的博客"));
 userInfoList.add(new UserInfo("pan_junbiao的博客_04","https://blog.csdn.net/pan_junbiao"));
 userInfoList.add(new UserInfo("pan_junbiao的博客_05","您好，欢迎访问 pan_junbiao的博客"));
 
 //执行批量新增操作
 int count = userMapper.addUserBatch(userInfoList);
 
 //打印结果
 System.out.println("执行结果：成功新增" + count + "条数据！");
}

@Autowired
private UserMapper userMapper;
 
/**
 * 批量获取用户
 * @author pan_junbiao
 */
@Test
public void getUserBatch()
{
 //用户编号数组
 int[] userIds = new int[]{1,2,3,4,5};
 
 //执行批量获取操作
 List userInfoList = userMapper.getUserBatch(userIds);
 
 //打印结果
 userInfoList.stream().forEach(System.out::println);
}

@Autowired
private UserMapper userMapper;
 
/**
 * 批量删除用户
 * @author pan_junbiao
 */
@Test
public void deleteUserBatch()
{
 //用户编号数组
 int[] userIds = new int[]{1,2,3,4,5};
 
 //执行批量删除操作
 int count = userMapper.deleteUserBatch(userIds);
 
 //打印结果
 System.out.println("执行结果：成功删除" + count + "条数据！");
}

 

 INSERT INTO YIBO_SYS_CONTENT_ROLE (ROLE_ID,CONTENT_ID) VALUES (#{item.roleId,jdbcType=NUMERIC},#{item.contentId,jdbcType=VARCHAR}) 
 

 
 select * from t_blog where id in
 
 #{item} 
  
 

 select CONTENT_ID from YIBO_SYS_CONTENT_ROLE where ROLE_ID=#{roleId}

  
 
 delete from YIBO_SYS_CONTENT_ROLE
 where
 ROLE_ID=#{item.roleId} and CONTENT_ID=#{item.contentId}