capture duplicity error in mysql with java

Question

I’m trying to show a message that there is already a registered id, but it falls in the catch that shows:

 com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'idusuario' 

i want to show that there is already a registered id.

 try {
        conexao=ConexaoBanco.conector();
        pst=conexao.prepareStatement(sql);
        pst.setString(1,nomeusuario);
        pst.setString(2,senha);  
        try{            
            pst.setInt(3,Integer.parseInt(idusuario));
        }catch(SQLException x){
            JOptionPane.showMessageDialog(null,"ID JÁ CADASTRADA");
        }
        pst.setString(4,perfil);     
        pst.setString(5,nome);          
        pst.executeUpdate();
        return true;
    } catch (SQLException e) {
        JOptionPane.showMessageDialog(null,e);
        return false;   
    }

( My username is login, so there is no confusion).

Answer 1

You are using Try/catch in the wrong place. The exception is thrown in the following line:

   pst.executeUpdate();

You can use the catch below to capture the most specific exception you want:

} catch (MySQLIntegrityConstraintViolationException e) {
     JOptionPane.showMessageDialog(null,"ID JÁ CADASTRADA");
} catch (SQLException e) {
     JOptionPane.showMessageDialog(null,e);
     return false;   
}