ResultSet res = null;
try {
smt = connection.createStatement();
res = smt.executeQuery("select idVille, nomVille, tpays.idPays, tpays.codePays from TVille, tpays where tpays.idPays = tville.idPays and idVille = LAST_INSERT_ID()");
if (res.next()) {
result[0] = new Ville(res.getInt(1));
result[0].setNomVille(res.getString(2));
Pays pays = new Pays(res.getInt(3));
pays.setCode(res.getString(4));
result[0].setPays(pays);