package mvc.sh.dao;

import java.util.List;

import mvc.sh.entity.Users;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class UsersDAO {
	private SessionFactory sessionFactory;

	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

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

	public List<Users> getUsers() {
		String hql = "from users";
		Session session = sessionFactory.getCurrentSession();
		Query query = session.createQuery(hql);
		return query.list();
	}

	public Users getUserById(Integer id) {
		String hql = "from users where id = :id";
		Session session = sessionFactory.getCurrentSession();
		Query query = session.createQuery(hql);
		query.setInteger("id", id);
		return (Users) query.list().get(0);
	}

	public void addUsers(Users users) {
		sessionFactory.getCurrentSession().save(users);
	}

	public void delUsersByid(Integer id) {
		Users user = getUserById(id);
		sessionFactory.getCurrentSession().delete(user);
	}

	public void modUsers(Users users) {
		sessionFactory.getCurrentSession().update(users);
	}

}