package com.liferay.article.service.persistence;

import java.util.List;
import com.liferay.article.model.Student;
import com.liferay.article.model.impl.StudentImpl;
import com.liferay.portal.kernel.dao.orm.QueryPos;
import com.liferay.portal.kernel.dao.orm.QueryUtil;
import com.liferay.portal.kernel.dao.orm.SQLQuery;
import com.liferay.portal.kernel.dao.orm.Session;
import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
import com.liferay.util.dao.orm.CustomSQLUtil;

public class StudentFinderImpl extends BasePersistenceImpl<Student> implements StudentFinder {
	public List<Student> getStudentBetweenStudentId(int start, int end) {
		Session session = null;
		try {
			session = openSession();
			String sql = CustomSQLUtil.get("studentBetweenQuery");
			SQLQuery queryObject = session.createSQLQuery(sql);
			queryObject.setCacheable(false);
			queryObject.addEntity("Student", StudentImpl.class);
			QueryPos qPos = QueryPos.getInstance(queryObject);
			qPos.add(start);
			qPos.add(end);
			return (List<Student>) queryObject.list();
			// return (List<Student>)
			// QueryUtil.list(queryObject,getDialect(),start, end);// for
			// pagination feature
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			closeSession(session);
		}
		return null;
	}
}