Question

java往数据库添加信息的时候报了这个错误

[com.j256.ormlite.stmt.mapped.BaseMappedStatement] - <insert data with statement 'INSERT INTO `zqbp_custom` (`CUSTOM_ID` ,`CUSTOM_NAME` ,`CUSTOM_ADDRESS` ,`CUSTOM_TEL` ,`CUSTOM_TRADE` ,`CREATE_TIME` ,`CREATE_USER` ,`status` ) VALUES (?,?,?,?,?,?,?,?)' and 8 args, threw exception: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`zqbp`.`zqbp_custom`, CONSTRAINT `zqbp_custom_ibfk_1` FOREIGN KEY (`custom_trade`) REFERENCES `zqbp_industry` (`industry_id`))>

Answer 1

Cannot add or update a child row: a foreign key constraint fails：由于外键约束，导致添加或者更新失败。因为你插入的语句中有一字段存在外键约束键好，当其引用的主表中的字段中毕亮碧没有手举你插入的值是报这个错误，需要先在主表字段中插入该值