1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
|
package tn.esen.services.gestion.test;
import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import tn.esen.entities.Candidat;
import tn.esen.entities.Resultat;
import tn.esen.entities.Test;
/**
* Session Bean implementation class GestionTest
*/
@Stateless
public class GestionTest implements GestionTestRemote, GestionTestLocal {
@PersistenceContext
private EntityManager entityManager;
/**
* Default constructor.
*/
public GestionTest() {
// TODO Auto-generated constructor stub
}
@Override
public boolean addTest(Test test) {
try {
entityManager.persist(test);
return true;
} catch (Exception e) {
System.err.println("Impossible de créer un Test");
} return false;
}
@Override
public boolean updateTest(Test test) {
try {
entityManager.merge(test);
return true;
} catch (Exception e) {
System.err.println("Impossible de mettre à jour un test");
} return false;
}
@Override
public boolean deleteTest(Test test) {
try {
entityManager.remove(entityManager.merge(test));
return true;
} catch (Exception e) {
System.err.println("Impossible de supprimer un test");
} return false;
}
@Override
public List<Test> readAllTest() {
String jpql = "select t from Test t ";
Query query = entityManager.createQuery(jpql);
return query.getResultList();
}
@Override
public Test findTestById(Integer id) {
return (Test) entityManager.find(Test.class, id);
}
@Override
public List<Test> findAllTestByCandidat(Candidat candidat) {
Query query=entityManager.createQuery("select distinct t from Test t join t.resultats r where r.candidat=:cand");
query.setParameter("cand", candidat);
return query.getResultList(); |
Partager