teachermanager.java

在线考试系统: 这是基于struts和Hibernate的最新技术的在线考试系统.数据库是MySql.能添加课程

package com.zjxy.hibernate.base;

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

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Expression;

import com.zjxy.hibernate.HibernateSessionFactory;
import com.zjxy.hibernate.model.Teacher;
import com.zjxy.hibernate.model.User;

public class TeacherManager {
	Session session;
	
	// 构造函数
	public TeacherManager() throws HibernateException {
		session = getSession();
	}
	
	// 取得教师信息列表
	public List getTeacherList() throws HibernateException {
		return session.createCriteria(Teacher.class).list();
	}
	
	// 添加教师信息
	public void addTeacher(Teacher teacher, User user) throws HibernateException {
		Transaction tran = session.beginTransaction();
		session.save(teacher);
		session.save(user);
		tran.commit();
	}
	
	// 判断输入的教师帐号是否已经存在，存在则返回true，否则返回false
	public boolean getTeacherByID(String teacherID) {
		boolean flag = false;
		List list = new ArrayList();
		Criteria criteria = session.createCriteria(Teacher.class);
		criteria.add(Expression.eq("teacherID", teacherID));
		list = criteria.list();
		if (list.size() == 1) {
			flag = true;
		}
		return flag;
	}
	
	// 教师修改页面初期化时页面项目信息的取得
	public Teacher getModifyInfoByID(int sequenceID) {
		Teacher teacher = new Teacher();
		List list = new ArrayList();
		Integer seqID = Integer.valueOf(sequenceID);
		Criteria criteria = session.createCriteria(Teacher.class);
		criteria.add(Expression.eq("sequenceID", seqID));
		list = criteria.list();
		teacher = (Teacher) list.get(0);
		return teacher;
	}
	
	// 修改教师信息
	public void modifyTeacherInfo(Teacher teacher, User user) throws HibernateException {
		Transaction tran = session.beginTransaction();
		session.merge(teacher);
		session.merge(user);
		tran.commit();
	}
	
	// 删除教师信息
	public void delete(int sequenceID) throws HibernateException {
		Teacher teacher = new Teacher();
		User user = new User();
		teacher = this.getModifyInfoByID(sequenceID);
		user.setSequenceID(sequenceID);
		user.setUserID(teacher.getTeacherID());
		user.setPassword(teacher.getTeacherNO());
		user.setUserFlag("T");
		Transaction tran = session.beginTransaction();
		session.delete(teacher);	
		session.delete(user);
		tran.commit();
	}
	
	// 关闭session
	public void closeSession() throws HibernateException {
		session.close();
	}
	
	// 得到session
	private Session getSession() throws HibernateException {
		return HibernateSessionFactory.currentSession();
	}

}