package?com.hxd.sqlAbout;
import?com.baomidou.mybatisplus.core.injector.AbstractMethod;
import?com.baomidou.mybatisplus.core.metadata.TableInfo;
import?org.apache.ibatis.mapping.MappedStatement;
import?org.apache.ibatis.mapping.SqlSource;
public?class?DeleteAllMethod?extends?AbstractMethod?{
????@Override
????public?MappedStatement?injectMappedStatement(Class<?>?mapperClass,?Class<?>?modelClass,?TableInfo?tableInfo)?{
????????String?sql="delete?from?"+tableInfo.getTableName();
????????String?method="deleteAll";
????????SqlSource?sqlSource?=?languageDriver.createSqlSource(configuration,?sql,?modelClass);
????????return?addDeleteMappedStatement(mapperClass,method,sqlSource);
????}
}
package?com.hxd.sqlAbout;
import?com.baomidou.mybatisplus.core.injector.AbstractMethod;
import?com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
import?com.baomidou.mybatisplus.core.injector.methods.*;
import?org.springframework.stereotype.Component;
import?java.util.List;
@Component
public?class?SqlInjector?extends?DefaultSqlInjector?{
????@Override
????public?List<AbstractMethod>?getMethodList(Class<?>?mapperClass)?{
????????List<AbstractMethod>?methodList?=?super.getMethodList(mapperClass);
????????methodList.add(new?DeleteAllMethod());
????????return?methodList;
????}
}
package?com.hxd.mapper;
import?com.baomidou.mybatisplus.core.mapper.BaseMapper;
import?com.hxd.pojo.User;
import?org.springframework.stereotype.Repository;
@Repository
public?interface?UserMapper?extends?BaseMapper<User>?{
?int?deleteAll();
}
@RequestMapping("deletealluser")
public?String?deleteAllUser(){
????int?i=?userService.deleteAllUser();
????if(i>0){
????????return?"刪除所有成功";
????}
????return?"刪除所有失敗";
}
public?int?deleteAllUser()?{
????int?i?=?userMapper.deleteAll();
????return?i;
}

2020-05-28
你這個(gè)問(wèn)題,看著提示信息,應(yīng)該不是程序的問(wèn)題,而是因?yàn)閿?shù)據(jù)庫(kù)外鍵的問(wèn)題,你刪除所有數(shù)據(jù),由于有的數(shù)據(jù)行有外鍵的約束,不允許你進(jìn)行物理刪除。
2020-07-10