pagedao.java

struts+hibernate做的一个程序

package com.po;
import java.util.List;
import java.util.Set;
import java.util.Vector;

import com.struts.form.*;

import org.hibernate.*;
import com.share.*;
public class PageDao {
	/**
	 * 获取最大行数
	 * return @maxrow
	 * */
	public int getmaxRow(){
		Session session=HibernateSessionFactory.getSession();
		Query ql=session.createQuery("select count(*) from Emp");
		List ls=ql.list();
		Integer num=(Integer) ls.get(0);
		return num.intValue();
	}
	/**
	 * 获取最大页数
	 * return @maxpage
	 * */
	public int getMaxpage(){
		int maxrow=this.getmaxRow();
		if(maxrow==0){
			maxrow=1;
		}
		if(maxrow%5==0){
			return maxrow/5;
		}else{
			return maxrow/5+1;
		}
		
	}
	/**
	 * 返回每页显示的数据
	 * return @pagedata
	 * */
	public Vector getPagedata(int currentpage){
		int maxpage=this.getMaxpage();
		if(currentpage>maxpage){currentpage=maxpage;}
		if(currentpage<1){currentpage=1;}
		Session session=HibernateSessionFactory.getSession();
		Query ql=session.createQuery("from Emp order by eid desc");
		ql.setFirstResult((currentpage-1)*5);
		ql.setMaxResults(5);
		List ls=ql.list();
		Vector vc=new Vector();
		for (int i = 0; i < ls.size(); i++) {
			EmpForm ef=new EmpForm();
			Emp emp=(Emp) ls.get(i);
			//将持久化对象转换为VO（formbean对象）
			ef.setEid(emp.getEid().toString());
			ef.setEname(emp.getEname());
			ef.setSex(emp.getSex());
			ef.setAddress(emp.getAddress());
			ef.setBorthday(emp.getBorthday().toLocaleString());
			ef.setDepid(emp.getDep().getDepid().toString());
			ef.setDepname(emp.getDep().getDepname());
			//将员工的爱好对象传递给员工的formbean对象
			Set emploves=emp.getEmploves();
			Object[] ob=emploves.toArray();
			Vector lovevc=new Vector();
			String[] loveid=new String[ob.length];
			for (int j = 0; j < ob.length; j++) {
				Emplove el=(Emplove) ob[j];
				LoveForm lf=new LoveForm();
				Love lv=el.getLove();
				loveid[j]=lv.getLid().toString();
				lf.setLid(lv.getLid().toString());
				lf.setLname(lv.getLname());
				lovevc.add(lf);
				
			}
			ef.setLoveid(loveid);
			ef.setLoves(lovevc);
			vc.add(ef);
		}
		return vc;
		
	}
}