HQL distinct使用

HQL查询过滤重复的对象

java 类如下

package test;

public class TestDistinct {
	private long id = 0;
	private int code = 0;
	private String msg = "";
	
	public TestDistinct(){
		
	}
	public TestDistinct(int code ,String msg){
		this.code = code;
		this.msg = msg;
	}
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public int getCode() {
		return code;
	}
	public void setCode(int code) {
		this.code = code;
	}
	public String getMsg() {
		return msg;
	}
	public void setMsg(String msg) {
		this.msg = msg;
	}
	
	
}

 映射文件略

.............................

 

HQL

select distinct new test.TestDistinct(code,name) from TestDistinct

评论

3 楼 unique.wu 2012-07-09  

Hillen.chan 写道

仁兄：
select distinct new test.TestDistinct(class,code,name) from TestDistinct,Class
1，当TestDistinct 类中有另一对象class时，distinct 此时是否还管用？
2，这该怎么进行group by ?

好久没用hibernate了，抱歉，没有深究过呢。。

2 楼 Hillen.chan 2012-04-18  

仁兄：
select distinct new test.TestDistinct(class,code,name) from TestDistinct,Class
1，当TestDistinct 类中有另一对象class时，distinct 此时是否还管用？
2，这该怎么进行group by ?

1 楼 rmn190 2010-09-07  

Hibernate太强了， 谢谢分享！