当存在外键约束时,如何从MySQL表中删除行?

我试图通过从表中删除an条目 http://localhost/phpmyadmin 。 它返回了以下错误:

“无法删除或更新父行:外键约束失败( press 。 prodstock 限制 fk_prodstock_prodlist1 外键( item_code )参考文献 prodlist ( id )删除时无操作更新时无操作)”

我编写了一段JAVA代码,将其从NetBeans中删除:

 private void loginBut46ActionPerformed(java.awt.event.ActionEvent evt) {                                           
    if (prodlist.getSelectedRowCount() == 0) {

            JOptionPane.showMessageDialog(rootPane, "Select Raw to View!");

        } else {
            int r = prodlist.getSelectedRow();
            String id = prodlist.getValueAt(r,0).toString();
            String item_code = prodlist.getValueAt(r,1).toString();
        try {
           DB.DB.statement("delete from prodlist where id = '"+id+"' ");
            DB.DB.statement("delete from prodstock where item_code='"+item_code+"'");
        } catch (Exception ex) {
            Logger.getLogger(Stock.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    }