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