hibernate 执行原生SQL

public class VO{
    private String buyerEmail,value,createDt;

    //setter & getter
}

 

StringBuilder sql = new StringBuilder("select buyer_Email buyerEmail,value,createDt from t");
		
		Query query = this.getCurrentSession().createSQLQuery(sql.toString())
				.addScalar("buyerEmail",Hibernate.STRING)
				.addScalar("value",Hibernate.STRING)
				.addScalar("createDt", Hibernate.DATE)
				.setResultTransformer(
					Transformers.aliasToBean(VO.class));

		return query.list();