getHibernateTemplate()_gethibernatetemplate]-CSDN博客

本文链接：https://blog.csdn.net/masuwen/article/details/6017631

getHibernateTemplate().execute(new HibernateCallback(){
            public Object doInHibernate(Session session)throws HibernateException, SQLException {
                SQLQuery query = session.createSQLQuery(hql);
                if( ps != null && ps.length > 0 ){
                    for( int i= 0;i < ps.length; i++ ){
                        query.setParameter(i, ps[i]);
                    }
                }
                return ((Integer)query.list().iterator().next()).intValue();

            }
        });

//----------------

getHibernateTemplate().executeFind(new HibernateCallback(){
            public Object doInHibernate(Session session)throws HibernateException, SQLException {
                SQLQuery query = session.createSQLQuery(hql);
                if( ps != null && ps.length > 0 ){
                    for( int i = 0;i < ps.length; i++ ){
                        query.setParameter(i, ps[i]);
                    }
                }
                query.setFirstResult(firstResult);
                query.setMaxResults(maxResult);
                return     query.list();
            }
        });