Hibernate的VO在HQL语句中的应用
HQL语句为：
select new com.xxx.vo.TAdminDefineReportVo(a.defineReportId,a.reportTmpId,
????? c.reportName,a.admin,a.reportType,a.description,
????? a.status,a.createTime,a.autoSend,a.emails,b.userName)
from TAdminDefineReport a,TReportTemplate c,TAdminInfo b
where a.reportTmpId = c.reportTmpId
and a.admin = b.administrorId
and a.admin = ?? $queryClause$
order by? a.reportTmpId desc,a.createTime desc
?
DaoImpl类：
?public Pagination getAdminRepByAdmId(int admId,String queryName,String reportType,String startTime,String endTime){
??try{
???String hql = this.getHql("repTmp.hql10");
???
???StringBuilder sb = new StringBuilder();
???if(("".equals(queryName)||queryName==null)&&("-1".equals(reportType)||reportType==null)
?????&&("".equals(startTime)||startTime==null)&&("".equals(endTime)||endTime==null)){
????hql = hql.replace("$queryClause$", "");
???}
???if(!"".equals(queryName) && queryName != null){
????sb.append(" and b.reportName like '%" + queryName + "%'");
???}
???if(!"-1".equals(reportType)&&!"".equals(reportType)){
????sb.append(" and a.reportType = '" + reportType + "'");
???}
???if(!"".equals(startTime) && startTime != null){
????sb.append(" and a.createTime >= '" + startTime + "'");
???}
???if(!"".equals(endTime) && endTime != null){
????sb.append(" and a.createTime <= '" + endTime + "'");
???}
???hql = hql.replace("$queryClause$", sb.toString());
???
???return this.searchPaginated(hql,admId);
??}catch(Exception e){
???logger.error(e.getMessage());
???throw new PersistenceException(e.getMessage());
??}
?}
