userlogindaoimpl.java

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

package common.work.dao;

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.Userlogin;

public class UserLoginDAOImpl implements UserLoginDAO {
   private SessionFactory sessionFactory;
/*	public UserLoginDAOImpl(){  //产生相应的SessionFactory
		Configuration config = new Configuration();
		factory = config.configure().buildSessionFactory();
	}*/
   public UserLoginDAOImpl(){}
   
   public UserLoginDAOImpl(SessionFactory factory){
	   this.sessionFactory = factory;
   }
   
   public SessionFactory getsessionFactory() {
		return sessionFactory;
	}

	public void setsessionFactory(SessionFactory factory) {
		this.sessionFactory = factory;
	}
	
	//通过帐号查询
	public Userlogin findByaccount(String account) {
		// TODO Auto-generated method stub
		return (Userlogin)this.findByproperty("account", account).get(0);
	}

    //通过用户的姓名查询
	public List<Userlogin> findByname(String name) {
		// TODO Auto-generated method stub
		return this.findByproperty("name", name);
	}

    //通过所属部门查询
	public List<Userlogin> findBypartment(String partment) {
		// TODO Auto-generated method stub
		return this.findByproperty("partment", partment);
	}

	//通过用户的身份类型查询
	public List<Userlogin> findBytype(String type) {
		// TODO Auto-generated method stub
		return this.findByproperty("type",type);
	}

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

	}


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

	public List<Userlogin> findByExample(Userlogin instance) {
		// TODO Auto-generated method stub
		//Session session = factory.openSession();
		return null;
	}

	//通过用户Id查询数据记录
	public Userlogin findById(Integer id) {
		// TODO Auto-generated method stub
		Session session = sessionFactory.openSession();
		Userlogin userlogin =(Userlogin)session.get(Userlogin.class, id);
		session.close();
		return userlogin;
	}

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

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

	

}