HQL多表查询(Hibernate3)

最新推荐文章于 2022-10-21 18:10:13 发布

CTOCLUB

最新推荐文章于 2022-10-21 18:10:13 发布

阅读量2.4k

点赞数

分类专栏： J2EE 文章标签： hibernate string list query 中国电信

本文链接：https://blog.csdn.net/leo821031/article/details/1521410

版权

J2EE 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

/**
*Feb 20, 2007
* Zhou JianGuo
* 小白
* 中国电信上海技术研究院
* MSN:zhuojianguo_leo@hotmail.com
*/

查询拼接

String count="select count(*) from DeviceInfo";
  String query = "select new com.procedure.hibernate.oracle10.getHibernateTemplate.model.DeviceInfo(info.id,info.cpycde,info.orgcde,info.numb,info.name,info.bookin,(select dic.annexa from HrUserDic dic where dic.dicname=info.model and dic.dicid='EMP0024') as emp0024,(select dic.annexa from HrUserDic dic where dic.dicname=info.factory and dic.dicid='EMP0023') as emp0023) from DeviceInfo info order by info.numb,info.cpycde,info.orgcde";
  String queryURL="deviceAction.asp";
  List list=new ArrayList();
  int totalRows=new PageQuery().pageQuery(count);
        Pager page=PageHelp.getPager(request,totalRows);
  list=new PageQuery().search(page.getPageSize(),page.getStartRow(),query);
  request.setAttribute("list",list);
  request.setAttribute("page",page);
  request.setAttribute("queryURL", queryURL);
  return mapping.findForward(LIST);

需要在PO里构造一个方法

    public DeviceInfo() {
    }
    public DeviceInfo(String id,String cpycde,String orgcde,String numb,String name,String bookin,String model,String factory) {
    this.id=id;
    this.cpycde=cpycde;
    this.orgcde=orgcde;
    this.numb=numb;
    this.name=name;
    this.bookin=bookin;
    this.model=model;
    this.factory=factory;
    }