zhoubaowaiwangfuwuqidao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ZhoubaoWaiwangfuwuqiDAO extends HibernateDaoSupport{
	
	/**
	 * 判断时候已经添加了周报,防止重复提交本周周报
	 * @param weeklyofyear
	 * @return
	 */
	public boolean isRepeat(String weeklyofyear){
		List list = null;
		try {  
			list = (List)this.getHibernateTemplate().find("from ZhoubaoWaiwangfuwuqi where weeklyofyear=?",weeklyofyear);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		   if(list.size()==0){
				return true;
			}else{
				return false;
			}
	}
	
	/**
	 * 添加周报
	 * @param zoubaowaiwangfuwuqi
	 */
	public void addZhoubaoWaiwangfuwuqi(ZhoubaoWaiwangfuwuqi zhoubaoWaiwangfuwuqi){
		try { 
			this.getHibernateTemplate().save(zhoubaoWaiwangfuwuqi);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	/**
	 * 查询所有的周报周期
	 * @return
	 */
	public List findAllZhoubaoWaiwangfuwuqi(){
		List list = null;
		try {  
			list = (List)this.getHibernateTemplate().find("from ZhoubaoWaiwangfuwuqi group by weeklyofyear");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * 查询一期的周报
	 * @param weeklyofyear
	 * @return
	 */
	public List findOneZhoubaoWaiwangfuwuqi(String weeklyofyear){
		List list = null;
		try {  
			list = (List)this.getHibernateTemplate().find("from ZhoubaoWaiwangfuwuqi where weeklyofyear=?",weeklyofyear);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			if(list!=null&&list.size()!=0){
				return list;
			}else{
				return null;
			}
	}
	
	/**
	 * 查询一期周报的一条记录
	 * @param weeklyofyear
	 * @return
	 */
	public List findZhoubaoWaiwangfuwuqi(String weeklyofyear){
		 List list = null;
			try {  
				list = (List)this.getHibernateTemplate().find("from ZhoubaoWaiwangfuwuqi where weeklyofyear=? group by weeklyofyear",weeklyofyear);
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return list;
	}
}