coursedaoimpl.java

本程序所写的排课

package com.briup.dao.impl;

import static com.briup.common.HibernateSessionFactory.getSession;

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

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

import com.briup.bean.Classroom;
import com.briup.bean.Course;
import com.briup.bean.Deploy;
import com.briup.bean.SC;
import com.briup.dao.ICourseDao;

public class CourseDaoImpl implements ICourseDao{

	public List<Deploy> findAllDeploy() throws Exception{
		
		Session session = getSession();
		Query query = session.createQuery("from com.briup.bean.Deploy");;
		List<Deploy> list = query.list();
		session.close();
		return list;
	}

	public List<Course> lookupMyCourse(Long id) throws Exception{
		
		Session session = getSession();
		String hql = "from com.briup.bean.SC where studentid = '"+id+"'";
		Query query = session.createQuery(hql);
		List<SC> list1 = query.list();
		if(list1.size() == 0)
			return null;
		List<Course> list2 = new ArrayList<Course>();
		for(SC sc: list1)
		{
			list2.add(sc.getCourse());
		} 
		session.close();
		return list2;
	}

	public void saveDeploy(Deploy deploy) throws Exception{
		
		
	}

	public void saveSC(Set<SC> scSet) throws Exception {
		
		Session session = getSession();
		Transaction trans = session.beginTransaction();
		int i = 0;
		System.out.println(scSet);
		for(SC sc : scSet)
		{
			session.save(sc);
			if(i/10 == 9)
			{
				session.flush();
				session.clear();
			}
			i++;
		}
		trans.commit();
		session.close();
	}

	public List<Classroom> findAllClassroom() throws Exception {
		
		Session session = getSession();
		Query query = session.createQuery("from com.briup.bean.Classroom");
		List<Classroom> list= query.list();
		session.close();
		return list;
	}

	public List<Course> findAllCourse() throws Exception {
		
		Session session = getSession();
		Query query = session.createQuery("from com.briup.bean.Course");
		List<Course> list = query.list();
		List<Course> listCourse = new ArrayList<Course>();
		for(Course course : list)
		{
			String name = new String(course.getName().getBytes(), "UTF-8");
			course.setName(name);
			System.out.println(name);
			listCourse.add(course);
		}
		session.close();
		return listCourse;
	}

}