问题描述

跪求高手指导hibernate此hql 怎么写

hql = "select distinct u from User " 跪求高手指导此hql 怎么写
用hql查询User 的时候， 只(ˇ?ˇ） 想～查出User 以及User .Station.id、User .Station.name、.User Station.dept，以及User Station.dept.id、User Station.dept.name 因为不这样的话 执行效率太低了。页面刷新很慢%>_<%
[code=java]
public class User implements Serializable{

private static final long serialVersionUID = 7259027197507200040L;
private String id;
private String username;
private String password;
private int status;
private UserInfo userInfo;
private Set<Station> stations;

private Set<Role> roles;

public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getUsername() {
    return username;
}
public void setUsername(String username) {
    this.username = username;
}
public String getPassword() {
    return password;
}
public void setPassword(String password) {
    this.password = password;
}
public UserInfo getUserInfo() {
    return userInfo;
}
public void setUserInfo(UserInfo userInfo) {
    this.userInfo = userInfo;
}

public Set<Station> getStations() {
    return stations;
}
public void setStations(Set<Station> stations) {
    this.stations = stations;
}

public Set<Role> getRoles() {
    return roles;
}
public void setRoles(Set<Role> roles) {
    this.roles = roles;
}
public int getStatus() {
    return status;
}
public void setStatus(int status) {
    this.status = status;
}

[/code]
[code=java]
public class Station implements Serializable{

private static final long serialVersionUID = 1L;
private String id;
private String name;
private String descContent;
private Date createTime;
private int status;
private Dept dept;

private Set<User> users;

private Set<DimTag> dimTags;

public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getName() {
    return name;
}
public void setName(String name) {
    this.name = name;
}
public String getDescContent() {
    return descContent;
}
public void setDescContent(String descContent) {
    this.descContent = descContent;
}
public Date getCreateTime() {
    return createTime;
}
public void setCreateTime(Date createTime) {
    this.createTime = createTime;
}
public Dept getDept() {
    return dept;
}
public void setDept(Dept dept) {
    this.dept = dept;
}
public Set<User> getUsers() {
    return users;
}
public void setUsers(Set<User> users) {
    this.users = users;
}
public Set<DimTag> getDimTags() {
    return dimTags;
}
public void setDimTags(Set<DimTag> dimTags) {
    this.dimTags = dimTags;
}
public int getStatus() {
    return status;
}
public void setStatus(int status) {
    this.status = status;
}

}

[/code]
[code=java]
public class Dept implements Serializable{

private static final long serialVersionUID = 1L;
private String id;
private String name;

private Dept parent;
private String bh;
private String descContent;
private int status;
private Set<Station> station;

public Set<Station> getStation() {
    return station;
}
public void setStation(Set<Station> station) {
    this.station = station;
}
public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getName() {
    return name;
}
public void setName(String name) {
    this.name = name;
}
public Dept getParent() {
    return parent;
}
public void setParent(Dept parent) {
    this.parent = parent;
}
public String getBh() {
    return bh;
}
public void setBh(String bh) {
    this.bh = bh;
}
public String getDescContent() {
    return descContent;
}
public void setDescContent(String descContent) {
    this.descContent = descContent;
}
public int getStatus() {
    return status;
}
public void setStatus(int status) {
    this.status = status;
}

}

[/code]
跪求高手指导hibernate此hql 怎么写

解决方案

可以返回station再拿出来处理，select distinct u.stations from User u
楼主似乎并没有设置懒加载，如@ManyToOne(fetch = FetchType.LAZY)
请楼主恶补下