mybatis多条件批量更新update-设置多个字段值

1、controller前端控制器：

/**

*前端控制器

* @author qyf

* @since 2018-05-08

*/

@RestController

@Api(value = "/", description ="")

public class testController {

@Reference(timeout=5000)

private testService service;

@PostMapping(“test”)

@ApiOperation(value = “test”)

public Object test(@RequestBody Map data) {

return service.test(data);

}

}

2、service接口：

/**

*服务类

* @author qyf

* @since 2018-05-08

*/

public interface testService {

Object test(Map data);

}

3、serviceImpl接口实现类：

/**

*服务实现类

*@authorqyf

*@since2018-05-08

*/

@Component

@Service(interfaceClass = testService.class)

publicclasstestServiceImplimplementstestService {

@Autowired

privatetestMappermapper;

@Override

publicObject test(Mapdata) {

intrs=0;

try{

StringIDid=data.get("ID")==null?"":data.get("ID").toString();

Stringaccount=data.get("account")==null?"":data.get("account").toString();

if(IDid.length()==0) {

returnfaileResultMap("参数：ID不能为空");

}elseif(account.length()==0) {

returnfaileResultMap("参数：用户账号不能为空");

}else{

ListIDlist=newArrayList();

String[]strs=IDid.split(",");

for(inti=0,len=strs.length;i

IDlist.add(strs[i].toString());

}

rs=barcodeScanMapper.chooseconfirm(account,IDlist);

returnresult(rs);

}

}catch(Exceptione) {

e.printStackTrace();

returnresult(rs);

}

}

publicObject result(intrs) {

MapresultObj=newHashMap();

if(rs>0) {

resultObj.put("code","1");

resultObj.put("message","成功");

}else{

resultObj.put("code","0");

resultObj.put("message","失败");

}

returnresultObj;

}

}

4、mapper.java接口：

/**

* Mapper接口

* @author qyf

* @since 2018-05-08

*/

public interfacetestMapper{

int test(@Param("account") String account,@Param("IDlist") List IDlist);

}

5、mapper.xml

UPDATE Mst_BarcodeScan SETconfirmuser=#,confirmdate=NOW() WHERE ID in

#

原生sql语句：

UPDATE Mst_BarcodeScan SETconfirmuser='test',confirmdate=NOW() WHERE ID in (1,3,5)