package com.autumn.pojo.oper;

import java.util.List;

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

import com.autumn.pojo.Reader;

public class ReaderOper {
	private Session session ;
	public ReaderOper()
	{
		this.session = Factory.getSession() ;
	}
	
	public Reader queryById(String id)
	{
		Reader r = null ;
		String hql = "From Reader as r where r.id=?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0,id) ;
		List l = q.list() ;
		if(l.size()>0)
		{
			r = (Reader)l.get(0);
		}
		this.session.beginTransaction().commit() ;
		return r ;
	}
	public boolean update(Reader r)
	{
		boolean suc = false ;
		try {
			this.session.update(r) ;
			this.session.beginTransaction().commit() ;
			this.session.close() ;
			suc = true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	public boolean insert(Reader r)
	{
		boolean suc = false ;
		try {
			this.session.save(r) ;
			this.session.beginTransaction().commit() ;
			suc = true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	public boolean delete(String rid)
	{
		boolean suc = false ;
		try {
			String hql ="delete from Reader where id=?" ;
			Query q = this.session.createQuery(hql) ;
			q.setString(0, rid) ;
			q.executeUpdate();
			this.session.beginTransaction().commit() ;
			suc= true ;
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return suc ;
	}
	
	public boolean exsit(Reader reader)
	{
		boolean bl= false ;
		String hql = "from Reader as r where r.id=?" ;
		Query q = this.session.createQuery(hql) ;
		q.setString(0, reader.getId()) ;
		List l = q.list() ;
		if(l.size()>0)
		{
			Reader r = (Reader)l.get(0) ;
			String password = r.getPassword() ;
			if(reader.getPassword().equals(password))
			{
				bl=true ;
			}
		}
		return bl ;
	}
	public List queryByLike(String cond)
	{
		List all = null ;
		String hql = "from Reader as r where id like ? or name like ? or inyear like ? or college like ?";
		Query q = this.session.createQuery(hql) ;
		q.setString(0,"%"+cond+"%") ;
		q.setString(1,"%"+cond+"%") ;
		q.setString(2,"%"+cond+"%") ;
		q.setString(3,"%"+cond+"%") ;
		all = q.list() ;
		return all ;
	}
}