zhoubaolxjcdao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ZhoubaoLxjcDAO extends HibernateDaoSupport {

	/**
	 * 添加周报
	 * @param zhoubaoLxjc
	 */
	public void addZhoubao(ZhoubaoLxjc zhoubaoLxjc) {
		try {  
			this.getHibernateTemplate().save(zhoubaoLxjc);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	/**
	 * 查询周报
	 * @param weeklyofyear
	 * @return
	 */
	public List findZhoubao(String weeklyofyear){
		 List list = null;
			try {  
				list = (List)this.getHibernateTemplate().find("from ZhoubaoLxjc where weeklyofyear=?",weeklyofyear);
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return list;
	}
	
	/**
	 * 查询所有的周报
	 * @return
	 */
	public List findAllZhoubao(){
		 List list = null;
			try {  
				list = (List)this.getHibernateTemplate().find("from ZhoubaoLxjc group by weeklyofyear");
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return list;
	}
	
	/**
	 * 判断周报是否已经提交
	 * @param weeklyofyear
	 * @return
	 */
	public boolean isRepeat(String weeklyofyear){
		List list = null;
		try {  
			list =(List)this.getHibernateTemplate().find("from ZhoubaoLxjc where weeklyofyear=?",weeklyofyear);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if(list.size()==0){
			return true;
		}else{
			return false;
		}
		
	}
	
	/**
	 * 查询一条记录
	 * @param weeklyofyear
	 * @return
	 */
	public List findOneZhoubaoByWeeklyofyear(String weeklyofyear){
		List list = null;
		try {  
			list = (List)this.getHibernateTemplate().find("from ZhoubaoLxjc where weeklyofyear=? group by weeklyofyear",weeklyofyear);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if(list!=null&&list.size()!=0){
			return list;
		}else{
			return null;
		}
	}
}