passwordweeklymanagerdao.java

来自「上一上传oa系统漏掉web-inf文件夹」· Java 代码 · 共 42 行

package com.oa.db;

import java.util.ArrayList;

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

public class PasswordWeeklyManagerDAO extends HibernateDaoSupport {
	
	/*
	 * 功能:查询所有的密码类别
	 * 
	 */
	public ArrayList<PasswordType> findAllPdType(){
		ArrayList<PasswordType> list = new ArrayList<PasswordType>();
		list = (ArrayList<PasswordType>) getHibernateTemplate().find("from PasswordType");
		return list;
	}
	
	
	/*
	 * 功能:增加密码周报
	 * 
	 */
	public void addPasswordWeekly(PasswordWeeklyManager pd){
		getHibernateTemplate().save(pd);
	}
	
	public ArrayList<String> showAllPasswordWeekly(){
		String sql = "select distinct pdWeeklyCycle from PasswordWeeklyManager";		
		ArrayList<String> list = new ArrayList<String>();
		list = (ArrayList<String>) getHibernateTemplate().find(sql);//System.out.println(list.size()+list.get(0)+list.get(1));
		return list;
	}
	
	public ArrayList<PasswordWeeklyManager>  showOnePasswordWeeklyByCycle(String weeklyCycle){
		ArrayList<PasswordWeeklyManager> list = new ArrayList<PasswordWeeklyManager>();
		String sql = "from PasswordWeeklyManager where pd_weekly_cycle=?";
		list = (ArrayList<PasswordWeeklyManager>) getHibernateTemplate().find(sql,weeklyCycle);
		return list;
	}
}