fileaadaoimpl.java

一个采用J2EE技术实现的企业协同工作台

package common.work.dao;

import java.sql.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
//import org.hibernate.cfg.Configuration;

import common.work.bean.Fileaa;

public class FileaaDAOImpl implements FileaaDAO {

	private SessionFactory sessionFactory;
	
	public FileaaDAOImpl(){}
	
	public FileaaDAOImpl( SessionFactory sessionFactory){
		this.sessionFactory = sessionFactory;
	}
	
	
	/*public FileaaDAOImpl(){   //构造方法中产生相应的SessionFactory
		Configuration config = new Configuration();
		SessionFactory = config.configure().buildSessionFactory();
	}*/
	
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}

	//通过文件名查找
	public Fileaa findByfilename(String filename) {   
		// TODO Auto-generated method stub
        return this.findByproperty("filename", filename).get(0);
	}
	
	//通过文件上传人姓名查找
	public List<Fileaa> findByuploadperson(String uploadperson) {  
		// TODO Auto-generated method stub
		 return this.findByproperty("uploadperson", uploadperson);
	}

	//通过文件上传时间查找
	public List<Fileaa> findByuploadtime(Date uploadtime) {
		// TODO Auto-generated method stub
		return null;
	}

     //修改数据表中的记录
	public void Update(Fileaa instance) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		session.update(instance);
		session.beginTransaction().commit();
		session.close();
	}

      //删除数据表中的数据记录
	public void delete(Fileaa instance) {
		// TODO Auto-generated method stub
        Session session = sessionFactory.openSession();
        session.delete(instance);
        session.beginTransaction().commit();
        session.close();
	}

	public List<Fileaa> findByExample(Fileaa instance) {
		// TODO Auto-generated method stub
		return null;
	}
	
	//通过文件表中的Id查找记录
	public Fileaa findById(Integer id) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		Fileaa file =(Fileaa)session.get(Fileaa.class, id);
		session.close();
		return file;
	}

    //通过文件表中的字段属性查找相应的记录
	public List<Fileaa> findByproperty(String property, String value) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		String hql = "from Fileaa file where file."+property+" like ?";
		Query query = session.createQuery(hql);
		query.setString(0, "%"+value+"%");
		List<Fileaa> file = query.list();
		session.close();
		return file;
	}

    //在上传文件表中插入记录
	public void save(Fileaa instance) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		session.save(instance);
		session.beginTransaction().commit();
		session.close();
	}

}