weeklycircledao.java

一个oa系统

package com.oa.db;

import java.util.List;

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


public class WeeklycircleDAO extends HibernateDaoSupport{
	public void Save(Weeklycircle vo){//保存周报周期
    	try {
    		this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    }
	
	
	public List QueryPeriod(){//查询最新周期也就是最后一周期号
		List list = null;
		try {//System.out.println("getHibernateTemplate():"+getHibernateTemplate());
			   list = this.getHibernateTemplate().find("from Weeklycircle order by id DESC");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryAllPeriod(){//查询所有周期
		List list = null;
		try {
			   list = this.getHibernateTemplate().find("from Weeklycircle");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryPeriodByperiod(int period){//查询最新周期也就是最后一周期号
		List list = null;
		try {
			   list = this.getHibernateTemplate().find("from Weeklycircle where period = ?",period);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
}