//-------------------------------------------------------------------------
    static void consulterClientRepetition(Connection c) 
	throws SQLException {
	System.out.println("ici consulterVillagesClientRepetition");

        String texte =
	    "select village.idv, ville, activite,prix, capacite\n"
	    +"from village, sejour\n"
	    +"where village.idv = sejour.idv and idc = ?";
        System.out.println(texte);
	PreparedStatement stmt = c.prepareStatement(texte);

	while (Integer.parseInt(lireClavier("on continue (1/0) ? "))==1) {
	    int ic = Integer.parseInt(lireClavier("identifiant client ? "));
	    stmt.setInt(1, ic);
	    ResultSet r = stmt.executeQuery();
	    while (r.next())
		System.out.println(r.getInt(1)+", "+r.getString(2)+", "
				   +r.getString(3)+", "+r.getInt(4)+", "
				   +r.getInt(5));
	    r.close();
	}
	stmt.close();
    }