resourcedao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ResourceDAO extends HibernateDaoSupport{
	
	public void save(Resource vo){
		try {
	        this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
    }
	
	public List Querybytype(String type){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Resource where departmentid=?",type);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	public List Query(){
		List list = null;
		try {//System.out.println(this.getHibernateTemplate());
	       list = this.getHibernateTemplate().find("from Resource order by id DESC");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	
	public List Querybykeyword(String departmentid,String keyword){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Resource where departmentid=? and (realfilename like ? or realname like ?)",new Object[]{departmentid,"%"+keyword+"%","%"+keyword+"%"});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	
	public List Querybykeyword(String keyword){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Resource where realfilename like ? or realname like ?",new Object[]{"%"+keyword+"%","%"+keyword+"%"});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	
	public List QueryAll(){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Resource group by departmentid");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	
	public List QuerybyId(int id){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Resource where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
	
	public void delResource(Resource vo){
	    try {
			this.getHibernateTemplate().delete(vo);
		} catch (HibernateException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}			
	}
}