acceptmaildao.java

上一上传oa系统漏掉web-inf文件夹

package com.oa.db;

import java.util.List;

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

public class AcceptmailDAO extends HibernateDaoSupport{
	public void save(Acceptmail vo){
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	    
	}
	
	public List AcceptQuery(String usernameid) {//接收邮件
		List list = null;
		String wasterbag = "no";
		try {			
		    list = this.getHibernateTemplate().find("from Acceptmail where accepter=? and wasterbag=? order by id DESC",new Object[]{usernameid,wasterbag});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List Whetherreadtotal(String usernameid) {//统计未读邮件
		List list = null;
		String aa = "no";
		try {
		    list=this.getHibernateTemplate().find("from Acceptmail where accepter=? and whetherread=?",new Object[]{usernameid,aa});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByIdQuery(int id) {//接收邮件
		List list = null;
		try {			
		    list = this.getHibernateTemplate().find("from Acceptmail where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void UpdateAcceptmail(Acceptmail vo) {//更新邮件
		try {			
		    this.getHibernateTemplate().update(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void DelAcceptmail(Acceptmail vo) {//删除邮件
		try {			
		    this.getHibernateTemplate().delete(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List WasterQuery(String usernameid) {//废纸邮件
		List list = null;
		String wasterbag = "yes";
		try {			
		    list = this.getHibernateTemplate().find("from Acceptmail where  accepter=? and wasterbag=?",new Object[]{usernameid,wasterbag});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
}