package dao.hibernate;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.springframework.orm.hibernate3.HibernateTemplate;

import po.Ostudent;
import dao.IStudentDao;

public class StudentDaoImp implements IStudentDao
{
	private SessionFactory sf;
	private HibernateTemplate template;
	
	public SessionFactory getSf()
	{
		return sf;
	}

	public void setSf(SessionFactory sf)
	{
		this.sf = sf;
		//通過session工廠得到hibernate模版
		template = new HibernateTemplate(sf); 
	}

	public void addStudent(Ostudent stu)
	{
		template.save(stu);
		sf.close();
	}

	public void delStudent(String id)
	{
		template.delete(this.findByid(id));
		sf.close();
	}

	public List findAllstudent()
	{
		List list = template.find("from Ostudent");
		sf.close();
		return list;
	}

	public Ostudent findByid(String id)
	{
		Ostudent stu = (Ostudent) template.get(Ostudent.class, id);
		sf.close();
		return stu;
	}

	public boolean judgeContain(String id)
	{
		Ostudent stu = this.findByid(id);
		if(stu == null)
		{
			return true;
		}
		else
		{
			return false;
		}
		
  /*	String hql = "select t from Ostudent t where t.operatorId='"+id+"'";
		System.out.println(hql);
		List list = template.find(hql);
		if(list.size()!=0)
		{
			return false;
		}
		else
		{
			return true;
		}*/
	}

	public Ostudent judgeStudent(String username, String password)
	{
		Ostudent stu = null;
		
		String sql = "select o from Ostudent o where o.id = '"+username+"' and o.password = '"+password+"'";
//		String sql = "select * from Toperator where operatorName = '"+username+"' and operatorPwd = '"+password+"'";
		List list = template.find(sql);
		if(list.size()!=0)
		{
			stu = (Ostudent)list.get(0);
		}
		sf.close();
		return stu;
	}

	public void updataStudent(Ostudent stu)
	{	
		template.saveOrUpdate(stu);
		sf.close();
	}

}