1 2 3 4 5 6 7 8 9 10 11 12 13
|
Query qDetailCnx = em.createQuery("select 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");
qDetailCnx.setParameter("startDate", startDate, TemporalType.DATE);
qDetailCnx.setParameter("endDate", endDate, TemporalType.DATE); |
Partager