hibernate 实施原生SQL

2013-03-25

hibernate 执行原生SQLStringBuilder sql new StringBuilder(select buyer_Email buyerEmail,value,cre

hibernate 执行原生SQL
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();