import java.io.*;
import java.sql.*;
import java.util.*;
/**
 * @version	1.0
 * @author Christian Massé
*/
public class TraitementPays{
   
 private Connection dbcon; 
 public TraitementPays() {
   super();
 }
 public ListePays getListe() {
 ListePays listeRetour = new ListePays();
 try
   {
   //Déclaration du driver :
   Class.forName("com.ibm.as400.access.AS400JDBCDriver");
   //Url de connexion
   String dbUrl = "jdbc:as400://AS400/BDVIN1";
   //Connexion à la BDD
   String user = "UUUUUUUU";
   String password = "PPPPP";
   dbcon = DriverManager.getConnection(dbUrl,user,password);
   Statement s = dbcon.createStatement();
   ResultSet rs = s.executeQuery("select * from bdvin1.pays");
  listeRetour.setCurseur(new Vector());
             
   while(rs.next())
   {
    Pays unPays = new Pays(); 
    unPays.setPaysCode(rs.getString("PAYS_CODE"));
    unPays.setPays(rs.getString("PAYS"));
   
    listeRetour.getCurseur().addElement(unPays);
   }
             
   rs.close();
   s.close();
   }
   catch (Exception e)
   {
   System.out.println(e.getMessage());
   } finally {
   return listeRetour;
   }
   }
}