emp.java

serverlet+exlips的一个素据库读取例程。

/*
 * Created Thu Mar 02 08:59:06 CST 2006 by MyEclipse Hibernate Tool.
 */
package lyzn.logic.hibernate;

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

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

/**
 * A class that represents a row in the 'EMP' table. This class may be
 * customized as it is never re-generated after being created.
 */
public class Emp extends AbstractEmp implements Serializable {
	/**
	 * Simple constructor of Emp instances.
	 */
	public Emp() {
	}

	/**
	 * Constructor of Emp instances given a simple primary key.
	 * 
	 * @param empno
	 */
	public Emp(java.lang.Short empno) {
		super(empno);
	}

	/* Add customized code below */
	public List getPageData(int page) {
		Session session = HibernateSessionFactory.currentSession();
		Query query=session.createQuery("SELECT t FROM lyzn.logic.hibernate.Emp t");
		query.setFirstResult((page-1)*5+1);
		query.setMaxResults(5);
		List list=query.list();
		if(list!=null && list.size()>0){
			return list;
		}
		HibernateSessionFactory.closeSession();
		return null;
	}
//	public static void main(String[] args){
//		Emp emp=new Emp();
//		List list=emp.getPageData(10);
//		System.out.println(list);
//	}
}