hibernate查询返回DTO对象,DTO封装了多个pojo对象的属性

tianhennan 2016-01-15

DTO-数据传输对象;pojo-最纯粹的java对象与数据库中表的字段一一对应。

简单讲:DTO起到业务数据的传递作用,数据转换成JAVA对象。

 

1.查询语句

publicvoid testSqlOneToMany(){   

       String hql="select f.id, f.machinenum,f.types_id,t.id as typeId,t.name from gjp_fault f,gjp_type t where f.types_id = t.id";

 

       SQLQuery query = getSession().createSQLQuery(hql);

       List<ManyToVo> list = query.setResultTransformer(Transformers.aliasToBean(ManyToVo.class)).list();

      

       System.out.println(list.size());

    }

2.数据封装成对象(DTO

package bh.test.vo;

import java.math.BigDecimal;

 

publicclass ManyToVo {

   

    private BigDecimal ID;

    private String MACHINENUM; //machinenum;

   

    private BigDecimal TYPES_ID;

   

    private BigDecimal TYPEID;

   

    private String NAME;

 

    public String getNAME() {

       returnNAME;

    }

    publicvoid setNAME(String name) {

       NAME = name;

    }

    public BigDecimal getID() {

       returnID;

    }

    publicvoid setID(BigDecimal id) {

       ID = id;

    }

    public BigDecimal getTYPEID() {

       returnTYPEID;

    }

    publicvoid setTYPEID(BigDecimal typeid) {

       TYPEID = typeid;

    }

    public BigDecimal getTYPES_ID() {

       returnTYPES_ID;

    }

    publicvoid setTYPES_ID(BigDecimal types_id) {

       TYPES_ID = types_id;

    }

    public String getMACHINENUM() {

       returnMACHINENUM;

    }

    publicvoid setMACHINENUM(String machinenum) {

       MACHINENUM = machinenum;

    }

 

}

 

 

3.数据表结构

createtable GJP_FAULT

(

  ID         NUMBER(10) notnull,

  DATETIME   TIMESTAMP(6),

  MACHINENUM VARCHAR2(255CHAR),

  TYPES_ID   NUMBER(10)

)

 

createtable GJP_TYPE

(

  ID   NUMBER(10) notnull,

  NAMEVARCHAR2(255CHAR)

)

相关推荐

migowei / 0评论 2020-09-17