public List<DAReserve> getDeviceReserveById(Date date,Long deviceId) {
// TODO Auto-generated method stub
Query query = entityMgr.createQuery(" from DAReserve da where da.deviceId = ? and da.status in (?,?) and date(da.startTime) = ? ");
query.setParameter(1,deviceId);
query.setParameter(2,"0");
query.setParameter(3,"1");
query.setParameter(4,date);
return query.getResultList();
}
[quote]生成 的sql[/quote]
select dareserve0_.id
as id10_, dareserve0_.DEVICE_ID
as DEVICE2_10_, dareserve0_.END_TIME
as END3_10_, dareserve0_.PERMIT_CODE
as PERMIT4_10_, dareserve0_.remark as
remark10_, dareserve0_.START_TIME as START6_10_,
dareserve0_.status as status10_,
dareserve0_.USER_ID as USER8_10_ from mctsdb.da_reserve dareserve0_ where dareserve0_.DEVICE_ID=1
and (dareserve0_.status in ('0' , '1')) and date(dareserve0_.START_TIME)='2011-11-08';