activedao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ActiveDAO  extends HibernateDaoSupport{
	public void save(Active vo){
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	    
	}
	
	public List Query(){
		List list = null;
		try {
	       list = this.getHibernateTemplate().find("from Active");
		} 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 Active where topic like ?  or realpicture like ? or realname like ?",new Object[]{"%"+keyword+"%","%"+keyword+"%","%"+keyword+"%"});;
		} 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 Active where id=?", id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
    }
}