第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定

老師我按照你寫的進(jìn)行測(cè)試出現(xiàn)了如下問(wèn)題,麻煩老師幫我看一下代碼如下

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;
}

http://img1.sycdn.imooc.com//5ecccd0700012d8619160380.jpg

正在回答

2 回答

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

1 回復(fù) 有任何疑惑可以回復(fù)我~
*?Consume?Time:42?ms?2020-07-10?14:18:43
*??Execute?SQL:delete?from?users
*?org.springframework.dao.DataIntegrityViolationException:
*?###?Error?updating?database.??Cause:?java.sql.SQLIntegrityConstraintViolationException:
*?Cannot?delete?or?update?a?parent?row:?a?foreign?key?constraint?fails?(`mp`.`users`,?CONSTRAINT?`manager_fks`?FOREIGN?KEY?(`manager_id`)?REFERENCES?`users`?(`id`)
*?當(dāng)因?yàn)橥怄I發(fā)生報(bào)錯(cuò)時(shí):
*?問(wèn)題主要是刪除記錄的時(shí)候刪不了,最后發(fā)現(xiàn)是中間表的外鍵默認(rèn)刪除時(shí)是RESTRICT,
*???當(dāng)取值為No?Action或者Restrict時(shí),則當(dāng)在父表(即外鍵的來(lái)源表)中刪除對(duì)應(yīng)記錄時(shí),首先檢查該記錄是否有對(duì)應(yīng)外鍵,如果有則不允許刪除。
*???當(dāng)取值為Cascade時(shí),則當(dāng)在父表(即外鍵的來(lái)源表)中刪除對(duì)應(yīng)記錄時(shí),首先檢查該記錄是否有對(duì)應(yīng)外鍵,如果有則也刪除外鍵在子表(即包含外鍵的表)中的記錄。
*???當(dāng)取值為Set?Null時(shí),則當(dāng)在父表(即外鍵的來(lái)源表)中刪除對(duì)應(yīng)記錄時(shí),首先檢查該記錄是否有對(duì)應(yīng)外鍵,如果有則設(shè)置子表中該外鍵值為null(不過(guò)這就要求該外鍵允許取null)。
*???解決:??把外鍵字段原來(lái)默認(rèn)的Restrict改成CASCADE即可


1 回復(fù) 有任何疑惑可以回復(fù)我~

舉報(bào)

0/150
提交
取消

老師我按照你寫的進(jìn)行測(cè)試出現(xiàn)了如下問(wèn)題,麻煩老師幫我看一下代碼如下

我要回答 關(guān)注問(wèn)題
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)