userworksdaoimpl.java

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

package common.work.dao;

import java.util.List;

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

import common.work.bean.Userworks;

public class UserworksDAOImpl implements UserworksDAO {
    private SessionFactory sessionFactory;
    
    public UserworksDAOImpl(){}
    
    public UserworksDAOImpl(SessionFactory sessionFactory){
    	this.sessionFactory = sessionFactory;
    }
     
    /*public UserworksDAOImpl(){//生成相应的SessionFactory
		Configuration config = new Configuration();
		factory = config.configure().buildSessionFactory();
	}*/
	
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

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

	//通过部门名称查询
	public List<Userworks> findBydepartment(String department) {
		// TODO Auto-generated method stub
		return this.findByproperty("department",department);
	}

	//通过用户名称查询　
	public Userworks findByworkname(String workname) {
		// TODO Auto-generated method stub
		return (Userworks)this.findByproperty("workname", workname).get(0);
	}

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

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

	
	public List<Userworks> findByExample(Userworks instance) {
		// TODO Auto-generated method stub
		return null;
	}

	//通过用户任务表中的id查询
	public Userworks findById(Integer id) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		Userworks user = (Userworks)session.get(Userworks.class,id);
		session.close();
		return user;
	}

	//通过用户任务表中的任意字段查询
	public List<Userworks> findByproperty(String property, String value) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		String hql ="from Userworks userworks where userworks."+property+" like ?";
		Query query = session.createQuery(hql);
		query.setString(0, "%"+value+"%");
		List<Userworks> user = query.list();
		session.close();
		return user;
	}

	//在用户任务信息表中插入记录
	public void save(Userworks instance) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		session.save(instance);
		session.beginTransaction().commit();
		session.close();
	}

}