如下所示只能执行非Select语句:
public static void executeSQL(HibernateTemplate hibernateTemplate,
String sql)
{
final String tempsql = sql;
hibernateTemplate.execute(new HibernateCallback()
{
public Object doInHibernate(Session session)
throws HibernateException
{
session.createQuery(tempsql).executeUpdate();
return null;
}
});
}
若要执行Select则用session.createQuery(tempsql).list();
此处final String tempsql = sql;必须为final 表示tempsql不可以修改;
内联类的要求;
public Object doInHibernate(Session session)返回Object等于hibernateTemplate.execute(new HibernateCallback()的返回,可以通过查看源代码看的出来;
下面是执行select语句的情况:
return (List)hibernateTemplate.execute(new HibernateCallback()
{
public Object doInHibernate(Session session)
throws HibernateException
{
List list=session.createQuery(tempsql).list();
return list;
}
});
使用Query能提供更加灵活的查询:
@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;
}