01: /**********************************************************************************
02: * $URL: https://source.sakaiproject.org/svn/sam/trunk/component/src/java/org/sakaiproject/tool/assessment/facade/util/PagingUtilQueries.java $
03: * $Id: PagingUtilQueries.java 9273 2006-05-10 22:34:28Z daisyf@stanford.edu $
04: ***********************************************************************************
05: *
06: * Copyright (c) 2004, 2005, 2006 The Sakai Foundation.
07: *
08: * Licensed under the Educational Community License, Version 1.0 (the"License");
09: * you may not use this file except in compliance with the License.
10: * You may obtain a copy of the License at
11: *
12: * http://www.opensource.org/licenses/ecl1.php
13: *
14: * Unless required by applicable law or agreed to in writing, software
15: * distributed under the License is distributed on an "AS IS" BASIS,
16: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17: * See the License for the specific language governing permissions and
18: * limitations under the License.
19: *
20: **********************************************************************************/package org.sakaiproject.tool.assessment.facade.util;
21:
22: import java.util.ArrayList;
23: import java.util.List;
24:
25: import org.apache.commons.logging.Log;
26: import org.apache.commons.logging.LogFactory;
27: import org.springframework.orm.hibernate3.HibernateCallback;
28: import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
29: import org.hibernate.HibernateException;
30: import org.hibernate.Query;
31: import org.hibernate.ScrollableResults;
32: import org.hibernate.Session;
33:
34: public class PagingUtilQueries extends HibernateDaoSupport implements
35: PagingUtilQueriesAPI {
36: private static Log log = LogFactory.getLog(PagingUtilQueries.class);
37:
38: public PagingUtilQueries() {
39: }
40:
41: public List getAll(final int pageSize, final int pageNumber,
42: final String queryString) {
43:
44: HibernateCallback callback = new HibernateCallback() {
45: public Object doInHibernate(Session session)
46: throws HibernateException {
47: ArrayList page = new ArrayList();
48: Query q = session.createQuery(queryString);
49: ScrollableResults assessmentList = q.scroll();
50: if (assessmentList.first()) { // check that result set is not empty
51: int first = pageSize * (pageNumber - 1);
52: int i = 0;
53: assessmentList.setRowNumber(first);
54: assessmentList.beforeFirst();
55: while ((pageSize > i++) && assessmentList.next()) {
56: log.debug("**** add " + i);
57: page.add(assessmentList.get(0));
58: }
59: }
60: return page;
61: }
62: };
63: List pageList = (List) getHibernateTemplate().execute(callback);
64: return pageList;
65: }
66:
67: }
|