suporte-luiz-henrique-jdev-jdbc

public void deleteFonesPorUser(Long idUser) {
    deleteFones(idUser);
    deleteUser(idUser);
}

private void deleteFones(Long idUser) {
    try {
        String fone = "DELETE FROM telefoneuser WHERE usuariopessoa = " + idUser;
        PreparedStatement preparedStatement = connection.prepareStatement(fone);
        preparedStatement.executeUpdate();
        connection.commit();
    } catch (Exception e) {
        System.out.println(e);
        try {
            connection.rollback();
        } catch (Exception e2) {
            System.out.println(e2);
        }
    }
}

private void deleteUser(Long idUser) {
    try {
        String user = "DELETE FROM userposjava WHERE id = " + idUser;
        PreparedStatement preparedStatement = connection.prepareStatement(user);
        preparedStatement.executeUpdate();
        connection.commit();
    } catch (Exception e) {
        System.out.println(e);
        try {
            connection.rollback();
        } catch (Exception e2) {
            System.out.println(e2);
        }
    }
}