directorweeklydao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class DirectorweeklyDAO extends HibernateDaoSupport{
	
	public List ByUseridAndPeriodQuery(String userid,String period) {// 通过员工姓名和周期查询周报信息
		List list = null; 
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where userid=? and period=?",new Object[]{userid,period});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void Save(Directorweekly vo) {// 保存员工填写的周报		
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List ByUseridQuery(String userid) {// 通过员工姓名查询可以修改的周报列表
		List list = null; 
		String checkstatus = "待审核";
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where userid=? and checkstatus=?",new Object[]{userid,checkstatus});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByUseridQuery(String userid,String period) {// 通过员工姓名查询可以修改的周报列表
		List list = null; 
		String checkstatus = "待审核";
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where userid=? and period=? and checkstatus=?",new Object[]{userid,period,checkstatus});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByUseridQueryLook(String userid) {// 通过员工姓名查询周报列表
		List list = null; 
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where userid=?",userid);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByUseridQueryLook(String userid,String period) {// 
		List list = null; 
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where userid=? and period=?",new Object[]{userid,period});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByIdQuery(int id) {// 通过id查询周报列表
		List list = null; 
		try {
		list = this.getHibernateTemplate().find("from Directorweekly where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void UpdateDirectorweekly(Directorweekly wo) {// 修改周报信息
		try {
			this.getHibernateTemplate().update(wo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}