请教一下hibernate执行sql的问题

Question

对hibernate不太熟悉，不会转换为原生sql，代码如下，我要把sql改为select u.loginname,u.username from Organization a,Sam_Taxempcode u where a.DistrictNumber=u.district_id 要怎么做 public PagingResult<UserInfo> finduser(UserCond qry, PagingParam pp) { logger.debug("call findusers()"); String loginname = null; String username=null; String district=""; if ( qry != null ){ loginname = qry.getLoginname().trim(); username=qry.getUsername().trim(); district=String.valueOf(qry.getDistrict()); } if ( pp == null ) pp = new PagingParam(); int end = pp.getStart() + pp.getLimit(); List params = new ArrayList(); String orderBy = " order by u.loginname"; String sql = "select new cn.net.tongfang.framework.security.bo.UserInfo(u) from SamTaxempcode u "; StringBuffer hql = new StringBuffer(sql); StringBuffer cond = new StringBuffer(); if ( loginname != null && ! loginname.trim().equals("")) { cond.append( " and u.loginname like ? " ); params.add("%" + loginname.trim() + "%"); } if ( username !=null && ! username.trim().equals("")){ cond.append(" and u.username like ? "); params.add("%" + username.trim() + "%"); } if(district !=null && ! district.trim().equals("")){ cond.append(" and a.id= ? "); params.add(district); } if ( params.size() > 0 ) { hql.append(" where 1=1 ").append( cond ); //hql.append(" where 1=1 a.DistrictNumber=u.district_id ").append( cond ); } hql.append( orderBy ); List list; if ( params.size() > 0 ) { list = getHibernateTemplate().find(hql.toString(), params.toArray()); } else { list = getHibernateTemplate().find(hql.toString()); } end = (end < list.size()) ? end : list.size(); List<UserInfo> result = list.subList(pp.getStart(), end); return new PagingResult<UserInfo>(list.size(), result); }