MyBatis根据条件批量修改字段的方式.docxVIP

第

MyBatis根据条件批量修改字段的方式

目录MyBatis根据条件批量修改字段代码以及注释MyBatis多条件批量修改简单记录下总结

MyBatis根据条件批量修改字段

背景：

给学生改作业，只要是对的都批量进行数据库的修改

代码以及注释

conttoller

@RestController

@RequestMapping(/work)

publicclassWorkController{

???@Autowired

???privateWorkServiceworkService;

???@PutMapping(/examine)

???publicHttpResponseexamine(Integer[]id){

??????Integertotal=workService.examine(id);

??????returnHttpResponse.ok(共批改[+total+]条道题,);

???}

}

service

@Service

publicclassWorkService{

???@Autowired

???privateWorkMapperworkMapper;

???publicIntegerexamine(Integer[]id){

??????returnworkMapper.examine(id);

???}

}

mapper

@Mapper

publicinterfaceWorkMapper{

???Integerexamine(@Param(id)Integer[]id);

}

!--根据id来批量修改WORK表里面的isEnable字段--

updateid=examine

???UPDATEWORKSETisEnable=TRUEWHEREidIN

???foreachcollection=iditem=idseparator=,open=(close=)

??????#{id}

???/foreach

/update

工具类HttpResponse(此需求中无关紧要的类)

publicclassHttpResponse{

???privateIntegerstatus;

???privateStringmessage;

???privateObjectobject;

???publicstaticHttpResponseok(Stringmessage){

??????returnnewHttpResponse(200,message,null);

???}

???publicstaticHttpResponseok(Objectobject){

??????returnnewHttpResponse(200,null,object);

???}

???publicstaticHttpResponseok(Stringmessage,Objectobject){

??????returnnewHttpResponse(200,message,object);

???}

???publicstaticHttpResponseerror(Integerstatus,Stringmessage){

??????returnnewHttpResponse(500,message,null);

???}

???publicstaticHttpResponseerror(Stringmessage){

??????returnnewHttpResponse(500,message,null);

???}

???publicstaticHttpResponseerror(Stringmessage,Objectobject){

??????returnnewHttpResponse(500,message,object);

???}

???protectedHttpResponse(){

??????super();

???}

???privateHttpResponse(Integerstatus,Stringmessage,Objectobject){

??????super();

??????this.status=status;

??????this.message=mess