mybatics批量更改

controller

@ApiOperation(value ="批量更改审核及删除状态", notes ="批量更改审核及删除状态")

@ApiResponses({@ApiResponse(code =200, message ="操作成功", response = ResponseBodyDto.class)})

@ApiImplicitParam(name="ids",value ="逗号拼接id",dataType ="String",paramType ="query",example ="1,2",required=true)

@RequestMapping(value ="/batchUpdateVessel", method = RequestMethod.GET)

@ResponseBody

public ResponseBodyDto batchUpdateVessel(String ids,String state,String isDelete) {

String[] idStr = ids.split(",");

List list =new ArrayList();

for (String id : idStr) {

list.add(id);

}

int result=vesselService.batchUpdateVessel(list,state,isDelete);

if(result>0){

for (String id : idStr) {

Vessel vessel1=vesselService.selectVesselDetail(Long.parseLong(id));

if (vessel1!=null){

elasticSearch.writeDataToES("vessel","docs", JSON.toJSONString(vessel1));

}

}

}

return new ResponseBodyDto<>(result);

}

service

int batchUpdateVessel(List list, String state,String isDelete);

mapper

int batchUpdateVessel(@Param("ids") List ids,@Param("state") String state,@Param("isDelete")String isDelete);

sql

<update id="batchUpdateVessel">

update `vessel`

set `updated_at`= now(),

<if test="state != null" >

state = #{state,jdbcType=BIT}

</if>

<if test="isDelete != null" >

is_delete = #{isDelete,jdbcType=BIT}

</if>

where `id` in

<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">

${item}

</foreach>

</update>