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;
}
}
}
|