public static void updatePays(int id, String pays) throws SQLException {
        int result;
        String query;
        try {
            query = "UPDATE PAYS set PAYS=? WHERE ID_PAYS=?";
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setString(1, pays);
            pStatement.setInt(2, id);
            pStatement.executeUpdate();
           
        } catch (SQLException ex) {
            Logger.getLogger(RequetesPays.class.getName()).log(Level.SEVERE, null, ex);
            
        }
       
    }