documentweeklydao.java

一个oa系统

package com.oa.db;

import java.util.ArrayList;

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

public class DocumentWeeklyDAO extends HibernateDaoSupport {
	
	public void addDocumentWeekly(DocumentWeekly documentWeekly) {
		getHibernateTemplate().save(documentWeekly);
	}
	
	public ArrayList<String> showAllPasswordWeekly(){

		String sql = "select distinct documentCycle from DocumentWeekly";
		
		ArrayList<String> list = new ArrayList<String>();

		list = (ArrayList<String>) getHibernateTemplate().find(sql);
		return list;
	}
	
	public ArrayList<DocumentWeekly>  showOneDocumentWeeklyByCycle(String weeklyCycle){
		ArrayList<DocumentWeekly> list = new ArrayList<DocumentWeekly>();
		String sql = "from DocumentWeekly where document_cycle=?";
		list = (ArrayList<DocumentWeekly>) getHibernateTemplate().find(sql,weeklyCycle);
		return list;
	}
}