删除多条数据:
Controller:
/**
* 删除多条数据
* @param ids
* @return
*/
@PostMapping(value = "/deletedsj")
public Result deletedsj(@RequestParam String ids){
new1Service.deletedsj(ids);
Result result = new Result(true,206,"删除多条数据操作执行成功!");
log.info("执行结果为:"+result);
return result;
}
Service:
/**
* 删除多条数据
* @param ids
*/
void deletedsj(String ids);
ServiceImpl:
/**
* 删除多条数据
* @param ids
* @return
*/
@Override
public void deletedsj(String ids) {
//通过“,”判断ids是否具有多条数据
if (ids.contains(",")){
//通过“,”分割成数组
String[] aa = ids.split(",");
List<Integer> ll =new ArrayList<>();
//遍历数据把数据放到集合中
for (String s : aa) {
int i =0;
//将String字符串转换成Integer整形数据
i = Integer.parseInt(s);
ll.add(i);
}
for (Integer id : ll) {
new1Dao.deletesj(id);
}
}else{
//如果只有一个id,直接进行删除
new1Dao.deletesj(Integer.parseInt(ids));
}
}
Dao:
/**
* 删除数据
* @param id
* @return
*/
boolean deletesj(int id);
Mapper:
<!-- 删除数据-->
<delete id="deletesj">
delete from new1 where id = #{id}
</delete>
运行结果: