在HQL中使用ｎｅｗ的方式限制查取的字段

使用＂ｆｒｏｍ　XXX　ｗｈｅｒｅ　XXX＂的方式，当然是将整条记录查取出来封装进相应的ｂｅａｎ里

 

但是很多时候，你并不需要查取出全部的字段值，特别是有BLOB，CLOB字段的时候，把不需要的内容查取封装进来，会造成巨大的内存浪费．

 

这时候就可以使用HQL的ｎｅｗ操作

类似如下：

 select new PerformanceValue(P.id,P.regionNo,P.regionName,P.reportDate,P.perfCode,P.perfName,P.unit,P.value) from PerformanceValue P where P.regionNo=？　and P.reportDate=？ and P.perfCode in ？

 

注意在ｎｅｗ的对象的参数列表里，最好使用别名点取的方式，而不是直接使用字段名称，可能报未知字段的错误

使用这种操作的前提是，你在类 PerformanceValue里已经定义了与上述参数类型相同的构造方法，否则ｈｉｂｅｒｎａｔｅ是不认的

 

OK，使用这样的方式，你就可以自由的决定本操作需要ｈｉｂｅｒｎａｔｅ给你查取哪些字段封装进ｂｅａｎ里了

 

再举一例，在类IR_Device_Pstn中，使用组建映射，映射组建类为PublicInfos

那么要写成上面的限定字段查询方式，应该这样写：

定义IR_Device_Pstn的一个需要的字段的构造方法

/**为数据抽取需要的命名查询准备的构造方法*/ public IR_Device_Pstn( String provinceName, String provinceCode, String cityName, String cityCode, String siteName, String deviceName, String vendorName, String deviceModel, String softwareVersionBig, String softwareVersionSma, byte roles, String otherRoles, long e1Capacity, long e1CapacityOccupied, long userPortCapacity, long userPortCapacityOccupied, long freeRelayBoardNum, long freeUserBoardNum, Date startTime, byte assetUseStatus, String parentAssetCardNo, String assetCardNo, Date createDate,Date modifyDate,long idInProvince){ this.provinceName = provinceName; this.provinceCode = provinceCode; this.cityName = cityName; this.cityCode = cityCode; this.siteName = siteName; this.deviceName = deviceName; this.vendorName = vendorName; this.deviceModel = deviceModel; this.softwareVersionBig = softwareVersionBig; this.softwareVersionSma = softwareVersionSma; this.roles = roles; this.otherRoles = otherRoles; this.e1Capacity = e1Capacity; this.e1CapacityOccupied = e1CapacityOccupied; this.userPortCapacity = userPortCapacity; this.userPortCapacityOccupied = userPortCapacityOccupied; this.freeRelayBoardNum = freeRelayBoardNum; this.freeUserBoardNum = freeUserBoardNum; this.startTime = startTime; this.assetUseStatus = assetUseStatus; this.parentAssetCardNo = parentAssetCardNo; this.assetCardNo = assetCardNo; publicInfos = new PublicInfos();//必须new一个对象出来 this.publicInfos.setCreateDate(createDate); this.publicInfos.setModifyDate(modifyDate); this.publicInfos.setIdInProvince(idInProvince); }

注意上面对PublicInfos类的字段及对象的处理

HQL应该这样写:

select new IR_Device_Pstn(p.provinceName,p.provinceCode,p.cityName, p.cityCode,p.siteName,p.deviceName,p.vendorName,p.deviceModel,p.softwareVersionBig, p.softwareVersionSma,p.roles,p.otherRoles,p.e1Capacity,p.e1CapacityOccupied,p.userPortCapacity, p.userPortCapacityOccupied,p.freeRelayBoardNum,p.freeUserBoardNum,p.startTime,p.assetUseStatus, p.parentAssetCardNo,p.assetCardNo,p.publicInfos.createDate,p.publicInfos.modifyDate, p.publicInfos.idInProvince) from IR_Device_Pstn p