*/

/**
 *
 */
private static final long serialVersionUID = 1L;
............
.............
@Autowired
private IUserBusiness userBu;

public LoginView() {
    isLogged = false;
}

public String connexion() {

    this.userConnected = userBu.findUserbyPasswordlogin(login, password);
    FacesContext context = FacesContext.getCurrentInstance();
    if (userConnected != null) {
        year = DateUtilities.yearfromday();
        isLogged = true;
        userConnected.setDerniereconnexion(new Date().toString());
        userBu.pointerUser(userConnected);
        context.getExternalContext().getSessionMap().put("user", userConnected);
        lstMenu = new ArrayList<Menu>();
        this.getUserMenu(userConnected);
        this.getUserFonc(userConnected);
        this.sortUserMenu();
        return "Reglages_utilisateur?faces-redirect=true";
    } else {
        isLogged = false;
        context.addMessage("Login", new FacesMessage(bundle1.getString("kopassLogin")));
        return "loginPanel?faces-redirect=true";
    }

}

@Service

@Autowired
private IUserService userSrv;


public UserBusiness() {
}

@Override
public Utilisateur findUserbyPasswordlogin(String login, String password) {
    return userSrv.findUserbyPasswordlogin(login, password);
}

@Override
public Utilisateur findUserByLogin(String login) {
    return userSrv.findUserByLogin(login);
}

@Override
public void pointerUser(Utilisateur usr) {
    userSrv.modifierUser(usr);
}

@Repository

public UserService() {
    super("Utilisateur.findAll");
    // TODO Auto-generated constructor stub
}

@Transactional
public Utilisateur findUserbyPasswordlogin(String login, String password) {
    Integer userId;
    String req = "SELECT u.idutilisateur FROM Utilisateur u where  u.nomutilisateur=:login and u.passwordutilisateur=:password";
    try {
        this.requeteObjet = em.createQuery(req);
        requeteObjet.setParameter("login", login).setParameter("password", password);
        userId = (Integer) requeteObjet.getSingleResult();

        if (userId != null) {
            return this.getConnectedUser(userId);
        } else {
            return null;
        }
    } catch (Exception e) {
        System.out.println(e.getMessage());
        return null;
    }
}

public abstract class Service implements IService {

@PersistenceContext(type = PersistenceContextType.EXTENDED)
EntityManager em;
Query requeteObjet;
List<?> listObjet;
Object objet;
String namedQuery;

/*************************************************************************
 * * ***************************** *****************************************
 * * *********Constructeurs ***************************************
 * *************************************************************************
 ***************************************************************************/
public Service() {
    namedQuery = new String();
    listObjet = new ArrayList<Object>();
}


public Service(String nemedQuery) {
    namedQuery = new String();
    listObjet = new ArrayList<Object>();
    this.namedQuery = nemedQuery;
}

/*************************************************************************
 * * ***************************** *****************************************
 * * ********* Les fonctions ***************************************
 * *************************************************************************
 ***************************************************************************/

@Transactional
public void ajouterObjet() throws PSQLException {
    em.persist(objet);
}

@Transactional
public void modifierObjet() throws PSQLException {
    em.merge(objet);
}

@Transactional
public void deleteObjet(){
    if(!em.contains(objet)) {
        objet = em.merge(objet);
    }
    em.remove(objet);
}

@Transactional
public List<?> Remplir_liste_Objet() {
    try {
        requeteObjet = em.createNamedQuery(namedQuery);
        listObjet = requeteObjet.getResultList();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return listObjet;

}

@Transactional
public boolean checkExistObjet(String req, Object... values) {
    int i = 1;
    requeteObjet = em.createQuery(req);
    for (Object value : values) {
        requeteObjet.setParameter("value" + i++, value);
    }
    try {
        return (long) this.requeteObjet.getSingleResult() > 0;
    } catch (Exception e) {
        /*
         * en cas d'exception on bloque la création on retournant true.
         * cette exception doit etre geréé d'une façon plus optimale
         */
        return true;
    }
}

/*************************************************************************
 * * ***************************** *****************************************
 * * *********Les getters et setters***************************************
 * *************************************************************************
 ***************************************************************************/

public String getNamedQuery() {
    return namedQuery;
}

public void setNamedQuery(String namedQuery) {
    this.namedQuery = namedQuery;
}

public Object getObjet() {
    return objet;
}

public void setObjet(Object objet) {
    this.objet = objet;
}


public EntityManager getEm() {
    return em;
}


public void setEm(EntityManager em) {
    this.em = em;
}

<?xml version="1.0" encoding="UTF-8"?>

<properties>
        <property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost:5432/recrut_pro" />
        <property name="javax.persistence.jdbc.user" value="user" />
        <property name="javax.persistence.jdbc.password" value="pass" />
        <property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver" />
    </properties>

</persistence-unit>

<?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package="com.targettec.business, com.targettec.service" />
<bean
    class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

<!-- Define EclipseLink JPA Vendor Adapter -->
<bean id="jpaVendorAdapter"
    class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter">
    <property name="databasePlatform"
        value="org.eclipse.persistence.platform.database.PostgreSQLPlatform" />
    <property name="generateDdl" value="false" />
    <property name="showSql" value="true" />
</bean>

<bean id="entityManagerFactory"
    class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="mydb"></property>
    <property name="jpaVendorAdapter" ref="jpaVendorAdapter" />
</bean>

<!-- Transaction Manager -->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>

<!-- Detect @Transactional -->
<tx:annotation-driven transaction-manager="transactionManager" />