package com.hfm.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.hfm.dao.StudentDao;
import com.hfm.entity.Student;
import com.hfm.util.HibernateSessionFactory;

public class StudentDaoImpl implements StudentDao {

	@Override
	public List<Student> getbyStuNo(String stuNo) {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Transaction tr = session.beginTransaction();
		StringBuffer hql = new StringBuffer("from Student ");
		if(stuNo!=null&&!"".equals(stuNo)){
			hql.append("where stuNo=?");
		}
		Query query = session.createQuery(hql.toString());
		if(stuNo!=null&&!"".equals(stuNo)){
			query.setString(0, stuNo);  
		}
       
        List<Student> students = query.list();
		tr.commit();
		HibernateSessionFactory.closeSession();
		return students;
	}



	
}