Vue实现表格批量审核功能实例代码

<!--审核服务信息-->
<update id="auditServers" parameterType="java.util.List">
update sdcp_serv
SET ISAUDITED ='1'
where servid in
<foreach collection="list" index="index" item="item"
separator="," open="(" close=")">
#{item,jdbcType=VARCHAR}
</foreach>
</update>

2.2 mapper.java(对应的接口)

int auditServers(List<String> servids);

2.3 controller

/**
 * @Description: 批量审核服务信息
 * @param @param map
 * @param @return
 * @param @throws Exception  参数
 * @return Object  返回类型
 */
    @RequestMapping(value = "/auditServers", method = RequestMethod.POST)
    public Object auditServers(@RequestBody Map<String, Object> map) throws Exception {
      if (map.get("serverIds")!=null){
        String serverIds = (String) map.get("serverIds");
        List<String> ids = Arrays.asList(serverIds.split(","));
        apiServerMapper.auditServers(ids);
      }
      return ResponseData.success("服务信息修改成功");
 }