titlesystemmanager.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.TitleManage;
import com.zjxy.hibernate.model.TitleSystem;

public class TitleSystemManager {
	Session session;
	
	// 构造函数
	public TitleSystemManager() throws HibernateException {
		session = getSession();
	}
	
	// 取得题目信息列表
	public List getTitleSystenList() throws HibernateException {
		return session.createCriteria(TitleManage.class).list();
	}
	// 取得选择题信息列表
	public List getTitleSystemList(TitleSystem titleSystem) throws HibernateException {
		Criteria criteria = session.createCriteria(TitleSystem.class);
		criteria.add(Expression.eq("kemuID", titleSystem.getKemuID()));
		criteria.add(Expression.eq("tikuNO", titleSystem.getTikuNO()));
		List list = criteria.list();
		return list;
	}
	
	// 添加选择题信息
	public void addTitleSystem(TitleSystem titleSystem) throws HibernateException {
		Transaction tran = session.beginTransaction();
		session.save(titleSystem);
		tran.commit();
	}
	
	public String getKemuNameByID(String kemuID) throws HibernateException {
		
		String kemuName = "";
		Criteria criteria = session.createCriteria(TitleManage.class);
		criteria.add(Expression.eq("kemuID", kemuID));
		List list = criteria.list();
		TitleManage titleManage = null;
		if(!list.isEmpty()){
		titleManage = (TitleManage) list.get(0);
		kemuName = titleManage.getKemuName();
		}
		
		return kemuName;
	}

	
	// 题目修改页面初期化时页面项目信息的取得
	public TitleSystem getModifyInfoByID(int sequenceID) {
		TitleSystem titleSystem = new TitleSystem();
		List list = new ArrayList();
		Integer seqID = Integer.valueOf(sequenceID);
		Criteria criteria = session.createCriteria(TitleSystem.class);
		criteria.add(Expression.eq("sequenceID", seqID));
		list = criteria.list();
		titleSystem = (TitleSystem) list.get(0);
		return titleSystem;
	}
	
	// 修改题目信息
	public void modifyTitleSystemInfo(TitleSystem TitleSystem) throws HibernateException {
		Transaction tran = session.beginTransaction();
		session.merge(TitleSystem);
		tran.commit();
	}
	
	// 删除题目信息
	public void delete(int sequenceID) throws HibernateException {
		
		TitleSystem TitleSystem = new TitleSystem();
		TitleSystem = this.getModifyInfoByID(sequenceID);
		Transaction tran = session.beginTransaction();
		session.delete(TitleSystem);	
		tran.commit();
	}
	
	// 关闭session
	public void closeSession() throws HibernateException {
		session.close();
	}
	
	// 得到session
	private Session getSession() throws HibernateException {
		return HibernateSessionFactory.currentSession();
	}
}