Ejb, lomboz et collection

/* 
* Created on 28 juin 2005 
* 
* TODO To change the template for this generated file go to 
* Window - Preferences - Java - Code Style - Code Templates 
*/ 
package serviceCommercial; 

import java.sql.ResultSet; 
import java.util.Collection; 
import java.util.HashSet; 

import javax.ejb.SessionBean; 

import odbc.ODBCConnect; 

/** 
* 
* <!-- begin-user-doc --> A generated session bean <!-- end-user-doc --> * 
<!-- lomboz.beginDefinition --> 
<?xml version="1.0" encoding="UTF-8"?> 
<lomboz:EJB xmlns:j2ee="http://java.sun.com/xml/ns/j2ee" xmlns:lomboz="http://lomboz.objectlearn.com/xml/lomboz"> 
<lomboz:session> 
<lomboz:sessionEjb> 
<j2ee:display-name>Lister</j2ee:display-name> 
<j2ee:ejb-name>Lister</j2ee:ejb-name> 
<j2ee:ejb-class>serviceCommercial.ListerBean</j2ee:ejb-class> 
<j2ee:session-type>Stateless</j2ee:session-type> 
<j2ee:transaction-type>Container</j2ee:transaction-type> 
</lomboz:sessionEjb> 
</lomboz:session> 
</lomboz:EJB> 
<!-- lomboz.endDefinition --> 
* 
* <!-- begin-xdoclet-definition --> 
* @ejb.bean name="Lister" 
* jndi-name="Lister" 
* type="Stateless" 
* transaction-type="Container" 
* 
*-- 
* This is needed for JOnAS. 
* If you are not using JOnAS you can safely remove the tags below. 
* @jonas.bean ejb-name="Lister" 
* jndi-name="Lister" 
* 
*-- 
* <!-- end-xdoclet-definition --> 
* @generated 
*/ 
public abstract class ListerBean implements SessionBean { 

/** 
* @ejb.interface-method 
* view-type="remote" 
**/ 
public Collection getListe(){ 

Collection listeVentes = new HashSet(); 

odbc.ODBCConnect baseServiceComm = new ODBCConnect(); 
baseServiceComm.connectage("ServiceCommercial"); 
System.out.println("avant GS"); 
baseServiceComm.getStatement(); 
ResultSet res = baseServiceComm.ExecuteQ("SELECT * FROM VENTES"); 

try 
{ 
System.out.println("avant while"); 
while (res.next()) 
{ 
System.out.println("while"); 
VenteBean uneVente = new VenteBean(); 
uneVente.setNVendeur(res.getInt(1)); 
uneVente.setTrimestre(res.getInt(2)); 
uneVente.setAnnee(res.getInt(3)); 
uneVente.setCAHT(res.getInt(4)); 

listeVentes.add(uneVente); 
} 
System.out.println("après boucle"); 
System.out.println("taille = " + listeVentes.size()); 
} 
catch (Exception e) 
{ 
System.out.println("Erreur"); 
} 
baseServiceComm.fermeture(); 

return listeVentes; 
} 
/** 
* @ejb.interface-method 
* view-type="remote" 
**/ 
public void getLeon(){ 
Collection listeVentes = new HashSet(); 

odbc.ODBCConnect baseServiceComm = new ODBCConnect(); 
baseServiceComm.connectage("ServiceCommercial"); 
System.out.println("avant GS"); 
baseServiceComm.getStatement(); 
ResultSet res = baseServiceComm.ExecuteQ("SELECT * FROM VENTES"); 

try 
{ 
System.out.println("avant while"); 
while (res.next()) 
{ 
System.out.println("while"); 
VenteBean uneVente = new VenteBean(); 
uneVente.setNVendeur(res.getInt(1)); 
uneVente.setTrimestre(res.getInt(2)); 
uneVente.setAnnee(res.getInt(3)); 
uneVente.setCAHT(res.getInt(4)); 

listeVentes.add(uneVente); 
} 
System.out.println("après boucle"); 
System.out.println("taille = " + listeVentes.size()); 
} 
catch (Exception e) 
{ 
System.out.println("Erreur"); 
} 
baseServiceComm.fermeture(); 

} 
/** 
* @ejb.interface-method 
* view-type="remote" 
**/ 
public int getInt(){ 
Collection listeVentes = new HashSet(); 

odbc.ODBCConnect baseServiceComm = new ODBCConnect(); 
baseServiceComm.connectage("ServiceCommercial"); 
System.out.println("avant GS"); 
baseServiceComm.getStatement(); 
ResultSet res = baseServiceComm.ExecuteQ("SELECT * FROM VENTES"); 

try 
{ 
System.out.println("avant while"); 
while (res.next()) 
{ 
System.out.println("while"); 
VenteBean uneVente = new VenteBean(); 
uneVente.setNVendeur(res.getInt(1)); 
uneVente.setTrimestre(res.getInt(2)); 
uneVente.setAnnee(res.getInt(3)); 
uneVente.setCAHT(res.getInt(4)); 

listeVentes.add(uneVente); 
} 
System.out.println("après boucle"); 
System.out.println("taille = " + listeVentes.size()); 
} 
catch (Exception e) 
{ 
System.out.println("Erreur"); 
} 
baseServiceComm.fermeture(); 

return listeVentes.size(); 
} 
/** 
* @ejb.interface-method 
* view-type="remote" 
**/ 
public VenteBean getVenteBean(){ 
Collection listeVentes = new HashSet(); 

odbc.ODBCConnect baseServiceComm = new ODBCConnect(); 
baseServiceComm.connectage("ServiceCommercial"); 
System.out.println("avant GS"); 
baseServiceComm.getStatement(); 
ResultSet res = baseServiceComm.ExecuteQ("SELECT * FROM VENTES"); 

try 
{ 
System.out.println("avant while"); 
while (res.next()) 
{ 
System.out.println("while"); 
VenteBean uneVente = new VenteBean(); 
uneVente.setNVendeur(res.getInt(1)); 
uneVente.setTrimestre(res.getInt(2)); 
uneVente.setAnnee(res.getInt(3)); 
uneVente.setCAHT(res.getInt(4)); 

listeVentes.add(uneVente); 
} 
System.out.println("après boucle"); 
System.out.println("taille = " + listeVentes.size()); 
} 
catch (Exception e) 
{ 
System.out.println("Erreur"); 
} 
baseServiceComm.fermeture(); 
return new VenteBean(); 
} 
} 

 
/* 
* Created on 2 juin 2005 
* 
* TODO To change the template for this generated file go to 
* Window - Preferences - Java - Code Style - Code Templates 
*/ 
package serviceCommercial; 

import java.io.Serializable; 

/** 
* @author Administrateur 
* 
* TODO To change the template for this generated type comment go to 
* Window - Preferences - Java - Code Style - Code Templates 
*/ 
public class VenteBean implements Serializable{ 

private int nVendeur; 
private int trimestre; 
private int annee; 
private int CAHT; 

public VenteBean() 
{ 
super(); 
} 

public void setNVendeur(int _vendeur) 
{ 
nVendeur = _vendeur; 
} 

public void setTrimestre(int _trimestre) 
{ 
trimestre = _trimestre; 
} 

public void setAnnee(int _annee) 
{ 
annee = _annee; 
} 

public void setCAHT(int _CAHT) 
{ 
CAHT = _CAHT; 
} 

public int getNVendeur() 
{ 
return nVendeur; 
} 

public int getTrimestre() 
{ 
return trimestre; 
} 

public int getAnnee() 
{ 
return annee; 
} 

public int getCAHT() 
{ 
return CAHT; 
} 

}