src/com/lzl/exam/dao/ExamDao.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.lzl.exam.dao;

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

import org.hibernate.Session;

import com.lzl.exam.bean.Exam;
import com.lzl.exam.util.SessionFactory;

public class ExamDao {

	public boolean add(List<Exam> list){
		boolean b = false;
		try {
			Session s = SessionFactory.getSession();
			s.beginTransaction();
			s.createQuery("delete from Exam").executeUpdate();
			for(int i = 0;i<list.size();i++){
				s.save(list.get(i));
				if(i % 20 == 0)
					s.flush();
			}
			s.getTransaction().commit();
			SessionFactory.closeSession();
			b = true;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return b;
	}
	
	public List<Exam> list(String timeFrom,String timeTo,int classroom,int teacher,int clazz,int course){
		List<Exam> list = new ArrayList<Exam>();
		Session s = SessionFactory.getSession();
		s.beginTransaction();
		String hql = "From Exam e where 1=1";
		if(timeFrom != null && !timeFrom.equals(""))
			hql += " and e.examDate>='"+timeFrom+"'";
		if(timeTo != null && !timeTo.equals(""))
			hql += " and e.examDate<='"+timeTo+"'";
		if(classroom > 0)
			hql += " and e.classroom="+classroom;
		if(teacher > 0)
			hql += " and (e.teacher1="+teacher + " or e.teacher2=" + teacher + ")";
		if(clazz > 0)
			hql += " and e.clazzcourse.clazz="+clazz;
		if(course > 0)
			hql += " and e.clazzcourse.course="+course;
		list = s.createQuery(hql).list(); 
		s.getTransaction().commit();
		SessionFactory.closeSession();
		return list;
	}
}