MyBatis传入数组批量更新

Mapper类

	int batchDel(@Param("ids")java.lang.String[] ids);

Maper.XML

这里的item要和Mapper类里的**@Param(“ids”)**一致，如果没有要写入array

	<update id="batchDel">
        UPDATE `user` SET `is_valid` = 0 WHERE `user_id` in
        <foreach collection="ids" item="ids" open="(" separator="," close=")">
            #{ids}
        </foreach>
    </update>

Service类

public int batchDel(java.lang.String[] ids){
        return userMapper.batchDel(ids);
    }

Controller

直接将接收的值返回即可

/**
     * 批量删除用户
     * @author Devil
     * @param ids 用户ID数组
     * @return int 返回执行成功的行数
     * String[] ids = new String[]{"3e776492e7ed11eb8171d8cb8ad43d4o","3e776492e7ed11eb8171d8cb8ad43d4s"};
     */
    @PostMapping("/batchDel")
    public APIResult<Integer> batchDel(java.lang.String[] ids){
        return APIResult.ok(userService.batchDel(ids));
    }

application.yml

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql:///shop?useUnicode=true&characterEncoding=utf8&autoReconnect=true&rewriteBatchedStatements=TRUE&useSSL=false&useAffectedRows=true&characterEncoding=utf-8
    driver-class-name: com.mysql.jdbc.Driver
mybatis:
  mapper-locations: classpath:mapper/*.xml
#  sql语句在控制台打印
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
server:
  port: 8080
  servlet:
    context-path: /api

---