usermessagedaoimpl.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.Usermessage;

public class UsermessageDAOImpl implements UsermessageDAO {
	private SessionFactory sessionFactory;
	/*public UsermessageDAOImpl(){                //生成SessionFactory
		Configuration config = new Configuration();
		sessionFactory = config.configure().buildSessionFactory();
	}*/
	public UsermessageDAOImpl(){}
	
	public UsermessageDAOImpl(SessionFactory sessionFactory){
		this.sessionFactory = sessionFactory;
	}
	
	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	
	//通过年龄查询
	public List<Usermessage> findByage(Integer age) {
		// TODO Auto-generated method stub
		//return this.findByproperty("age", age);
		return null;
	}

    //通过姓名查询
	public List<Usermessage> findByname(String name) {
		// TODO Auto-generated method stub
		return  this.findByproperty("name", name);
	}
	
	public Usermessage findByaccount(String account) {
		// TODO Auto-generated method stub
		return (Usermessage) this.findByproperty("account", account).get(0);
	}
	//通过学历查询
	public List<Usermessage> findByschool(String school) {
		// TODO Auto-generated method stub
		return this.findByproperty("school", school);
	}


	//通过薪水查询
	public List<Usermessage> findBywage(Integer wage) {
		// TODO Auto-generated method stub
		//return this.findByproperty("wage", wage);
		return null;
	}

    //通过工龄查询
	public List<Usermessage> findByworkage(Integer workage) {
		// TODO Auto-generated method stub
		//return this.findByproperty("workage", workage);
		return null;
	}

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

	}

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

	}

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

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

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

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

	

}