pagesmax.java

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

package com.gensou.util;

import org.hibernate.Query;
import org.hibernate.Session;

import com.gensou.hibernate.model.Yuangongxinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;

public class PagesMax {
  public static int max(String hql){
	  int maxpage;
	  int max;
	    Session session=HibernateSessionFactory.getSession();
	    Integer a =(Integer)session.createQuery(hql).uniqueResult();
		max=a.intValue();
		Pagination pag=new Pagination();
		maxpage=pag.getMaxpage(max);
	  return maxpage;
  }
  public static int maxs(String way,String trem){
	  int maxpage;
	  int max;
	  Integer id=Integer.parseInt(way);
	  Session session=HibernateSessionFactory.getSession();
	  Query query;
	  Yuangongxinxi yuangongxinxi=(Yuangongxinxi)session.load(Yuangongxinxi.class,id);
	  query =session.createQuery("select count(id) from Kaoqinbiao where yuangongxinxi=? and kaoqinshijian like '%"+trem+"%').uniqueResult()");
	  query.setEntity(0, yuangongxinxi);
	  Integer a=(Integer)query.uniqueResult();
	  max=a.intValue();
	  Pagination pag=new Pagination();
	  maxpage=pag.getMaxpage(max);
	  return maxpage;
  }
}