zhoubaozfsfjcdao.java

一个oa系统

package com.oa.db;

import java.util.List;

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

public class ZhoubaoZfsfjcDAO   extends HibernateDaoSupport{
	public void Save(ZhoubaoZfsfjc vo) {//		
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List ByWeeklyofyearQueryZhoubaoZfsfjc(String cd) {//
		List list = null;
		try {
		list = this.getHibernateTemplate().find("from ZhoubaoZfsfjc where weeklyofyear=?",cd);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryAll() {// 查询所有
		List list = null;		
		try {
			list =this.getHibernateTemplate().find("from ZhoubaoZfsfjc where id in(select max(id) from ZhoubaoZfsfjc group by weeklyofyear)");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByIdZhoubaoZfsfjc(int cd) {//
		List list = null;
		try {
		list = this.getHibernateTemplate().find("from ZhoubaoZfsfjc where id=?",cd);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
}