accessoryselltabledao.java

一个汽车售后服务站的典型的进销管理系统,B/S模式的

package com.xfaccp.dao;

import java.util.List;

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

import com.xfaccp.adapter.DAOAdpater;


/**
 * Data access object (DAO) for domain model class AccessorySellTable.
 * 
 * @see com.xfaccp.form.AccessorySellTable
 * @author MyEclipse Persistence Tools
 */

public class AccessorySellTableDAO extends DAOAdpater{
	
	public List findAllList() throws Exception {
		return getHibernateTemplate().find("from com.xfaccp.form.AccessorySellTable");
	}

	public List findById(Integer id) 
	throws Exception {
		String hql = "from AccessorySellTable where id="+id;
		List list = getHibernateTemplate().find(hql);
		return list;
	}
	
	public List getSellTableList(int size, int pageSize) throws Exception {
		// TODO Auto-generated method stub
		List list;
		Session session = getSession();
		try {
			Query q = session.createQuery("from com.xfaccp.form.AccessorySellTable");
			q.setFirstResult(size);
			q.setMaxResults(pageSize);	
			list = q.list();	
		} finally{
			session.close();
		}
		return list;
	}
	
	public int getSellTableSize() throws Exception {
		// TODO Auto-generated method stub
		
		String hql=" select count(*) from com.xfaccp.form.AccessorySellTable";
		List list=this.getHibernateTemplate().find(hql);
		int count1=(Integer)list.get(0);
		//System.out.println(" list size"+list.get(0));
		return count1;
	}
}