package com.javaniu.dao.impl;

import java.util.List;

import javax.annotation.Resource;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.javaniu.dao.UserDao;
import com.javaniu.module.User;

@Transactional(readOnly = false, propagation = Propagation.SUPPORTS)
@Repository
public class UserDaoImpl implements UserDao {

	private SessionFactory sessionFactory;

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

	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	private Session getSession() {
		return sessionFactory.getCurrentSession();
	}

	@Override
	public void save(User user) {
		getSession().save(user);
	}

	@Override
	public void delete(Long id) {
		User user = findById(id);
		getSession().delete(user);
	}

	@Override
	public void delete(User user) {
		getSession().delete(user);
	}

	@Override
	public void update(User user) {
		getSession().update(user);
	}

	@Override
	public User findById(Long id) {
		return (User) getSession().get(User.class, id);
	}

	@Override
	public User findByEmailAndPassword(String email, String password) {
		String hql = "from User where email=? and password=?";
		Query query = getSession().createQuery(hql);
		query.setParameter(0, email);
		query.setParameter(1, password);
		List<User> list = query.list();
		if (list == null || list.size() == 0) {
			return null;
		}
		return list.get(0);
	}

}