sendmaildao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class SendmailDAO extends HibernateDaoSupport{
	
	public void save(Sendmail vo){
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	    
	}
	
	public List AcceptQuery(int id) {//接收邮件
		List list = null;
		try {			
		    list = this.getHibernateTemplate().find("from Sendmail where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List SendQuery(String usernameid) {//发送邮件查询
		List list = null;
		String caogaobag = "no";
		String wasterbag = "0";
		try {			
		    list = this.getHibernateTemplate().find("from Sendmail where senderid=?  and caogaobag=? and wasterbag=? order by id DESC",new Object[]{usernameid,caogaobag,wasterbag});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List CaogaoQuery(String usernameid) {//发送邮件查询
		List list = null;
		String caogaobag = "yes";
		String wasterbag = "0";
		try {			
		    list = this.getHibernateTemplate().find("from Sendmail where senderid=? and caogaobag=? and wasterbag=?",new Object[]{usernameid,caogaobag,wasterbag});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	
	public List Whetherreadtotal(String usernameid) {//统计未读邮件
		List list = null;
		try {
		    list=this.getHibernateTemplate().find("from Sendmail where type=? and whetherdel=? and whetherread=? and (firstaccepter like ? or secondaccepter like ? or thirdaccepter like ?)",new Object[]{"1","0","no","%,"+usernameid+",%","%,"+usernameid+",%","%,"+usernameid+",%"});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	/*public void byiddeleteMail(int id,String accepterid) {//通过id永久删除邮件
		List list = null;
		String firstaccepter = "";
		String secondaccepter = "";
		String thirdaccepter = "";
		try {
			list = this.getHibernateTemplate().find("from Sendmail where id=?",id);
			if(list!=null&&list.size()!=0){
					Sendmail so = (Sendmail)list.get(0);
					String a = ","+accepterid+",";
					firstaccepter = so.getFirstaccepter().replaceAll(a, ",");
					secondaccepter = so.getSecondaccepter().replaceAll(a, ",");
					thirdaccepter = so.getThirdaccepter().replaceAll(a,",");
					Sendmail vo = new Sendmail();
					vo.setId(so.getId());
					vo.setSenderid(so.getSenderid());
					vo.setFirstaccepter(firstaccepter);
					vo.setSecondaccepter(secondaccepter);
					vo.setThirdaccepter(thirdaccepter);
					vo.setSendtheme(so.getSendtheme());
					vo.setSendcontent(so.getSendcontent());
					vo.setSenddate(so.getSenddate());
					vo.setFilename(so.getFilename());
					vo.setRealfilename(so.getRealfilename());
					vo.setType(so.getType());
					vo.setWhetherdel(so.getWhetherdel());
					vo.setFajianwhetherdel(so.getFajianwhetherdel());
					vo.setCaogaowhetherdel(so.getCaogaowhetherdel());
					vo.setWasterwhetherdel(so.getWasterwhetherdel());
					vo.setWhetherread(so.getWhetherread());
					vo.setWhetherreadcaogao(so.getWhetherreadcaogao());															
					this.getHibernateTemplate().update(vo);
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	*/
	

	
	/*public void byidupdateMail(int id) {//通过id更新邮件
		List list = null;
		String firstaccepter = "";
		String secondaccepter = "";
		String thirdaccepter = "";
		try {
			list = this.getHibernateTemplate().find("from Sendmail where id=?",id);
			if(list!=null&&list.size()!=0){
					Sendmail so = (Sendmail)list.get(0);
					Sendmail vo = new Sendmail();
					vo.setId(so.getId());
					vo.setSenderid(so.getSenderid());
					vo.setFirstaccepter(so.getFirstaccepter());
					vo.setSecondaccepter(so.getSecondaccepter());
					vo.setThirdaccepter(so.getThirdaccepter());
					vo.setSendtheme(so.getSendtheme());
					vo.setSendcontent(so.getSendcontent());
					vo.setSenddate(so.getSenddate());
					vo.setFilename(so.getFilename());
					vo.setRealfilename(so.getRealfilename());
					vo.setType(so.getType());
					vo.setWhetherdel(so.getWhetherdel());
					vo.setFajianwhetherdel("yes");
					vo.setCaogaowhetherdel(so.getCaogaowhetherdel());
					vo.setWasterwhetherdel(so.getWasterwhetherdel());
					vo.setWhetherread(so.getWhetherread());
					vo.setWhetherreadcaogao(so.getWhetherreadcaogao());															
					this.getHibernateTemplate().update(vo);
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}*/
	
	
	
	public List WasterQuery(String usernameid) {//废纸邮件
		List list = null;
		int wasterbag = 1;
		try {			
		    list = this.getHibernateTemplate().find("from Sendmail where  senderid=? and wasterbag=?",new Object[]{usernameid,wasterbag});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void byidupdateWaster(int id) {//通过id永久删除废纸
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Sendmail where id=?",id);
			if(list!=null&&list.size()!=0){
					Sendmail so = (Sendmail)list.get(0);
					Sendmail vo = new Sendmail();
					vo.setId(so.getId());
					vo.setSenderid(so.getSenderid());
					vo.setFirstaccepter(so.getFirstaccepter());
					vo.setSecondaccepter(so.getSecondaccepter());
					vo.setThirdaccepter(so.getThirdaccepter());
					vo.setSendtheme(so.getSendtheme());
					vo.setSendcontent(so.getSendcontent());
					vo.setSenddate(so.getSenddate());
					vo.setFilename(so.getFilename());
					vo.setRealfilename(so.getRealfilename());
					vo.setCaogaobag(so.getCaogaobag());
					vo.setWasterbag("2");
					vo.setWhetherreadcaogao(so.getWhetherreadcaogao());															
					this.getHibernateTemplate().update(vo);
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public List ByIdQuery(int id) {//接收邮件
		List list = null;
		try {			
		    list = this.getHibernateTemplate().find("from Sendmail where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void UpdateSendmail(Sendmail vo) {//接收邮件
		try {			
		    this.getHibernateTemplate().update(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}