Exclusion involving Java and SQL

Question

The program I’m doing requires a deletion of users from the bank!

In the code I determine:

Menu:

static private void Excluir(Connection con) throws SQLException
{
    String cpf;
    Scanner s = new Scanner(System.in);
    Cliente cli = new Cliente();

    System.out.println("Informe o CPF a ser Excluido:");
    cli.cpf = s.next();
    System.out.println();
    cli.ExcluirPess(cli, con);
}

In client class I determine:

public void ExcluirPess(Cliente cli, Connection con) throws SQLException {
      String sql = "delete from Cliente where CPF_cliente = ?"; 
      PreparedStatement stmt = con.prepareStatement(sql);  
      stmt.setString(1, cli.getCpf());
      stmt.executeUpdate();
      stmt.close();
}   

I tidied as demonstrated, but the exclusion is not yet made! The fact where in the bank to PK CPF_cliente was FK in Endereco and Telefone, interferes with the exclusion?

Answer 1

You must add the parameter and then run your Preparedstatement.

String sql = "delete from Cliente where CPF_cliente = ?"; 
PreparedStatement stmt = con.prepareStatement(sql);  
stmt.setString(1, cli.cpf);
stmt.executeUpdate();

The fact that in the bank the PK Cpf_client is FK in Address and Phone, interferes with the deletion?

Of course, the database does not allow you to make such a deletion so as not to generate an inconsistency in the database, otherwise the Address and Telephone tables would have a foreign key that does not exist in the Client table.

To fix, first delete the records in the tables that have the foreign key and finally delete the record in the Client table.