hibernate查询返回DTO对象，DTO封装了多个pojo对象的属性
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)
)