try {
smt = connection.prepareStatement(GET_PAYS_BY_CODE);
smt.setString(1, codePays);
res = smt.executeQuery();
if (res.next()) {
result[0] = new Pays(res.getInt(1));
result[0].setCode(res.getString(2));
result[0].setNom(res.getString(3));
}
} finally {
try {