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
|
/** Entity Manager Factory */
@PersistenceUnit(name = "myPersistenceUnit")
private EntityManagerFactory emf;
EntityManager em = emf.createEntityManager();
//V1 recherche qui ne se fait pas sur la clef primaire, et sous objet pas en LAZY
infodebut(op, 7);
StringBuffer select7 = new StringBuffer();
select7.append("FROM Crit12 as F ");
select7.append("WHERE F.status = :status");
select7.append(" AND F.c11a.name = :namea");
select7.append(" AND F.c11b.name = :nameb");
try {
Session ses7= ((Session)em.getDelegate());
org.hibernate.Query query7 = ses7.createQuery(select7.toString());
query7.setMaxResults(1);
query7.setParameter("status", "U");
query7.setParameter("namea","MONNOMTESTC11A_00100");
query7.setParameter("nameb", "MONNOMTESTC11B_00100");
Crit12 tmp=(Crit12)query7.iterate().next();
ses7.get(Crit12.class, tmp.getId() );
// return tmp;
} catch (HibernateException e) {
//return null;
}
//V2 Select d'un ID puis un session.get
infodebut(op, 8);
try {
StringBuffer select8 = new StringBuffer();
select8.append("Select F.id FROM Crit12 as F ");
select8.append("WHERE F.status = :status");
select8.append(" AND F.c11a.name = :namea");
select8.append(" AND F.c11b.name = :nameb");
Session ses8= ((Session)em.getDelegate());
org.hibernate.Query query8 = ses8.createQuery(select8.toString());
query8.setMaxResults(1);
query8.setParameter("status", "U");
query8.setParameter("namea","MONNOMTESTC11A_00100");
query8.setParameter("nameb", "MONNOMTESTC11B_00100");
Long tmpid=(Long)query8.list().get(0);
// return (Crit12)ses8.get(Crit12.class, tmpid);
Crit12 zz=(Crit12)ses8.get(Crit12.class, tmpid);
} catch (HibernateException e) {
// return null;
} |
