连接到MySQL的java JDBC一直告诉我我正在打破外键约束?什么?
好吧,所以我一直得到这个错误:
通用域名格式。mysql。jdbc。例外。jdbc4。MySQLIntegrityConstraintViolationException:无法删除或更新父行:外键约束失败
这真的很令人沮丧,我不知道为什么?我所做的只是将外键分配给另一个表(确切地说是books表)中的主键。任何指点都将不胜感激
//create patron table
s.executeUpdate ("DROP TABLE IF EXISTS patron");
s.executeUpdate (
"CREATE TABLE patron ("
+ "patron_ID CHAR(10),"
+ "PRIMARY KEY (patron_ID),"
+ "fName CHAR(50)NOT NULL, MI CHAR(2), lName CHAR(75)NOT NULL,"
+ "street_Name CHAR(100)NOT NULL, city CHAR(50) NOT NULL, state CHAR(50)NOT NULL,"
+ "zip_Code CHAR(10) NOT NULL, home_Phone CHAR(12)NOT NULL, call_Number CHAR(10)NOT NULL,"
//+ "FOREIGN KEY (call_Number) references corejava.book(call_Number))");
+ "FOREIGN KEY (call_Number) references " + dbName + ".book (call_Number))");
count2 = s.executeUpdate (
"INSERT INTO patron"
+ " VALUES"
+ "('P222200000', 'Harry', 'P','Bradford','1234 Street Place','Silver Spring','Maryland','20906','301-555-9999','MY.111.0001'),"
+ "('P222200001', 'Sally','','Titus','2365 Huckleberry Lane','Silver Spring','Maryland','20906','301-554-9896','SF.111.002'),"
+ "('P222200002', 'Mark', 'C','Bradley','654 Finance Lane','Silver Spring','Maryland','20906','301-665-4978','AV.111.004'),"
+ "('P222200003', 'Carlos','','Iglesias','987 Potter Place','Silver Spring','Maryland','20906','240-702-5648','CO.111.006'),"
+ "('P222200004', 'Chris','','Craig','951 Einstein Way','Silver Spring','Maryland','20906','301-569-4415','IN.111.008'),"
+ "('P222200005', 'Samantha','A','Brikmon',' 8380 Colesville Road','Silver Spring','20906','301-659-5569','CO.111.007'),"
+ "('P222200006', 'Lindsey', '','Saucer','12507 Winexburg Manor Drive','Silver Spring','Maryland','20906','301-632-6635','SF.111.003'),"
+ "('P222200007', 'Judy', 'A','Freud','2518 Woodedge Road','Glenmont','Maryland','20905','240-985-9632','AV.111.005'),"
+ "('P222200008', 'Elizabeth','M','Longhorn','552 Lockwood Drive','Wheaton','Maryland','20904','202-555-6639','IN.111.009'),"
+ "('P222200009', 'Gabriella', 'S','Young','654 Glenallen Road','Silver Spring','Maryland','20906','301-555-9898','MY.111.000')");
System.out.println (count2 + " rows were inserted");
s.close();
共 (0) 个答案