teacherdaoimpl.java

学生成绩管理系统

package com.qrsx.course.daoImpl;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.MatchMode;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.qrsx.course.dao.TeacherDAO;
import com.qrsx.course.model.Teacher;
import com.qrsx.course.util.PageModel;



/**
 * 
 * @author Administrator
 *
 */
public class TeacherDAOImpl extends HibernateDaoSupport implements TeacherDAO {

	/**
	 * 添加教师
	 * @param 
	 */
	public void addTeacher(Teacher teacher) throws Exception{
		
		this.getHibernateTemplate().save(teacher);

	}

	/**
	 * 修改教师
	 * @param 
	 */
	public void modifyTeacher(Teacher teacher) throws Exception {

		this.getHibernateTemplate().update(teacher);
		
	}

	/**
	 * 删除教师
	 * @param 
	 */
	public void deleteTeacher(String[] teacherIdList) throws Exception {
		
		for (int i=0; i<teacherIdList.length; i++) {
			Teacher teacher = (Teacher)this.getHibernateTemplate().load(Teacher.class, teacherIdList[i]);
			this.getHibernateTemplate().delete(teacher);
		}		
	}

	/**
	 * 查询全部教师
	 */
	@SuppressWarnings("unchecked")
	public List<Teacher> findAllTeachers() {

		List<Teacher> teacherList = new ArrayList<Teacher>();
	
		Session session = this.getSession();
		Query query = session.createQuery("from Teacher c");
		teacherList = query.list();
	
		return teacherList;

	}
	
	
	/**
	 * 根据Id查询教师
	 * @param 
	 */
	public Teacher findTeacherById(String id) {

		Teacher teacher = (Teacher)this.getHibernateTemplate().load(Teacher.class, id);
		
		return teacher;
	}

	/**
	 * 根据条件查询教师信息
	 */
	@SuppressWarnings("unchecked")
	public PageModel listTeacher(int pageNo, Teacher teacher) {
		
		PageModel pageModel = null;
		List teacherList = new ArrayList();
		
		Example exampleTeacher = Example.create(teacher)
									 .enableLike(MatchMode.ANYWHERE)
									 .ignoreCase();
									 
		
		teacherList = this.getSession().createCriteria(Teacher.class)
									.add(exampleTeacher)
									.setFirstResult((pageNo - 1) * PageModel.pageSize)
									.setMaxResults(PageModel.pageSize)
									.list();
		
		pageModel = new PageModel();
		pageModel.setPageNo(pageNo);
		pageModel.setList(teacherList);
		pageModel.setTotalRecords(getTotalRecords(teacher));
		
		return pageModel;

	}

	/**
	 * 查询记录数
	 * @param 
	 * @return
	 */
	@SuppressWarnings("unchecked")
	private int getTotalRecords(Teacher teacher) {
		
		List teacherList = new ArrayList();
		
		Example exampleTeacher = Example.create(teacher)
		 							 .enableLike(MatchMode.ANYWHERE)
		 							 .ignoreCase();
		
		teacherList = this.getSession().createCriteria(Teacher.class)
											   .add(exampleTeacher)
											   .list();
		return teacherList.size();
	}

}