HibernateTemplate执行普通sql语句

@Override
public List<ViewRecord> getViewRecordByUserAndRandom6(int userId) {
	final int userIdf = userId;
	List<ViewRecord> viewRecordList = this.getHibernateTemplate().executeFind(new HibernateCallback() {
	public Object doInHibernate(Session session) throws HibernateException, SQLException {
         SQLQuery query = session.createSQLQuery("select * from viewrecord where userId=? order by rand() limit 6");  
	query.setInteger(0, userIdf);
	return query.list();
			}
		});
	return viewRecordList;
	}

或者

@Override
public List<ViewRecord> getViewRecordByUserAndRandom6(int userId) {
   String sql = "select * from viewrecord where userId=? order by rand() limit 6"
   Session session = this.getSession();
   List<ViewRecord> viewRecordList = session.createSQLQuery(sql).list();
   return viewRecordList;
}

评论

2 楼 zongshoujin 2012-12-11  

这样的sql语句，hibernate会自动给数据集封装成一个一个的实体类吗？

1 楼 zongshoujin 2012-12-11  

但是我这样写的，返回值是List<Cost>,在service层在迭代取得时候会报类型转换异常的！请教！