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)
领取专属 10元无门槛券
私享最新 技术干货