filemanagerdao.java

使用spring ,hibernate 框架的稽查管理系统

package com.je.ims.dao;


import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;

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

import com.je.ims.hibernate.FileManager;



public class FileManagerDao extends HibernateDaoSupport {
	 public FileManagerDao() {
	 }
	 
	  public Long showid()
		{
			List list=null;
	       Long id;
			String hql="from FileManager order by uploadDate Desc";
		    list=getHibernateTemplate().find(hql);
			FileManager e=new FileManager();
			Iterator t=list.iterator();
			e=(FileManager)t.next();
		
			id=e.getFileId();
			return id;
		} 
		public String showusername(Long temp) throws SQLException
		{
			String hql="from FileManager where fileId="+temp;
			List list=getHibernateTemplate().find(hql);
			FileManager e=new FileManager();
			Iterator t=list.iterator();
			e=(FileManager)t.next();	
			String name=e.getUserName();
			return name; 
		}
	 public FileManager getFile(Long id)
	 {
	       
		 FileManager c1=new FileManager();
	        getHibernateTemplate().load(c1,id);
	        return c1;
	 }
	 public void saveFile( FileManager c1)
	 {
		
		 //Date date=new Date();
		 //FileManager c1=new FileManager( fileDoc,  fileName,  fileType,  fileSave,  appId, new Long(0),  useId,  userName,  userUnit,  date);
		 getHibernateTemplate().saveOrUpdate(c1);
		
	        
	 }
	 
	 public void deleteFile(Long fileId)
	 {
	       
		 FileManager c1=new FileManager( );
		 getHibernateTemplate().load(c1,fileId);
		 c1.setIsDelete(new Long(1));
		 getHibernateTemplate().saveOrUpdate(c1);
	        
	 }
	 public void updateFile(FileManager c1)
	 {
		 getHibernateTemplate().update(c1);
	 }
	 public void updateFile(Long fileId,String fileDoc, String  appId, String  userId, String userName, String userUnit){
		 FileManager c1=new FileManager( );
		 getHibernateTemplate().load(c1,fileId);
		 c1.setFileDoc(fileDoc);
		 c1.setAppId(appId);
		 c1.setUserId(userId);
		 c1.setUserName(userName);
		 c1.setUserUnit(userUnit);
		 getHibernateTemplate().saveOrUpdate(c1);
		 
	 }


}