Intégration JSF et Hibernate dans JOnAS 4.0.0/ Tomcat 5.0.21

POJOUtilisateur1.java :

package utilisateur1;

public class POJOUtilisateur1 {

        private long idUser;

        private String nom;

        private String prenom;

        private String password;

        private java.util.Date dateCM;

        private int isSupprimable;

        public void setIdUser (long _id)

                {

                idUser=_id;

                }

        public long getIdUser()

                {

                return idUser;

                }

        public void setNom (String _nom)

                {

                nom=_nom;

                }

        public String getNom()

                {

                return nom;

                }

        public void setPrenom (String _prenom)

                {

                prenom=_prenom;

                }

        public String getPrenom()

                {

                return prenom;

                }

        public void setPassword (String _password)

                {

                password=_password;

                }

        public String getPassword()

                {

                return password;

                }

        public void setDateCM (java.util.Date _date)

                {

                dateCM=_date;

                }

        public java.util.Date getDateCM()

                {

                return dateCM;

                }

        public void setIsSupprimable (int _isSup)

                {

                isSupprimable=_isSup;

                }

        public int getIsSupprimable()

                {

                return isSupprimable;

                }

}

javac utilisateur1/*.java

## PostgreSQL



hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect

hibernate.connection.driver_class org.postgresql.Driver

hibernate.connection.url jdbc:postgresql:essai

hibernate.connection.username pastjl

hibernate.connection.password

hibernate.connexion.pool_size 10

#hibernate.query.substitutions yes 'Y', no 'N'

POJOUtilisateur1.hbm.xml

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">



<hibernate-mapping>

 <class name="utilisateur1.POJOUtilisateur1" table="utilisateurs">

        <id name="idUser" type="long" unsaved-value="null" column ="iduser">

                <generator class="sequence"/>

        </id>

        <property name="nom" type="string"/>

        <property name="prenom" type="string"/>

        <property name="password" type="string"/>

        <property name="dateCM" type="timestamp" column="datecm"/>

        <property name="isSupprimable" type="integer" column="issupprimable"/>

 </class>

 </hibernate-mapping>

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

        "-//Hibernate/Hibernate Configuration DTD 2.0//EN"



 "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">



<hibernate-configuration>



    <!-- a SessionFactory instance listed as /jndi/name -->

    <session-factory ....>

        ....

        <!-- mapping files -->

        <mapping resource="POJOUtilisateur1.hbm.xml"/>

        ...



    </session-factory>



</hibernate-configuration>

ClientEx1.java

package utilisateur1;

import net.sf.hibernate.*;

import net.sf.hibernate.cfg.*;

public class ClientEx1

{

        public static void main(String [] argv) throws Exception, MappingException,

                                  HibernateException

        {

        Transaction tx=null;

        Session session=null;

        try

                {

                Configuration cfg = new Configuration()

                        .addClass(utilisateur1.POJOUtilisateur1.class);



                SessionFactory sessionFactory =   cfg.buildSessionFactory();

                // ouverture de la session

                session =sessionFactory.openSession();

                // Creation d'un user

                 

                 tx = session.beginTransaction();



                POJOUtilisateur1 util1=new POJOUtilisateur1();

                // on peuple l'objet util

                // mais pas la clé primaire, qui nous sera retournée par session.save();

                util1.setNom("Pasturel1");

                util1.setPrenom("jl1");

                util1.setPassword("pasturel1");

                util1.setDateCM(new java.util.Date());

                util1.setIsSupprimable(1);

                

                // on recupere la primary key

                Long id= (Long) session.save(util1);

                

                 tx.commit();

                

                System.out.println("Id sauvegarde = "+id.toString());

                }

        

         catch (Exception e) {

                        if (tx!=null) tx.rollback();

                        throw e;

                }

                finally {

                        session.close();

                }

      

        }

}

compilEx1.ksh

#!/bin/bash

#Déclaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur1 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH



javac -classpath $CLASSPATH utilisateur1/ClientEx1.java

#!/bin/bash

#Declaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur1 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH



java -classpath $CLASSPATH utilisateur1.ClientEx1

essai=> select * from utilisateurs;

 iduser |    nom    | prenom | password  |           datecm           | issupprimable

--------+-----------+--------+-----------+----------------------------+---------------

      1 | admin     | admin  | admin     | 2004-04-28 21:34:26.036093 |             0

     24 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 21:53:54.309    |             1

     25 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 21:54:22.961    |             1

     26 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:03:03.054    |             1

     27 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:12:16.629    |             1

     28 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:21:10.92     |             1

(6lignes)

Client_1Ex1.java

package utilisateur1;

import net.sf.hibernate.*;

import net.sf.hibernate.cfg.*;

public class Client_1Ex1

{

        public static void main(String [] argv) throws Exception, MappingException,

                                  HibernateException

        {

        Transaction tx=null;

        Session session=null;

        POJOUtilisateur1 util1=null;

        try

                {

                Configuration cfg = new Configuration()

                        .addClass(utilisateur1.POJOUtilisateur1.class);



                SessionFactory sessionFactory =   cfg.buildSessionFactory();

                // ouverture de la session

                session =sessionFactory.openSession();

                // Modification d'un utilisateur

                  tx = session.beginTransaction();

                // Récupérons l utilsateur de iduser = 24

                 util1= (POJOUtilisateur1) session.load(POJOUtilisateur1.class,new Long(24));

                // Modifions son password

                util1.setPassword("arheu123");

                // Sauvons l'enregistrement

                session.update(util1);

                

                // Suppression de l utilisateur dont iduser passé en argument de la fonction main

                long lg=Long.parseLong(argv[0]);

                util1= (POJOUtilisateur1) session.load(POJOUtilisateur1.class,new Long(lg));

                session.delete(util1);

                 tx.commit();

                                

                }

        

         catch (Exception e) {

                        if (tx!=null) tx.rollback();

                        throw e;

                }

                finally {

                        session.close();

                }

      

        }

}

#!/bin/bash

#Déclaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur1 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH



javac -classpath $CLASSPATH utilisateur1/*.java

#!/bin/bash

#Déclaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur1 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH



java -classpath $CLASSPATH $*

On lance : 



genLanceEx1.ksh utilisateur1.Client_1Ex1 28

essai=> select * from utilisateurs;

 iduser |    nom    | prenom | password  |           datecm           | issupprimable

--------+-----------+--------+-----------+----------------------------+---------------

      1 | admin     | admin  | admin     | 2004-04-28 21:34:26.036093 |             0

     24 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 21:53:54.309    |             1

     25 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 21:54:22.961    |             1

     26 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:03:03.054    |             1

     27 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:12:16.629    |             1

     28 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:21:10.92     |             1

     29 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:49:18.387    |             1

     30 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:51:08.809    |             1

(8lignes)

essai=> select * from utilisateurs;

 iduser |    nom    | prenom | password  |           datecm           | issupprimable

--------+-----------+--------+-----------+----------------------------+---------------

      1 | admin     | admin  | admin     | 2004-04-28 21:34:26.036093 |             0

     25 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 21:54:22.961    |             1

     26 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:03:03.054    |             1

     27 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:12:16.629    |             1

     29 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:49:18.387    |             1

     30 | Pasturel1 | jl1    | pasturel1 | 2004-05-07 22:51:08.809    |             1

     24 | Pasturel1 | jl1    | arheu123  | 2004-05-07 21:53:54.309    |             1

(7 lignes)

import net.sf.hibernate.*;

import net.sf.hibernate.cfg.*;



public class HibernateUtil {



    private static final SessionFactory sessionFactory;



    static {

        try {

            // Create the SessionFactory

            sessionFactory = new Configuration().configure().buildSessionFactory();

        } catch (HibernateException ex) {

            throw new RuntimeException("Configuration problem : " + ex.getMessage(), ex);

        }

    }



    public static final ThreadLocal session = new ThreadLocal();



    public static Session currentSession() throws HibernateException {

        Session s = (Session) session.get();

        // Open a new Session, if this Thread has none yet

        if (s == null) {

            s = sessionFactory.openSession();

            session.set(s);

        }

        return s;

    }



    public static void closeSession() throws HibernateException {

        Session s = (Session) session.get();

        session.set(null);

        if (s != null)

            s.close();

    }

}

Session session = HibernateUtil.currentSession();



Transaction tx= session.beginTransaction();



Cat princess = new Cat();

princess.setName("Princess");

princess.setSex('F');

princess.setWeight(7.4f);



session.save(princess);

tx.commit();



HibernateUtil.closeSession();

Set mesFils = new HashSet();

HashSet mesFils = new HashSet(); // erreur

personne.hbm.xml

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<!-- Strategie table-per-class hierarchy mapping -->

<hibernate-mapping package="utilisateur2">

         <class name="Personne" table="PERSONNES" discriminator-value="P">

                <id name="idPers" column="idPers" type="long">

                        <generator class="sequence"/>

                </id>

                 <discriminator column="sousclasse" type="character"/>

                 <property name="nom" column="nom" type="string"/>

                 <property name="prenom" column="prenom" type="string"/>

                 <set name="listutilisateurs2">

                        <key column="idPers"/>

                    <one-to-many class="utilisateur2.Utilisateur2" />

                </set>

                <subclass name="Employe" discriminator-value="E">

                        <property name="codeInterne" column="codeInterne" type="string"/>

                </subclass>

                <subclass name="Externe" discriminator-value="X">

                        <property name="societe" column="societe" type="string"/>

                </subclass>

        </class>

        

</hibernate-mapping>

create table PERSONNES (

   idPers INT8 not null,

   sousclasse CHAR(1) not null,

   nom VARCHAR(255),

   prenom VARCHAR(255),

   codeInterne VARCHAR(255),

   societe VARCHAR(255),

   primary key (idPers)

)

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<!-- Strategie table-per-class hierarchy mapping -->

<hibernate-mapping package="utilisateur2">

         <class name="Personne" table="PERSONNES" >

                <id name="idPers" column="idPers" type="long">

                        <generator class="sequence"/>

                 </id>

                 

                 <property name="nom" column="nom" type="string"/>

                 <property name="prenom" column="prenom" type="string"/>

                 

                 <set name="listutilisateurs2">

                        <key column="idPers"/>

                    <one-to-many class="utilisateur2.Utilisateur2" />

                </set>

                <joined-subclass name="Employe" table="EMPLOYES">

                        <key column="idPers"/>

                        <property name="codeInterne" column="codeInterne" type="string"/>

                </joined-subclass>

                <joined-subclass name="Externe" table="EXTERNES">

                        <key column="idPers"/>

                        <property name="societe" column="societe" type="string"/>

                </joined-subclass>

        </class>

                

</hibernate-mapping>

create table EMPLOYES (

   idPers INT8 not null,

   codeInterne VARCHAR(255),

   primary key (idPers)

)

...

create table EXTERNES (

   idPers INT8 not null,

   societe VARCHAR(255),

   primary key (idPers)

)

create table PERSONNES (

   idPers INT8 not null,

   nom VARCHAR(255),

   prenom VARCHAR(255),

   primary key (idPers)

)

...

alter table EMPLOYES add constraint FK75C8D6BCB8D3EEB1 foreign key (idPers) references PERSONNES

...

alter table EXTERNES add constraint FKC21F544EB8D3EEB1 foreign key (idPers) references PERSONNES

...

Personne.java

package utilisateur2;

import java.lang.Long;

import java.lang.String;

import java.util.*;



public class Personne {

    private Long idPers;

    private String nom;

    private String prenom;

   // associations

    private Set  utilisateur2s; // of type Utilisateur2

    // operations

    public void  setIdPers(Long _id) {

        idPers=_id;

        }

   public Long getIdPers() {

        return idPers;

        }

    public Set getUtilisateur2s()

    {

        return utilisateur2s;

    }

    public void setUtilisateur2s(Set _util)

    {

        utilisateur2s=_util;

    }

    public String getNom() {

        return nom;

    } // end getNom

    public void setNom(String _nom) {

        nom = _nom;

    } // end setNom

    public String getPrenom() {

        return prenom;

    } // end getPrenom

    public void setPrenom(String _prenom) {

        prenom = _prenom;

    } // end setPrenom



 } // end Personne

Externe.java

package utilisateur2;

import java.lang.String;

import java.util.*;



public class Externe extends Personne {



    private String societe;





    public String getSociete() {

        return societe;

    } // end getSociete



    public void setSociete(String _societe) {

        societe = _societe;

    } // end setSociete



 } // end Externe

Employe.java

package utilisateur2;

import java.lang.String;

import java.util.*;

public class Employe extends Personne {

    private String codeInterne;



      public String getCodeInterne() {

        return codeInterne;

    } // end getCodeInterne





    public void setCodeInterne(String _codeInterne) {

        codeInterne = _codeInterne;

    } // end setCodeInterne



 } // end Employe

Utilisateur2.java

package utilisateur2;



import java.lang.Long;

import java.lang.String;

import java.util.*;

import java.util.Date;



public class Utilisateur2 {

  // attributes

    private Long idUser;

    private String login;

    private String password;

    private Date dateCM;

    private Integer isSupprimable;

   // associations

    private Personne pers;

    public Set  connexions ; // of type Connexion

    public Set roles ;  // of type Role

    // operations

    public Set getConnexions()

    {

        return connexions;

    }

     public void setConnexions(Set _cons)

    {

        connexions=_cons;

    }

    public Set getRoles()

    {

        return roles;

    }

     public void setRoles(Set _roles)

    {

        roles=_roles;

    }

    public String getLogin() {

        return login;

    } // end getLogin

    public void setLogin(String _login) {

        login = _login;

    } // end setLogin

    public Long getIdUser() {

        return idUser;

        }

   public void setIdUser(Long _id){

        idUser= _id;

        }

   public Personne getPers() {

        return pers;

        }

    public void setPers(Personne _pers){

        pers=_pers;

        }

     public String getPassword() {

        return password;

    } // end getPassword

    public void setPassword(String _password) {

        password = _password;

    } // end setPassword

    public Date getDateCM() {

        return dateCM;

    } // end getDateCM

    public void setDateCM(Date _dateCM) {

        dateCM = _dateCM;

    } // end setDateCM

    public Integer getIsSupprimable() {

        return isSupprimable;

    } // end getIsSupprimable

    public void setIsSupprimable(Integer _isSupprimable) {

        isSupprimable = _isSupprimable;

    } // end setIsSupprimable



 } // end Utilisateur2

MappingException : no persister for : java.lang.Long

Connexion.java

package utilisateur2;



import java.lang.Long;

import java.util.*;

import java.util.Date;



public class Connexion {

  // attributes

    private Long idCnx;

    private Date dateDeb;

    private Date dateFin;

        // association

        private Utilisateur2 util;

   // operations

    public void setIdCnx(Long _id) {

        idCnx=_id;

        }

    public Long getIdCnx() {

        return idCnx;

        }

     public void setUtil(Utilisateur2 _id) {

        util=_id;

        }

     public Utilisateur2  getUtil() {

        return util;

        }

    public Date getDateFin() {

        return dateFin;

    } // end getDateFin

    public void setDateFin(Date _dateFin) {

        dateFin = _dateFin;

    } // end setDateFin

    public Date getDateDeb() {

        return dateDeb;

    } // end getDateDeb

    public void setDateDeb(Date _dateDeb) {

        dateDeb = _dateDeb;

    } // end setDateDeb



 } // end Connexion

Role.java

package utilisateur2;



import java.lang.String;

import java.util.*;



public class Role {



  // attributes

    private long idRole;

    private String nom;

   // associations

    private Set utilisateur2s ;

    // operations



   public Set getUtilisateur2s()

    {

    return utilisateur2s;

    }

    public void setUtilisateur2s(Set _util)

    {

    utilisateur2s=_util;

    }

    public long getIdRole() {

        return idRole;

    } // end getIdRole

    public void setIdRole(long _idRole) {

        idRole = _idRole;

    } // end setIdRole

    public void setNom(String _nom) {

        nom=_nom;

        }

    public String getNom() {

        return nom;

        }

 } // end Role

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<!-- Strategie table-per-class hierarchy mapping -->

<hibernate-mapping package="utilisateur2">

         <class name="Personne" table="PERSONNES" discriminator-value="P">

                <id name="idPers" column="idPers" type="long">

                        <generator class="sequence"/>

                 </id>

                 <discriminator column="sousclasse" type="character"/>

                 <property name="nom" column="nom" type="string"/>

                 <property name="prenom" column="prenom" type="string"/>

                

                 <set name="utilisateur2s" inverse="true" cascade="all-delete-orphan" >

                        <key column="pers"/>

                    <one-to-many class="utilisateur2.Utilisateur2" />

                </set>

                <subclass name="Employe" discriminator-value="E">

                        <property name="codeInterne" column="codeInterne" type="string"/>

                </subclass>

                <subclass name="Externe" discriminator-value="X">

                        <property name="societe" column="societe" type="string"/>

                </subclass>

        </class>

        

</hibernate-mapping>

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

        



<hibernate-mapping package="utilisateur2">

        <class name="Utilisateur2" table="UTILISATEUR2" >

                <id name="idUser" column="idUser" type="long">

                        <generator class="sequence" />

                </id>

                <property name="login" column="login" type="string"/>

                <property name="password" column="password" type="string"/>

                <property name="dateCM" column="datecm" type="timestamp"/>

                <property name="isSupprimable" column="issuprimable" type="int"/>

                <many-to-one name="pers" class="utilisateur2.Personne" not-null="true"   />

                <set name="connexions" inverse="true" cascade="all-delete-orphan" >

                        <key column="util" />

                        <one-to-many class="utilisateur2.Connexion"/>

                </set>

                <set  name="roles" table="UTILISATEUR2_ROLES"     >

                        <key column="idUser" />

                        <many-to-many  class="utilisateur2.Role" column="idRole"   />

                </set>

        </class>

</hibernate-mapping>

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

        



<hibernate-mapping package="utilisateur2">

        <class name="Connexion" table="CONNEXIONS" >

                <id name="idCnx" column="idCnx" type="long">

                        <generator class="sequence" />

                </id>

                <property name="dateDeb" column="dateDeb" type="date"/>

                <property name="dateFin" column="dateFin" type="date"/>

                

                <many-to-one name="util" class="utilisateur2.Utilisateur2" column="util"  not-null="true"/>

                

        </class>

</hibernate-mapping>

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

        



<hibernate-mapping package="utilisateur2">

        <class name="Role" table="ROLES" >

                <id name="idRole" column="idRole" type="long">

                        <generator class="sequence" />

                </id>

                <property name="nom" column="nom" type="string"/>

                

                <set  name="utilisateur2s" table="UTILISATEUR2_ROLES" inverse="true"   >

                        <key column="idRole" />

                        <many-to-many  class="utilisateur2.Utilisateur2" column="idUser" />

                </set>

                

        </class>

</hibernate-mapping>

#!/bin/bash

#Déclaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur2 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH





 java -cp $CLASSPATH  net.sf.hibernate.tool.hbm2ddl.SchemaExport  --text --format

 --output=ex2bis.ddl --delimeter=x $*

./genSchema.ksh utilisateur2/Connexion.hbm.xml utilisateur2/Personne.hbm.xml

utilisateur2/Utilisateur2.hbm.xml utilisateur2/Role.hbm.xml

alter table UTILISATEUR2_ROLES drop constraint FK9C293F8DB8D66786

alter table UTILISATEUR2_ROLES drop constraint FK9C293F8DB8D4FC31

alter table UTILISATEUR2 drop constraint FK4FCF252F3472F6

alter table CONNEXIONS drop constraint FKEFD16ECA36F002

drop table ROLES

drop table UTILISATEUR2_ROLES

drop table UTILISATEUR2

drop table CONNEXIONS

drop table PERSONNES

drop sequence hibernate_sequence

create table ROLES (

   idRole INT8 not null,

   nom VARCHAR(255),

   primary key (idRole)

)

create table UTILISATEUR2_ROLES (

   idUser INT8 not null,

   idRole INT8 not null,

   primary key (idRole, idUser)

)

create table UTILISATEUR2 (

   idUser INT8 not null,

   login VARCHAR(255),

   password VARCHAR(255),

   datecm TIMESTAMP,

   issuprimable INT4,

   pers INT8 not null,

   primary key (idUser)

)

create table CONNEXIONS (

   idCnx INT8 not null,

   dateDeb DATE,

   dateFin DATE,

   util INT8 not null,

   primary key (idCnx)

)

create table PERSONNES (

   idPers INT8 not null,

   sousclasse CHAR(1) not null,

   nom VARCHAR(255),

   prenom VARCHAR(255),

   codeInterne VARCHAR(255),

   societe VARCHAR(255),

   primary key (idPers)

)

alter table UTILISATEUR2_ROLES add constraint FK9C293F8DB8D66786 foreign key (idUser) references UTILISATEUR2

alter table UTILISATEUR2_ROLES add constraint FK9C293F8DB8D4FC31 foreign key (idRole) references ROLES

alter table UTILISATEUR2 add constraint FK4FCF252F3472F6 foreign key (pers) references PERSONNES

alter table CONNEXIONS add constraint FKEFD16ECA36F002 foreign key (util) references UTILISATEUR2

create sequence hibernate_sequence

ex2bis.ddl

alter table UTILISATEUR2_ROLES drop constraint FK9C293F8DB8D66786;

alter table UTILISATEUR2_ROLES drop constraint FK9C293F8DB8D4FC31;

alter table UTILISATEUR2 drop constraint FK4FCF252F3472F6;

alter table CONNEXIONS drop constraint FKEFD16ECA36F002;

drop table ROLES;

drop table UTILISATEUR2_ROLES;

drop table UTILISATEUR2;

drop table CONNEXIONS;

drop table PERSONNES;

drop sequence hibernate_sequence;

create table ROLES (

   idRole INT8 not null,

   nom VARCHAR(255),

   primary key (idRole)

);

create table UTILISATEUR2_ROLES (

   idUser INT8 not null,

   idRole INT8 not null,

   primary key (idRole, idUser)

);

create table UTILISATEUR2 (

   idUser INT8 not null,

   login VARCHAR(255),

   password VARCHAR(255),

   datecm TIMESTAMP,

   issuprimable INT4,

   pers INT8 not null,

   primary key (idUser)

);

create table CONNEXIONS (

   idCnx INT8 not null,

   dateDeb DATE,

   dateFin DATE,

   util INT8 not null,

   primary key (idCnx)

);

create table PERSONNES (

   idPers INT8 not null,

   sousclasse CHAR(1) not null,

   nom VARCHAR(255),

   prenom VARCHAR(255),

   codeInterne VARCHAR(255),

   societe VARCHAR(255),

   primary key (idPers)

);

alter table UTILISATEUR2_ROLES add constraint FK9C293F8DB8D66786 foreign key (idUser) references UTILISATEUR2;

alter table UTILISATEUR2_ROLES add constraint FK9C293F8DB8D4FC31 foreign key (idRole) references ROLES;

alter table UTILISATEUR2 add constraint FK4FCF252F3472F6 foreign key (pers) references PERSONNES;

alter table CONNEXIONS add constraint FKEFD16ECA36F002 foreign key (util) references UTILISATEUR2;

create sequence hibernate_sequence;

psql essai

\i ex2bis.ddl

essai=> \dt

                Liste des relations

 Schéma |        Nom         | Type  | Propriétaire

--------+--------------------+-------+--------------

 public | auctionitem        | table | pastjl

 public | auctionuser        | table | pastjl

 public | bid                | table | pastjl

 public | connexions         | table | pastjl

 public | personnes          | table | pastjl

 public | roles              | table | pastjl

 public | utilisateur2       | table | pastjl

 public | utilisateur2_roles | table | pastjl

 public | utilisateurs       | table | pastjl

(9 lignes)



essai=> \d utilisateur2

                Table «public.utilisateur2»

   Colonne    |            Type             | Modificateurs

--------------+-----------------------------+---------------

 iduser       | bigint                      | not null

 login        | character varying(255)      |

 password     | character varying(255)      |

 datecm       | timestamp without time zone |

 issuprimable | integer                     |

 pers         | bigint                      | not null

Index :

    «utilisateur2_pkey» clé primaire, btree (iduser)

Contraintes de clés secondaires :

    «fk4fcf252f3472f6» FOREIGN KEY (pers) REFERENCES personnes(idpers)

package utilisateur2;

import utilisateur2.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;

public class ClientEx2 {

        public static void main (String argv[]) throws HibernateException {

        FacadeEx2 facadeEx2 = new FacadeEx2();

        try {

        facadeEx2.configure();

        }catch (HibernateException he1) {

                System.out.println("Error Hibernate "+he1.getMessage()+"\n");

                he1.printStackTrace();

                }

        // Creation de 4 Employe

        facadeEx2.createEmploye("PASTUREL0","JEAN-LOUIS0","PAST0000");

        facadeEx2.createEmploye("PASTUREL1","JEAN-LOUIS1","PAST0001");

        facadeEx2.createEmploye("PASTUREL2","JEAN-LOUIS2","PAST0002");

        facadeEx2.createEmploye("PASTUREL3","JEAN-LOUIS3","PAST0003");

        // Creation de 4 Externe

        facadeEx2.createExterne("EXTERNE0","JEAN-LOUIS0","SOCI0000");

        facadeEx2.createExterne("EXTERNE1","JEAN-LOUIS1","SOCI0001");

        facadeEx2.createExterne("EXTERNE2","JEAN-LOUIS2","SOCI0002");

        facadeEx2.createExterne("EXTERNE3","JEAN-LOUIS3","SOCI0003");

                }

}

package utilisateur2;

import utilisateur2.*;

import java.util.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;





public class FacadeEx2 {

         private SessionFactory sessFactory;



    public void configure() throws HibernateException {

        sessFactory = new Configuration()

            .addClass(utilisateur2.Connexion.class)

            .addClass(Personne.class)

            .addClass(Role.class)

            .addClass(Utilisateur2.class)

            .buildSessionFactory();

        System.out.println("Configuration termine OK \n");

        }

         public Employe createEmploye(String _nom, String _prenom,String _codeInterne)

         throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Employe emp=new Employe();

        emp.setNom(_nom);

        emp.setPrenom(_prenom);

        emp.setUtilisateur2s(new HashSet());

        emp.setCodeInterne(_codeInterne);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(emp);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return emp;

    }

     public Externe createExterne(String _nom, String _prenom,String _societe)

                                 throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Externe ext=new Externe();

        ext.setNom(_nom);

        ext.setPrenom(_prenom);

        ext.setUtilisateur2s(new HashSet());

        ext.setSociete(_societe);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(ext);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return ext;

    }

    }

#!/bin/bash

#Déclaration des CLASSPATH HIBERNATE

HIBERNATE_HOME=/opt/hibernate-2.1

CLASSPATH=.:./utilisateur2 :$HIBERNATE_HOME/hibernate2.jar

for i in ` ls $HIBERNATE_HOME/lib/*.jar`; do

        CLASSPATH=$CLASSPATH :$i;

done

echo CLASSPATH=$CLASSPATH

export CLASSPATH



java -classpath $CLASSPATH utilisateur2.ClientEx2

./lanceEX2.ksh

essai=> select * from PERSONNES;

 idpers | sousclasse |    nom    |   prenom    | codeinterne | societe

--------+------------+-----------+-------------+-------------+----------

      1 | E          | PASTUREL0 | JEAN-LOUIS0 | PAST0000    |

      2 | E          | PASTUREL1 | JEAN-LOUIS1 | PAST0001    |

      3 | E          | PASTUREL2 | JEAN-LOUIS2 | PAST0002    |

      4 | E          | PASTUREL3 | JEAN-LOUIS3 | PAST0003    |

      5 | X          | EXTERNE0  | JEAN-LOUIS0 |             | SOCI0000

      6 | X          | EXTERNE1  | JEAN-LOUIS1 |             | SOCI0001

      7 | X          | EXTERNE2  | JEAN-LOUIS2 |             | SOCI0002

      8 | X          | EXTERNE3  | JEAN-LOUIS3 |             | SOCI0003

(8 lignes)

package utilisateur2;

import utilisateur2.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;

public class ClientEx2 {

        public static void main (String argv[]) throws HibernateException {

        Employe emp1;

        Externe ext1;

        Utilisateur2 user1, user2,user3,user4;

        

        FacadeEx2 facadeEx2 = new FacadeEx2();

        try {

        facadeEx2.configure();

        }catch (HibernateException he1) {

                System.out.println("Error Hibernate "+he1.getMessage()+"\n");

                he1.printStackTrace();

                }

        // Creation de 4 Employe

        emp1=facadeEx2.createEmploye("PASTUREL0","JEAN-LOUIS0","PAST0000");

        facadeEx2.createEmploye("PASTUREL1","JEAN-LOUIS1","PAST0001");

        facadeEx2.createEmploye("PASTUREL2","JEAN-LOUIS2","PAST0002");

        facadeEx2.createEmploye("PASTUREL3","JEAN-LOUIS3","PAST0003");

        // Creation de 4 Externe

        ext1=facadeEx2.createExterne("EXTERNE0","JEAN-LOUIS0","SOCI0000");

        facadeEx2.createExterne("EXTERNE1","JEAN-LOUIS1","SOCI0001");

        facadeEx2.createExterne("EXTERNE2","JEAN-LOUIS2","SOCI0002");

        facadeEx2.createExterne("EXTERNE3","JEAN-LOUIS3","SOCI0003");

        // Creation de User pour Employe

        user1= facadeEx2.createUtilisateur2("E_USER0_0","E_USER0_0",(int) 1);

        user2=facadeEx2.createUtilisateur2("E_USER0_1","E_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_0","E_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_1","E_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_0","E_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_1","E_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_0","E_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_1","E_USER3_1",(int)1);

        // Creation de User pour Externe

        user3=facadeEx2.createUtilisateur2("X_USER0_0","X_USER0_0",(int)1);

        user4=facadeEx2.createUtilisateur2("X_USER0_1","X_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_0","X_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_1","X_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_0","X_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_1","X_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_0","X_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_1","X_USER3_1",(int)1);

        // Associer le user "E_USER_0_0" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user1.getIdUser());

        // Associer le user "E_USER_0_1" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user2.getIdUser());

        //Associer  le user "X_USER_0_0" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user3.getIdUser());

        //Associer  le user "X_USER_0_1" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user4.getIdUser());

        }

}

package utilisateur2;

import utilisateur2.*;

import java.util.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;





public class FacadeEx2 {

         private SessionFactory sessFactory;



    public void configure() throws HibernateException {

        sessFactory = new Configuration()

            .addClass(utilisateur2.Connexion.class)

            .addClass(Personne.class)

            .addClass(Role.class)

            .addClass(Utilisateur2.class)

            .buildSessionFactory();

        System.out.println("Configuration termine OK \n");

        }

         public Employe createEmploye(String _nom, String _prenom,String _codeInterne)

         throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Employe emp=new Employe();

        emp.setNom(_nom);

        emp.setPrenom(_prenom);

        emp.setUtilisateur2s(new HashSet());

        emp.setCodeInterne(_codeInterne);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(emp);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return emp;

    }

     public Externe createExterne(String _nom, String _prenom,String _societe)

                                 throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Externe ext=new Externe();

        ext.setNom(_nom);

        ext.setPrenom(_prenom);

        ext.setUtilisateur2s(new HashSet());

        ext.setSociete(_societe);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(ext);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return ext;

    }



    public Utilisateur2 createUtilisateur2(String _login, String _password,int _issupprimable)

                  throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Utilisateur2 user=new Utilisateur2();

        Personne pers=new Personne();

        user.setLogin(_login);

        user.setPassword(_password);

        user.setIsSupprimable(new Integer(_issupprimable));

        user.setDateCM(new java.util.Date());

        //user.setIdPers(new Long(0));

        

        user.setConnexions(new HashSet());

        user.setRoles(new HashSet());

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            // pour respecter la clause non-null sur la Foreign-key pointant sur personne on

            // affecte par defaut la personne 3

            Query q2 = session.createQuery("from Personne where idPers = 3");

            pers= (Personne) q2.list().get(0);

            user.setPers(pers);

            session.save(user);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return user;

    }

    public boolean assocPersToUser(Long _idPers, Long _idUser) throws HibernateException {

    boolean retour=true;

    Utilisateur2 user =new Utilisateur2();

    Personne pers = new Personne();

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

    Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

    Query q2 = session.createQuery("from Personne where idPers = :idPers");

    q1.setParameter("idUser", _idUser);

    q2.setParameter("idPers", _idPers);



    user= (Utilisateur2) q1.list().get(0);

    System.out.println("Login = "+user.getLogin());

    pers= (Personne) q2.list().get(0);

    System.out.println ("Nom de la personne ="+pers.getNom()+" ;idPers = " +pers.getIdPers());

    user.setPers((Personne) pers);

    //user.setIdPers(emp.getIdPers());



    ((Set)((Personne)pers).getUtilisateur2s()).add((Utilisateur2) user);



    session.save(user);



    tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            retour = false;

            throw he;

        

        }

        finally {

            session.close();

        }

    return retour;

    }

    }

./lanceEX2.ksh

essai=> select * from UTILISATEUR2 order by 1;

 iduser |   login   | password  |         datecm          | issuprimable | pers

--------+-----------+-----------+-------------------------+--------------+------

      9 | E_USER0_0 | E_USER0_0 | 2004-05-20 19:02:52.46  |            1 |    1

     10 | E_USER0_1 | E_USER0_1 | 2004-05-20 19:02:52.584 |            1 |    1

     11 | E_USER1_0 | E_USER1_0 | 2004-05-20 19:02:52.638 |            1 |    3

     12 | E_USER1_1 | E_USER1_1 | 2004-05-20 19:02:52.653 |            1 |    3

     13 | E_USER2_0 | E_USER2_0 | 2004-05-20 19:02:52.685 |            1 |    3

     14 | E_USER2_1 | E_USER2_1 | 2004-05-20 19:02:52.704 |            1 |    3

     15 | E_USER3_0 | E_USER3_0 | 2004-05-20 19:02:52.727 |            1 |    3

     16 | E_USER3_1 | E_USER3_1 | 2004-05-20 19:02:52.794 |            1 |    3

     17 | X_USER0_0 | X_USER0_0 | 2004-05-20 19:02:52.848 |            1 |    5

     18 | X_USER0_1 | X_USER0_1 | 2004-05-20 19:02:52.881 |            1 |    5

     19 | X_USER1_0 | X_USER1_0 | 2004-05-20 19:02:52.939 |            1 |    3

     20 | X_USER1_1 | X_USER1_1 | 2004-05-20 19:02:52.985 |            1 |    3

     21 | X_USER2_0 | X_USER2_0 | 2004-05-20 19:02:53.053 |            1 |    3

     22 | X_USER2_1 | X_USER2_1 | 2004-05-20 19:02:53.162 |            1 |    3

     23 | X_USER3_0 | X_USER3_0 | 2004-05-20 19:02:53.216 |            1 |    3

     24 | X_USER3_1 | X_USER3_1 | 2004-05-20 19:02:53.295 |            1 |    3

(16 lignes)

package utilisateur2;

import utilisateur2.*;

import java.util.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;





public class FacadeEx2 {

         private SessionFactory sessFactory;



    public void configure() throws HibernateException {

        sessFactory = new Configuration()

            .addClass(utilisateur2.Connexion.class)

            .addClass(Personne.class)

            .addClass(Role.class)

            .addClass(Utilisateur2.class)

            .buildSessionFactory();

        System.out.println("Configuration termine OK \n");

        }

         public Employe createEmploye(String _nom, String _prenom,String _codeInterne)

         throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Employe emp=new Employe();

        emp.setNom(_nom);

        emp.setPrenom(_prenom);

        emp.setUtilisateur2s(new HashSet());

        emp.setCodeInterne(_codeInterne);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(emp);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return emp;

    }

     public Externe createExterne(String _nom, String _prenom,String _societe)

                                 throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Externe ext=new Externe();

        ext.setNom(_nom);

        ext.setPrenom(_prenom);

        ext.setUtilisateur2s(new HashSet());

        ext.setSociete(_societe);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(ext);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return ext;

    }



    public Utilisateur2 createUtilisateur2(String _login, String _password,int _issupprimable)

                  throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Utilisateur2 user=new Utilisateur2();

        Personne pers=new Personne();

        user.setLogin(_login);

        user.setPassword(_password);

        user.setIsSupprimable(new Integer(_issupprimable));

        user.setDateCM(new java.util.Date());

        //user.setIdPers(new Long(0));

        

        user.setConnexions(new HashSet());

        user.setRoles(new HashSet());

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            // pour respecter la clause non-null sur la Foreign-key pointant sur personne on

            // affecte par defaut la personne 3

            Query q2 = session.createQuery("from Personne where idPers = 3");

            pers= (Personne) q2.list().get(0);

            user.setPers(pers);

            session.save(user);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return user;

    }

    public boolean assocPersToUser(Long _idPers, Long _idUser) throws HibernateException {

    boolean retour=true;

    Utilisateur2 user =new Utilisateur2();

    Personne pers = new Personne();

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

    Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

    Query q2 = session.createQuery("from Personne where idPers = :idPers");

    q1.setParameter("idUser", _idUser);

    q2.setParameter("idPers", _idPers);



    user= (Utilisateur2) q1.list().get(0);

    System.out.println("Login = "+user.getLogin());

    pers= (Personne) q2.list().get(0);

    System.out.println ("Nom de la personne ="+pers.getNom()+" ;idPers = " +pers.getIdPers());

    user.setPers((Personne) pers);

    //user.setIdPers(emp.getIdPers());



    ((Set)((Personne)pers).getUtilisateur2s()).add((Utilisateur2) user);



    session.save(user);



    tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            retour = false;

            throw he;

        

        }

        finally {

            session.close();

        }

    return retour;

    }

    public Role createRole(String _role) throws HibernateException    {

    Role role=new Role();

    role.setNom(_role);

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(role);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return role;



    }

    }

package utilisateur2;

import utilisateur2.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;

public class ClientEx2 {

        public static void main (String argv[]) throws HibernateException {

        Employe emp1;

        Externe ext1;

        Utilisateur2 user1, user2,user3,user4;

        

        FacadeEx2 facadeEx2 = new FacadeEx2();

        try {

        facadeEx2.configure();

        }catch (HibernateException he1) {

                System.out.println("Error Hibernate "+he1.getMessage()+"\n");

                he1.printStackTrace();

                }

        // Creation de 4 Employe

        emp1=facadeEx2.createEmploye("PASTUREL0","JEAN-LOUIS0","PAST0000");

        facadeEx2.createEmploye("PASTUREL1","JEAN-LOUIS1","PAST0001");

        facadeEx2.createEmploye("PASTUREL2","JEAN-LOUIS2","PAST0002");

        facadeEx2.createEmploye("PASTUREL3","JEAN-LOUIS3","PAST0003");

        // Creation de 4 Externe

        ext1=facadeEx2.createExterne("EXTERNE0","JEAN-LOUIS0","SOCI0000");

        facadeEx2.createExterne("EXTERNE1","JEAN-LOUIS1","SOCI0001");

        facadeEx2.createExterne("EXTERNE2","JEAN-LOUIS2","SOCI0002");

        facadeEx2.createExterne("EXTERNE3","JEAN-LOUIS3","SOCI0003");

        // Creation de User pour Employe

        user1= facadeEx2.createUtilisateur2("E_USER0_0","E_USER0_0",(int) 1);

        user2=facadeEx2.createUtilisateur2("E_USER0_1","E_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_0","E_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_1","E_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_0","E_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_1","E_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_0","E_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_1","E_USER3_1",(int)1);

        // Creation de User pour Externe

        user3=facadeEx2.createUtilisateur2("X_USER0_0","X_USER0_0",(int)1);

        user4=facadeEx2.createUtilisateur2("X_USER0_1","X_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_0","X_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_1","X_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_0","X_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_1","X_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_0","X_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_1","X_USER3_1",(int)1);

        // Associer le user "E_USER_0_0" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user1.getIdUser());

        // Associer le user "E_USER_0_1" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user2.getIdUser());

        //Associer  le user "X_USER_0_0" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user3.getIdUser());

        //Associer  le user "X_USER_0_1" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user4.getIdUser());

        

        // Creation de quelques Roles : ROLE1, ROLE2, ROLE3...

        String rolei="ROLE";

        for (int i=0;i<10;i++)

                {

                facadeEx2.createRole(rolei+i);

                }

        }

}

./lanceEx2.ksh

essai=> select * from Roles;

 idrole |  nom

--------+-------

     25 | ROLE0

     26 | ROLE1

     27 | ROLE2

     28 | ROLE3

     29 | ROLE4

     30 | ROLE5

     31 | ROLE6

     32 | ROLE7

     33 | ROLE8

     34 | ROLE9

(10 lignes)

essai=> select * from UTILISATEUR2_ROLES;

 iduser | idrole

--------+--------

(0 lignes)



essai=> select * from UTILISATEUR2 order by 1;

 iduser |   login   | password  |         datecm          | issuprimable | pers

--------+-----------+-----------+-------------------------+--------------+------

      9 | E_USER0_0 | E_USER0_0 | 2004-05-21 16:58:18.323 |            1 |    1

     10 | E_USER0_1 | E_USER0_1 | 2004-05-21 16:58:18.413 |            1 |    1

     11 | E_USER1_0 | E_USER1_0 | 2004-05-21 16:58:18.486 |            1 |    3

     12 | E_USER1_1 | E_USER1_1 | 2004-05-21 16:58:18.498 |            1 |    3

     13 | E_USER2_0 | E_USER2_0 | 2004-05-21 16:58:18.516 |            1 |    3

     14 | E_USER2_1 | E_USER2_1 | 2004-05-21 16:58:18.534 |            1 |    3

     15 | E_USER3_0 | E_USER3_0 | 2004-05-21 16:58:18.563 |            1 |    3

     16 | E_USER3_1 | E_USER3_1 | 2004-05-21 16:58:18.611 |            1 |    3

     17 | X_USER0_0 | X_USER0_0 | 2004-05-21 16:58:18.654 |            1 |    5

     18 | X_USER0_1 | X_USER0_1 | 2004-05-21 16:58:18.70  |            1 |    5

     19 | X_USER1_0 | X_USER1_0 | 2004-05-21 16:58:18.741 |            1 |    3

     20 | X_USER1_1 | X_USER1_1 | 2004-05-21 16:58:18.792 |            1 |    3

     21 | X_USER2_0 | X_USER2_0 | 2004-05-21 16:58:18.84  |            1 |    3

     22 | X_USER2_1 | X_USER2_1 | 2004-05-21 16:58:18.936 |            1 |    3

     23 | X_USER3_0 | X_USER3_0 | 2004-05-21 16:58:18.986 |            1 |    3

     24 | X_USER3_1 | X_USER3_1 | 2004-05-21 16:58:19.058 |            1 |    3

(16lignes)

package utilisateur2;

import utilisateur2.*;

import java.util.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;





public class FacadeEx2 {

         private SessionFactory sessFactory;



    public void configure() throws HibernateException {

        sessFactory = new Configuration()

            .addClass(utilisateur2.Connexion.class)

            .addClass(Personne.class)

            .addClass(Role.class)

            .addClass(Utilisateur2.class)

            .buildSessionFactory();

        System.out.println("Configuration termine OK \n");

        }

         public Employe createEmploye(String _nom, String _prenom,String _codeInterne)

         throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Employe emp=new Employe();

        emp.setNom(_nom);

        emp.setPrenom(_prenom);

        emp.setUtilisateur2s(new HashSet());

        emp.setCodeInterne(_codeInterne);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(emp);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return emp;

    }

     public Externe createExterne(String _nom, String _prenom,String _societe)

                                 throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Externe ext=new Externe();

        ext.setNom(_nom);

        ext.setPrenom(_prenom);

        ext.setUtilisateur2s(new HashSet());

        ext.setSociete(_societe);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(ext);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return ext;

    }



    public Utilisateur2 createUtilisateur2(String _login, String _password,int _issupprimable)

                  throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Utilisateur2 user=new Utilisateur2();

        Personne pers=new Personne();

        user.setLogin(_login);

        user.setPassword(_password);

        user.setIsSupprimable(new Integer(_issupprimable));

        user.setDateCM(new java.util.Date());

        //user.setIdPers(new Long(0));

        

        user.setConnexions(new HashSet());

        user.setRoles(new HashSet());

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            // pour respecter la clause non-null sur la Foreign-key pointant sur personne on

            // affecte par defaut la personne 3

            Query q2 = session.createQuery("from Personne where idPers = 3");

            pers= (Personne) q2.list().get(0);

            user.setPers(pers);

            session.save(user);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return user;

    }

    public boolean assocPersToUser(Long _idPers, Long _idUser) throws HibernateException {

    boolean retour=true;

    Utilisateur2 user =new Utilisateur2();

    Personne pers = new Personne();

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

    Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

    Query q2 = session.createQuery("from Personne where idPers = :idPers");

    q1.setParameter("idUser", _idUser);

    q2.setParameter("idPers", _idPers);



    user= (Utilisateur2) q1.list().get(0);

    System.out.println("Login = "+user.getLogin());

    pers= (Personne) q2.list().get(0);

    System.out.println ("Nom de la personne ="+pers.getNom()+" ;idPers = " +pers.getIdPers());

    user.setPers((Personne) pers);

    //user.setIdPers(emp.getIdPers());



    ((Set)((Personne)pers).getUtilisateur2s()).add((Utilisateur2) user);



    session.save(user);



    tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            retour = false;

            throw he;

        

        }

        finally {

            session.close();

        }

    return retour;

    }

    public Role createRole(String _role) throws HibernateException    {

    Role role=new Role();

    role.setNom(_role);

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(role);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return role;



    }

    public boolean assocUtilisateur2Roles(Long _idUser, Long _idRole)

           throws HibernateException    {

        boolean retour=true;

        Role rol=new Role();

        Utilisateur2 util=new Utilisateur2();

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

        Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

        Query q2 = session.createQuery("from Role where idRole = :idRole");

        q1.setParameter("idUser", _idUser);

        q2.setParameter("idRole", _idRole);

        util=(Utilisateur2) q1.list().get(0);

        System.out.println("Login = "+util.getLogin());

        rol=(Role) q2.list().get(0);

        System.out.println ("Nom du Role ="+rol.getNom());

        ((Set)util.getRoles()).add((Role) rol);

        ((Set)rol.getUtilisateur2s()).add((Utilisateur2) util);

        session.save(rol);

        session.save(util);

            tx.commit();

        }

        catch (HibernateException he) {

                retour=false;

            if (tx!=null) tx.rollback();

            throw he;

        

        }

        finally {

            session.close();

        }

        return retour;

        }

    }

package utilisateur2;

import utilisateur2.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;

public class ClientEx2 {

        public static void main (String argv[]) throws HibernateException {

        Employe emp1;

        Externe ext1;

        Utilisateur2 user1, user2,user3,user4;

        

        FacadeEx2 facadeEx2 = new FacadeEx2();

        try {

        facadeEx2.configure();

        }catch (HibernateException he1) {

                System.out.println("Error Hibernate "+he1.getMessage()+"\n");

                he1.printStackTrace();

                }

        // Creation de 4 Employe

        emp1=facadeEx2.createEmploye("PASTUREL0","JEAN-LOUIS0","PAST0000");

        facadeEx2.createEmploye("PASTUREL1","JEAN-LOUIS1","PAST0001");

        facadeEx2.createEmploye("PASTUREL2","JEAN-LOUIS2","PAST0002");

        facadeEx2.createEmploye("PASTUREL3","JEAN-LOUIS3","PAST0003");

        // Creation de 4 Externe

        ext1=facadeEx2.createExterne("EXTERNE0","JEAN-LOUIS0","SOCI0000");

        facadeEx2.createExterne("EXTERNE1","JEAN-LOUIS1","SOCI0001");

        facadeEx2.createExterne("EXTERNE2","JEAN-LOUIS2","SOCI0002");

        facadeEx2.createExterne("EXTERNE3","JEAN-LOUIS3","SOCI0003");

        // Creation de User pour Employe

        user1= facadeEx2.createUtilisateur2("E_USER0_0","E_USER0_0",(int) 1);

        user2=facadeEx2.createUtilisateur2("E_USER0_1","E_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_0","E_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_1","E_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_0","E_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_1","E_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_0","E_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_1","E_USER3_1",(int)1);

        // Creation de User pour Externe

        user3=facadeEx2.createUtilisateur2("X_USER0_0","X_USER0_0",(int)1);

        user4=facadeEx2.createUtilisateur2("X_USER0_1","X_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_0","X_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_1","X_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_0","X_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_1","X_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_0","X_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_1","X_USER3_1",(int)1);

        // Associer le user "E_USER_0_0" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user1.getIdUser());

        // Associer le user "E_USER_0_1" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user2.getIdUser());

        //Associer  le user "X_USER_0_0" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user3.getIdUser());

        //Associer  le user "X_USER_0_1" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user4.getIdUser());

        

        // Creation de quelqes Roles : ROLE1, ROLE2, ROLE3...

        String rolei="ROLE";

        for (int i=0;i<10;i++)

                {

                facadeEx2.createRole(rolei+i);

                }

                

        // Creation d'associations entre Utilisateurs et Roles :

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(25));

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(26));

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(27));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(25));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(33));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(34));

        facadeEx2.assocUtilisateur2Roles(new Long(11), new Long(27));

        facadeEx2.assocUtilisateur2Roles(new Long(11), new Long(28));

        facadeEx2.assocUtilisateur2Roles(new Long(11), new Long(29));

        

        }

}

./lanceEx2.ksh

Et la preuve dans la base : 



essai=> select * from UTILISATEUR2_ROLES;

 iduser | idrole

--------+--------

      9 |     25

      9 |     26

      9 |     27

     10 |     25

     10 |     33

     10 |     34

     17 |     27

     17 |     28

     18 |     29

(9lignes)

package utilisateur2;

import utilisateur2.*;

import java.util.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;





public class FacadeEx2 {

         private SessionFactory sessFactory;



    public void configure() throws HibernateException {

        sessFactory = new Configuration()

            .addClass(utilisateur2.Connexion.class)

            .addClass(Personne.class)

            .addClass(Role.class)

            .addClass(Utilisateur2.class)

            .buildSessionFactory();

        System.out.println("Configuration termine OK \n");

        }

         public Employe createEmploye(String _nom, String _prenom,String _codeInterne)

         throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Employe emp=new Employe();

        emp.setNom(_nom);

        emp.setPrenom(_prenom);

        emp.setUtilisateur2s(new HashSet());

        emp.setCodeInterne(_codeInterne);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(emp);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return emp;

    }

     public Externe createExterne(String _nom, String _prenom,String _societe)

                                 throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Externe ext=new Externe();

        ext.setNom(_nom);

        ext.setPrenom(_prenom);

        ext.setUtilisateur2s(new HashSet());

        ext.setSociete(_societe);

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(ext);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return ext;

    }



    public Utilisateur2 createUtilisateur2(String _login, String _password,int _issupprimable)

                  throws HibernateException {



        //Initialisation d un Employe sous-classe de Personne

        Utilisateur2 user=new Utilisateur2();

        Personne pers=new Personne();

        user.setLogin(_login);

        user.setPassword(_password);

        user.setIsSupprimable(new Integer(_issupprimable));

        user.setDateCM(new java.util.Date());

        //user.setIdPers(new Long(0));

        

        user.setConnexions(new HashSet());

        user.setRoles(new HashSet());

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            // pour respecter la clause non-null sur la Foreign-key pointant sur personne on

            // affecte par defaut la personne 3

            Query q2 = session.createQuery("from Personne where idPers = 3");

            pers= (Personne) q2.list().get(0);

            user.setPers(pers);

            session.save(user);

            tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return user;

    }

    public boolean assocPersToUser(Long _idPers, Long _idUser) throws HibernateException {

    boolean retour=true;

    Utilisateur2 user =new Utilisateur2();

    Personne pers = new Personne();

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

    Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

    Query q2 = session.createQuery("from Personne where idPers = :idPers");

    q1.setParameter("idUser", _idUser);

    q2.setParameter("idPers", _idPers);



    user= (Utilisateur2) q1.list().get(0);

    System.out.println("Login = "+user.getLogin());

    pers= (Personne) q2.list().get(0);

    System.out.println ("Nom de la personne ="+pers.getNom()+" ;idPers = " +pers.getIdPers());

    user.setPers((Personne) pers);

    //user.setIdPers(emp.getIdPers());



    ((Set)((Personne)pers).getUtilisateur2s()).add((Utilisateur2) user);



    session.save(user);

    session.save(pers);

    session.flush();

    tx.commit();

        }

        catch (HibernateException he) {

            if (tx!=null) tx.rollback();

            retour = false;

            throw he;

        

        }

        finally {

            session.close();

        }

    return retour;

    }

    public Role createRole(String _role) throws HibernateException    {

    Role role=new Role();

    role.setNom(_role);

    Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

            tx = session.beginTransaction();

            session.save(role);

            tx.commit();

        }

        catch (HibernateException he) {

        

            if (tx!=null) tx.rollback();

            throw he;

        }

        finally {

            session.close();

        }

        return role;



    }

    public boolean assocUtilisateur2Roles(Long _idUser, Long _idRole)

                   throws HibernateException    {

        boolean retour=true;

        Role rol=new Role();

        Utilisateur2 util=new Utilisateur2();

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

        /*Query q1=session.createQuery("from Utilisateur2 where idUser = :idUser");

        Query q2 = session.createQuery("from Role where idRole = :idRole");

        q1.setParameter("idUser", _idUser);

        q2.setParameter("idRole", _idRole);*/

        util=(Utilisateur2) session.load(Utilisateur2.class,_idUser);

        System.out.println("Login = "+util.getLogin());

        //rol=(Role) q2.list().get(0);

        rol=(Role) session.load(Role.class,_idRole);

        System.out.println ("Nom du Role ="+rol.getNom());

        ((Set)util.getRoles()).add((Role) rol);

        ((Set)rol.getUtilisateur2s()).add((Utilisateur2) util);

        session.save(rol);

        session.save(util);

        session.flush();

            tx.commit();

        }

        catch (HibernateException he) {

                retour=false;

            if (tx!=null) tx.rollback();

            throw he;

        

        }

        finally {

            session.close();

        }

        return retour;

        }

        

    public boolean deletePersonne(Long _idPers) throws HibernateException    {

        boolean retour=true;

        Personne pers=new Personne();

        Session session = sessFactory.openSession();

        Transaction tx = null;

        try {

        tx = session.beginTransaction();

        /*Query q1=session.createQuery("from Personne where idPers = :idPers");

        q1.setParameter("idPers", _idPers);

        pers=(Personne) q1.list().get(0);*/

        pers=(Personne) session.load(Personne.class,_idPers);

        System.out.println("Login = "+pers.getNom());

        session.delete(pers);

        session.flush();

          tx.commit();

        }

        catch (HibernateException he) {

                retour=false;

            if (tx!=null) tx.rollback();

            throw he;

        

        }

        finally {

            session.close();

        }

        return retour;

        }

        public Connexion createConnexion(Long _idUser) throws HibernateException

        {

                Connexion con =new Connexion();

                con.setDateDeb(new Date());

                con.setDateDeb(new Date());

                Session session = sessFactory.openSession();

           Transaction tx = null;

           try {

                tx = session.beginTransaction();

                Utilisateur2 util=(Utilisateur2) session.load(Utilisateur2.class,_idUser);

                con.setUtil(util);

                ((Set)util.getConnexions()).add((Connexion) con);

                session.saveOrUpdate(util);

                session.saveOrUpdate(con);

        

                //session.flush();

                  tx.commit();

                }

          catch (HibernateException he) {

                

             if (tx!=null) tx.rollback();

               throw he;

        

             }

            finally {

            session.close();

         }

        return con;

        }

    }

package utilisateur2;

import utilisateur2.*;

import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Query;

import net.sf.hibernate.Session;

import net.sf.hibernate.SessionFactory;

import net.sf.hibernate.Transaction;

import net.sf.hibernate.cfg.Configuration;

public class ClientEx2 {

        public static void main (String argv[]) throws HibernateException {

        Employe emp1;

        Externe ext1;

        Utilisateur2 user1, user2,user3,user4;

        

        FacadeEx2 facadeEx2 = new FacadeEx2();

        try {

        facadeEx2.configure();

        }catch (HibernateException he1) {

                System.out.println("Error Hibernate "+he1.getMessage()+"\n");

                he1.printStackTrace();

                }

        // Creation de 4 Employe

        emp1=facadeEx2.createEmploye("PASTUREL0","JEAN-LOUIS0","PAST0000");

        facadeEx2.createEmploye("PASTUREL1","JEAN-LOUIS1","PAST0001");

        facadeEx2.createEmploye("PASTUREL2","JEAN-LOUIS2","PAST0002");

        facadeEx2.createEmploye("PASTUREL3","JEAN-LOUIS3","PAST0003");

        // Creation de 4 Externe

        ext1=facadeEx2.createExterne("EXTERNE0","JEAN-LOUIS0","SOCI0000");

        facadeEx2.createExterne("EXTERNE1","JEAN-LOUIS1","SOCI0001");

        facadeEx2.createExterne("EXTERNE2","JEAN-LOUIS2","SOCI0002");

        facadeEx2.createExterne("EXTERNE3","JEAN-LOUIS3","SOCI0003");

        // Creation de User pour Employe

        user1= facadeEx2.createUtilisateur2("E_USER0_0","E_USER0_0",(int) 1);

        user2=facadeEx2.createUtilisateur2("E_USER0_1","E_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_0","E_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER1_1","E_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_0","E_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER2_1","E_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_0","E_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("E_USER3_1","E_USER3_1",(int)1);

        // Creation de User pour Externe

        user3=facadeEx2.createUtilisateur2("X_USER0_0","X_USER0_0",(int)1);

        user4=facadeEx2.createUtilisateur2("X_USER0_1","X_USER0_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_0","X_USER1_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER1_1","X_USER1_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_0","X_USER2_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER2_1","X_USER2_1",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_0","X_USER3_0",(int)1);

        facadeEx2.createUtilisateur2("X_USER3_1","X_USER3_1",(int)1);

        // Associer le user "E_USER_0_0" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user1.getIdUser());

        System.out.println ("assoc de l emp :"+emp1.getIdPers()+" à l User : "+ user1.getIdUser());

        // Associer le user "E_USER_0_1" a l'employe "PASTUREL0"

        facadeEx2.assocPersToUser(emp1.getIdPers(), user2.getIdUser());

        System.out.println ("assoc de l emp :"+emp1.getIdPers()+" à l User : "+ user2.getIdUser());

        //Associer  le user "X_USER_0_0" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user3.getIdUser());

        System.out.println ("assoc de l emp :"+ext1.getIdPers()+" à l User : "+ user3.getIdUser());

        //Associer  le user "X_USER_0_1" a "EXTERNE0"

        facadeEx2.assocPersToUser(ext1.getIdPers(), user4.getIdUser());

        System.out.println ("assoc de l emp :"+ext1.getIdPers()+" à l User : "+ user4.getIdUser());

        // Creation de quelqes Roles : ROLE1, ROLE2, ROLE3...

        String rolei="ROLE";

        for (int i=0;i<10;i++)

                {

                facadeEx2.createRole(rolei+i);

                }

                

        // Creation d'associations entre Utilisateurs et Roles :

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(25));

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(26));

        facadeEx2.assocUtilisateur2Roles(new Long(9), new Long(27));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(25));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(33));

        facadeEx2.assocUtilisateur2Roles(new Long(10), new Long(34));

        facadeEx2.assocUtilisateur2Roles(new Long(17), new Long(27));

        facadeEx2.assocUtilisateur2Roles(new Long(17), new Long(28));

        facadeEx2.assocUtilisateur2Roles(new Long(18), new Long(29));

        

        // creation de Connexions sur Utilisateur 9, 10 et 17 et 18

        facadeEx2.createConnexion(new Long(9));

        facadeEx2.createConnexion(new Long(9));

        facadeEx2.createConnexion(new Long(10));

        facadeEx2.createConnexion(new Long(10));

        facadeEx2.createConnexion(new Long(17));

        facadeEx2.createConnexion(new Long(17));

        facadeEx2.createConnexion(new Long(17));

        facadeEx2.createConnexion(new Long(18));

        facadeEx2.createConnexion(new Long(18));

        facadeEx2.createConnexion(new Long(18));

        facadeEx2.createConnexion(new Long(18));

        // Suppression de la Personne dont le idPers = 1

        facadeEx2.deletePersonne(new Long(1));

        

        }

}

essai=> select * from Personnes order by 1;

 idpers | sousclasse |    nom    |   prenom    | codeinterne | societe

--------+------------+-----------+-------------+-------------+----------

      1 | E          | PASTUREL0 | JEAN-LOUIS0 | PAST0000    |

      2 | E          | PASTUREL1 | JEAN-LOUIS1 | PAST0001    |

      3 | E          | PASTUREL2 | JEAN-LOUIS2 | PAST0002    |

      4 | E          | PASTUREL3 | JEAN-LOUIS3 | PAST0003    |

      5 | X          | EXTERNE0  | JEAN-LOUIS0 |             | SOCI0000

      6 | X          | EXTERNE1  | JEAN-LOUIS1 |             | SOCI0001

      7 | X          | EXTERNE2  | JEAN-LOUIS2 |             | SOCI0002

      8 | X          | EXTERNE3  | JEAN-LOUIS3 |             | SOCI0003

(8 lignes)

select * from Utilisateur2 order by 1;

 iduser |   login   | password  |         datecm          | issuprimable | pers

--------+-----------+-----------+-------------------------+--------------+------

      9 | E_USER0_0 | E_USER0_0 | 2004-05-21 21:43:59.31  |            1 |    1

     10 | E_USER0_1 | E_USER0_1 | 2004-05-21 21:43:59.412 |            1 |    1

     11 | E_USER1_0 | E_USER1_0 | 2004-05-21 21:43:59.468 |            1 |    3

     12 | E_USER1_1 | E_USER1_1 | 2004-05-21 21:43:59.485 |            1 |    3

     13 | E_USER2_0 | E_USER2_0 | 2004-05-21 21:43:59.526 |            1 |    3

     14 | E_USER2_1 | E_USER2_1 | 2004-05-21 21:43:59.545 |            1 |    3

     15 | E_USER3_0 | E_USER3_0 | 2004-05-21 21:43:59.567 |            1 |    3

     16 | E_USER3_1 | E_USER3_1 | 2004-05-21 21:43:59.614 |            1 |    3

     17 | X_USER0_0 | X_USER0_0 | 2004-05-21 21:43:59.645 |            1 |    5

     18 | X_USER0_1 | X_USER0_1 | 2004-05-21 21:43:59.691 |            1 |    5

     19 | X_USER1_0 | X_USER1_0 | 2004-05-21 21:43:59.735 |            1 |    3

     20 | X_USER1_1 | X_USER1_1 | 2004-05-21 21:43:59.788 |            1 |    3

     21 | X_USER2_0 | X_USER2_0 | 2004-05-21 21:43:59.843 |            1 |    3

     22 | X_USER2_1 | X_USER2_1 | 2004-05-21 21:43:59.949 |            1 |    3

     23 | X_USER3_0 | X_USER3_0 | 2004-05-21 21:43:59.997 |            1 |    3

     24 | X_USER3_1 | X_USER3_1 | 2004-05-21 21:44:00.064 |            1 |    3

(16lignes)

essai=> select * from Roles;

 idrole |  nom

--------+-------

     25 | ROLE0

     26 | ROLE1

     27 | ROLE2

     28 | ROLE3

     29 | ROLE4

     30 | ROLE5

     31 | ROLE6

     32 | ROLE7

     33 | ROLE8

     34 | ROLE9

(10lignes)

essai=> select * from Utilisateur2_Roles;

 idrole | iduser

--------+--------

     25 |      9

     26 |      9

     27 |      9

     25 |     10

     33 |     10

     34 |     10

     27 |     17

     28 |     17

     29 |     18

(9lignes)

essai=> select * from Connexions;

 idcnx |  datedeb   |  datefin   | util

-------+------------+------------+------

    35 | 2004-05-21 | 2004-05-21 |    9

    36 | 2004-05-21 | 2004-05-21 |    9

    37 | 2004-05-21 | 2004-05-21 |   10

    38 | 2004-05-21 | 2004-05-21 |   10

    39 | 2004-05-21 | 2004-05-21 |   17

    40 | 2004-05-21 | 2004-05-21 |   17

    41 | 2004-05-21 | 2004-05-21 |   17

    42 | 2004-05-21 | 2004-05-21 |   18

    43 | 2004-05-21 | 2004-05-21 |   18

    44 | 2004-05-21 | 2004-05-21 |   18

    45 | 2004-05-21 | 2004-05-21 |   18

(11 lignes)

essai=> select * from Personnes order by 1;

 idpers | sousclasse |    nom    |   prenom    | codeinterne | societe

--------+------------+-----------+-------------+-------------+----------

      2 | E          | PASTUREL1 | JEAN-LOUIS1 | PAST0001    |

      3 | E          | PASTUREL2 | JEAN-LOUIS2 | PAST0002    |

      4 | E          | PASTUREL3 | JEAN-LOUIS3 | PAST0003    |

      5 | X          | EXTERNE0  | JEAN-LOUIS0 |             | SOCI0000

      6 | X          | EXTERNE1  | JEAN-LOUIS1 |             | SOCI0001

      7 | X          | EXTERNE2  | JEAN-LOUIS2 |             | SOCI0002

      8 | X          | EXTERNE3  | JEAN-LOUIS3 |             | SOCI0003

(7 lignes)

eessai=> select * from Utilisateur2 order by 1;

 iduser |   login   | password  |         datecm          | issuprimable | pers

--------+-----------+-----------+-------------------------+--------------+------

     11 | E_USER1_0 | E_USER1_0 | 2004-05-21 21:58:13.29  |            1 |    3

     12 | E_USER1_1 | E_USER1_1 | 2004-05-21 21:58:13.303 |            1 |    3

     13 | E_USER2_0 | E_USER2_0 | 2004-05-21 21:58:13.321 |            1 |    3

     14 | E_USER2_1 | E_USER2_1 | 2004-05-21 21:58:13.339 |            1 |    3

     15 | E_USER3_0 | E_USER3_0 | 2004-05-21 21:58:13.366 |            1 |    3

     16 | E_USER3_1 | E_USER3_1 | 2004-05-21 21:58:13.409 |            1 |    3

     17 | X_USER0_0 | X_USER0_0 | 2004-05-21 21:58:13.449 |            1 |    5

     18 | X_USER0_1 | X_USER0_1 | 2004-05-21 21:58:13.50  |            1 |    5

     19 | X_USER1_0 | X_USER1_0 | 2004-05-21 21:58:13.543 |            1 |    3

     20 | X_USER1_1 | X_USER1_1 | 2004-05-21 21:58:13.601 |            1 |    3

     21 | X_USER2_0 | X_USER2_0 | 2004-05-21 21:58:13.663 |            1 |    3

     22 | X_USER2_1 | X_USER2_1 | 2004-05-21 21:58:13.754 |            1 |    3

     23 | X_USER3_0 | X_USER3_0 | 2004-05-21 21:58:13.804 |            1 |    3

     24 | X_USER3_1 | X_USER3_1 | 2004-05-21 21:58:13.868 |            1 |    3

(14 lignes)