hibernate hql 查询语句范例,查询出需要的监控点信息,CameraInfo为实体类
String hql = "select new CameraInfo(ci.controlUnit.controlUnitId,ci.regionInfo.regionId,ci.deviceInfo.deviceId,ci.cameraId,ci.indexCode,ci.name,ci.channelNo,ci.cameraType,ci.recordMode,ci.sequenceIdx,ci.streamLinkType,ci.streamType,ci.vrmServerId,ci.recordLocationSet,ci.cascadeIndex,ci.localCascadeIndex,ci.manufacturerType,ci.deviceInfo.netZoneId) from CameraInfo ci where (ci.controlUnit.controlUnitId is not null and ci.channelType is not null) order by ci.sequenceIdx, ci.cameraId";
hql 关联过滤查询 DeviceInfo也是一个实体类
String hql2 = "select new CameraInfo(ci.controlUnit.controlUnitId,ci.regionInfo.regionId,ci.deviceInfo.deviceId,ci.cameraId,ci.indexCode,ci.name,ci.channelNo,ci.cameraType,ci.recordMode,ci.sequenceIdx,ci.streamLinkType,ci.streamType,ci.vrmServerId,ci.recordLocationSet,ci.cascadeIndex,ci.localCascadeIndex,ci.manufacturerType,ci.deviceInfo.netZoneId) from CameraInfo ci , DeviceInfo di where (di.deviceId = ci.deviceInfo.deviceId and di.matrix is null and ci.controlUnit.controlUnitId is not null) order by ci.sequenceIdx, ci.cameraId";