package com.autumn.pojo.oper;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

import com.autumn.pojo.Manager;

public class ManagerOper {
	private Session session ;
	public ManagerOper()
	{
		this.session = new Configuration().configure().buildSessionFactory().openSession() ;
	}
	
	public Manager queryById(String id)
	{
		Manager manager = null;
		String hql = "from Manager as m where m.id=?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0,id) ;
		List l = q.list() ;
		if(l.size()>0)
		{
			manager = (Manager)l.get(0) ;
		}
		return manager ;
	}
	public boolean update(Manager manager)
	{
		boolean suc =false ;
		this.session.update(manager) ;
		this.session.beginTransaction().commit() ;
		suc = true ;
		return suc ;
	}
	public boolean isExsit(Manager manager)
	{
		boolean exsit = false ;
		Manager m =null ;
			m = this.queryById(manager.getId()) ;
		if(m!=null)
		{
			if(manager.getPassword().equals(m.getPassword()))
			{
				exsit = true ;
			}
		}
		return exsit ;
	}
	public boolean add(Manager manager)
	{
		boolean suc = false ;
		this.session.save(manager) ;
		this.session.beginTransaction().commit() ;
		suc = true ;
		return suc ;
	}
	
	public boolean delete(Manager manager)
	{
		boolean suc = false ;
		this.session.delete(manager) ;
		this.session.beginTransaction().commit() ;
		suc=true ;
		return suc ;
	}
	public List queryAll()
	{
		List all=null ;
		String hql="from Manager as m" ;
		Query q = this.session.createQuery(hql) ;
		all=q.list() ;
		return all ;
	}
}