How can I use the HQL statement to query out part of the data in Hibernate3 and return the object?

For example, there is now a customer object

public class customer{

Private Integer CID;

Private String CNAME;

Private Integer cage;

}

Now say in hibernate use HQL to find out the CNAME a column value, and then encapsulate it as an object, ask Hql how to write (projection operation)?

Resolution: 1. Add a constructor with a parameter to the Customer entity class

public class customer{

Public Customer () {

Super ();

}

Public Customer (String CNAME) {

Super ();

This.cname = CNAME;

}

Private Integer CID;

Private String CNAME;

Private Integer cage;

}

2.HQL written so list<customer> lists = Session.createquery ("Select New Customer (CNAME) Form customer");

How can I use the HQL statement to query out part of the data in Hibernate3 and return the object?