examdaoimpl.java

struts在线考试系统. 自己还没看

package com.lili.exam.dao;

import java.util.Iterator;
import java.util.List;
import java.util.Set;

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

import com.lili.exam.pojo.CChoice;
import com.lili.exam.pojo.SelectOne;
import com.lili.exam.pojo.Student;
import com.lili.exam.pojo.Subject;
import com.lili.exam.pojo.Teacher;
import com.lili.exam.util.HibernateSessionFactory;

public class ExamDaoImpl implements ExamDao  {

	public Student getStudentByName(String name) throws Exception{
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Student where name=?");
		query.setString(0, name);
		Student stu = (Student)query.uniqueResult();
		tran.commit();
		session.close();
		return stu;
	}

	public Teacher getTeacherByName(String name) throws Exception{
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Teacher where name=?");
		query.setString(0, name);
		Teacher tea = (Teacher)query.uniqueResult();
		tran.commit();
		session.close();
		return tea;
	}

	public void savaOrUpdateTeacher(Teacher teacher) throws Exception{
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		session.save(teacher);
		tran.commit();
		session.close();
	}

	public void saveOrUpdateChoice(CChoice choice) throws Exception{
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		session.save(choice);
		tran.commit();
		session.close();
	}

	public void saveOrUpdateSelectOne(SelectOne selectOne) throws Exception{
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		session.save(selectOne);
		tran.commit();
		session.close();
	}

	public void saveOrUpdateStudent(Student student) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		session.save(student);
		tran.commit();
		session.close();
	}

	public List<Student> listStudents() throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Student");
		List<Student> list = query.list();
		tran.commit();
		return list;
	}

	public Student getStudentByXuehao(String xuehao) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Student where xuehao=?");
		query.setString(0, xuehao);
		tran.commit();
		return (Student)query.uniqueResult();
	}

	public Subject getSubjectByName(String name) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Subject where name=?");
		query.setString(0, name);
		tran.commit();
		return (Subject)query.uniqueResult();
	}

	public void saveOrUpdateSubject(Subject subject) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		session.save(subject);
		tran.commit();
		session.close();
	}

	public void changeState() throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from Subject");
		List list = query.list();
		Iterator it =  list.iterator();
		while(it.hasNext()){
			Subject s = (Subject) it.next();
			String name = s.getName();
			String time = s.getTime();
			int state = s.getState();
System.out.println(s+" : "+name+" : "+time+" : "+state);
			if(state == 1){
				state = 0;
			}
			s.setState(state);
			this.saveOrUpdateSubject(s);	
		}
		tran.commit();
		session.close();
	}

	public int getChoiceOneNum(Subject subject) throws Exception {
		Subject sub = this.getSubjectByName(subject.getName());
		Set set = sub.getChoices();
		int size = set.size();
System.out.println("11111111111111: "+size);
		return size;
	}

	public int getSelectOneNum(Subject subject) throws Exception {
		Subject sub = this.getSubjectByName(subject.getName());
		Set set = sub.getSelectOnes();
		int size = set.size();
System.out.println("2222222222222: "+size);
		return size;
	}

	public CChoice getChoice(int num) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from CChoice where id=?");
		query.setInteger(0, num);
		CChoice choice = (CChoice)query.uniqueResult();
		tran.commit();
		session.close();
		return choice;
	}

	public SelectOne getSelectOne(int num) throws Exception {
		Session session = HibernateSessionFactory.getSession();
		Transaction tran = session.beginTransaction();
		Query query = session.createQuery("from SelectOne where id=?");
		query.setInteger(0, num);
		SelectOne selectOne = (SelectOne)query.uniqueResult();
		tran.commit();
		session.close();
		return selectOne;
	}

	

	

}