有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

连接到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) 个答案