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
|
Date startDate;
Date endDate;
Query qDetailCnx = em.createQuery(
"select distinct t1.pdpStartTime,
t1.name1 ,
t1.ipAddr,
t1.imsi,t1.tac_code,
t4.constructeur,
t4.modele,
t4.typeTerm,
t2.type,
t5.type,
t3.type,
t3.signification
from ConnexionEntity t1,
RatEntity t2,
EndRATEntity t5,
EndCauseEntity t3,
HandsetEntity t4
where t1.name2=:name2
and starttime BETWEEN (:startDate and :endDate )
and t1.rat= t2.code
and t1.endrat= t5.code
and t1.endcause = t3.code
and t1.tac_code=t4.code
order by pdpstarttime").setParameter("startDate", startDate, TemporalType.DATE)
.setParameter("endDate", endDate, TemporalType.DATE); |
Partager