Java实体对象外键关联注解_Hibernate-select new Object(Entity obj)非主外键关联对象查询...

Hibernate-select new Object(Entity obj)非主外键关联对象查询[@more@]

1.定义实体类

/**

* Name: net.uni.in1.model.RoleDict.java

* Version: 1.0

* Date: 2011-11-21

* Author: Administrator

*/

package net.uni.in1.model;

/**

* 处理内容: 用于多表非主外键联合查询用的

* @version: 1.0

* @see:net.uni.in1.model.RoleDict.java

* @date:2011-11-21

* @author:孙伟

*/

public class RoleDict {

private Role role = new Role();

private String dictName;

private String code;

private Long dictUniqNo;

/**

*

Title:

*

Description:

* @param role

* @param dictName

* @param code

* @param dictUniqNo

*/

public RoleDict(Object role, String dictName, String code, Long dictUniqNo) {

super();

this.role = (Role)role;

this.dictName = dictName;

this.code = code;

this.dictUniqNo = dictUniqNo;

}

public RoleDict() {

super();

// TODO Auto-generated constructor stub

}

public String getDictName() {

return dictName;

}

public void setDictName(String dictName) {

this.dictName = dictName;

}

public String getCode() {

return code;

}

public void setCode(String code) {

this.code = code;

}

public Long getDictUniqNo() {

return dictUniqNo;

}

public void setDictUniqNo(Long dictUniqNo) {

this.dictUniqNo = dictUniqNo;

}

public Role getRole() {

return role;

}

public void setRole(Role role) {

this.role = role;

}

}

2.hql语句

String sql = "SELECT e as role,t.name as dictName,t.code as code,t.dictUniqNo as dictUniqNo FROM net.uni.in1.model.Role e,net.uni.in1.model.Dict t WHERE e.uniqNo=t.dictUniqNo";

注意：as后面的名称要与实体类里面的成员变量名称类型相同

3.创建query

Query query=this.getSession().createQuery(sql).setResultTransformer(Transformers.aliasToBean(net.uni.in1.model.RoleDict.class));

RoleDict就是你需要new出来的object

最后query.list的结果就是List