A voir également:
- Ejb, lomboz et collection
- Kick collection avis ✓ - Forum Consommation et internet
- Télécharger gratuitement harlequin collection azur mai 2013 ✓ - Forum Téléchargement
- Logiciel collection timbres gratuit - Télécharger - Vie quotidienne
- Driver collection avis ✓ - Forum Internet / Réseaux sociaux
- Sims 2 ultimate collection français ✓ - Forum Jeux vidéo
1 réponse
Ci-dessous le code des fichiers "ListerBean.java" et "VenteBean.java"
********************ListerBean.java*********************
********************VenteBean.java*********************
********************ListerBean.java*********************
/* * 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(); } }
********************VenteBean.java*********************
/*
* 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;
}
}