Skip to content

Instantly share code, notes, and snippets.

@Mukundhan-I2I
Forked from dragester/CustomerDTO.java
Created January 18, 2018 11:55
Show Gist options
  • Save Mukundhan-I2I/595a2e7042a6d93eea3b549da36d3fcd to your computer and use it in GitHub Desktop.
Save Mukundhan-I2I/595a2e7042a6d93eea3b549da36d3fcd to your computer and use it in GitHub Desktop.
usage example of org.hibernate.Transformers.aliasToBean
public class CustomerDTO {
private String firstName, lastName;
// getter & setters
}
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.transform.Transformers;
...
SQLQuery query = session.createSQLQuery("SELECT FNAME as firstName, LNAME as lastName FROM CUSTOMER");
query.setResultTransformer(Transformers.aliasToBean(CustomerDTO.class));
query.addScalar("firstName").addScalar("lastName");
List<CustomerDTO> list = query.list();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment