src/com/oa/web/AbstractServices.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.oa.web;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;



public abstract class AbstractServices extends HibernateDaoSupport {
	
	public PageModel searchPaginated(String hql){
		return searchPaginated(hql, null);
	}
	
	public PageModel searchPaginated(String hql,Object[] values){
		return searchPaginated(hql, values, SystemContext.getOffset(), SystemContext.getPagesize());
	}
		
	public PageModel searchPaginated(String hql,Object value,int offset,int pagesize){
		return searchPaginated(hql, new Object[]{value}, offset, pagesize);
	}
	/**
	 * 
	 *
	 * 功能：公共分页1
	 *
	 */
	public List query(final String hql, final int currentpage,
			final int pageunit, final Object... Params) throws Exception {
		return (List) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session)
							throws HibernateException, SQLException {
						Query q = session.createQuery(hql);
						if (Params != null && Params.length > 0) { // 取出可变参数中设置的条件
							int i = 0;
							for (Object obj : Params) {
								if (obj != null) {
									q.setString(i, obj.toString());
									i++;
								}
							}
						}
						// q.setFirstResult((currentpage-1)*pageunit); //分页展现
						// q.setMaxResults(pageunit);
						try {
							page(q, currentpage, pageunit);
						} catch (Exception e) {
							e.printStackTrace();
						}
						List list = q.list();
						return list;
					}
				});