calendardao.java

一个oa系统

package com.oa.db;


import java.util.List;

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

import com.oa.db.Calendar;

public class CalendarDao extends HibernateDaoSupport{
	/**
	 * 根据用户名查询日程列表
	 * @param userName
	 * @return list
	 */
	public List findByName(String userName){
		List list = null;
		try {
		   list =this.getHibernateTemplate().find("from Calendar where realname=? order by id DESC" ,userName);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * 根据状态查询日程列表
	 * @param estate
	 * @return list
	 */
	
	public List findByEstate(String estate){
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Calendar where estate=?",estate);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * 根据日程id查询日程
	 * @param id
	 * @return list
	 */
	public List findById(int id){
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Calendar where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
		return list;
	}
	
	/**
	 * 添加日程
	 * @param calendar
	 */
	public void addCalendar(Calendar calendar){
		try {
		 this.getHibernateTemplate().save(calendar);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
	}
	
	/**
	 * 更新日程
	 * @param calendar
	 */
	public void updateCalendar(Calendar calendar){
		try {
			this.getHibernateTemplate().update(calendar);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block   
			e.printStackTrace();
		}
	}
	
	/**
	 * 根据id删除日程
	 * @param id
	 */
	public void deleteCalendar(int id){
		List cid = this.getHibernateTemplate().find("from Calendar");		
		for(int i=0;i<cid.size();i++){
			Calendar calendar1 = (Calendar)cid.get(i);
			if(calendar1.getId()==id){
				try {
					List list = this.getHibernateTemplate().find("from Calendar where id=?",id);
					Calendar calendar=(Calendar)list.get(0);
					this.getHibernateTemplate().delete(calendar);
				} catch (HibernateException e) {
					// TODO Auto-generated catch block   
					e.printStackTrace();
				}	
			}
		}			
	}
	
}