public static List<Ville> rechercheVilleByCp(String name) throws SQLException {

        String query = null;
        List<Ville> ville1 = new ArrayList<Ville>();
        ResultSet resultat;

        try {
            query = "SELECT  * from VILLE   where VICP like ? order by VINOM asc";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setString(1, name.toUpperCase() + "%");
            //System.out.println(pStatement);
            resultat = pStatement.executeQuery();

            while (resultat.next()) {
                Ville vv = new Ville(resultat.getInt("ID_VILLE"), resultat.getInt("ID_PAYS"), resultat.getString("VINOM"), resultat.getString("VICP"));
                ville1.add(vv);
            }

        } catch (SQLException ex) {
            Logger.getLogger(RequetesVille.class.getName()).log(Level.SEVERE, null, ex);

        }

        return ville1;
    }