scoremanager.java

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

package com.zjxy.hibernate.base;

import java.util.List;
import java.util.Vector;

import org.hibernate.HibernateException;
import org.hibernate.ScrollableResults;
import org.hibernate.Session;

import com.zjxy.hibernate.HibernateSessionFactory;
import com.zjxy.hibernate.model.Score;
import com.zjxy.hibernate.model.ScoreList;

public class ScoreManager {
Session session;
	
	// 构造函数
	public ScoreManager() throws HibernateException {
		session = getSession();
	}
	
	// 成绩查询结果列表
	public List getScoreList() throws HibernateException {
		return session.createCriteria(Score.class).list();
	}
	
	public List getScoreByKemuName(String kemuName) throws HibernateException {
		List scoreList = new Vector();
		ScrollableResults scoreResults = null;
		scoreResults = session.createQuery("select a.kemuID, a.studentID, a.studentName, b.studentSex, b.studentClass, a.examTime, a.totleScore, a.score from com.zjxy.hibernate.model.Score as a, com.zjxy.hibernate.model.Student as b where a.kemuName = ? and a.studentID = b.studentID order by a.score desc")
		.setString(0, kemuName).scroll();
		while(scoreResults.next()) {
			scoreList.add(new ScoreList(scoreResults.getString(0), 
					scoreResults.getString(1), scoreResults.getString(2), 
					scoreResults.getString(3), scoreResults.getString(4), 
					scoreResults.getDate(5), scoreResults.getString(6), 
					scoreResults.getFloat(7)));
		}
		return scoreList;
	}
	
	public List getTotalScore() throws HibernateException {
		List totalScoreList = new Vector();
		ScrollableResults scoreResults = null;
		scoreResults = session.createQuery("select a.studentID, a.studentName, a.studentSex, a.studentClass, count(b.kemuID), sum(b.score) from com.zjxy.hibernate.model.Student as a, com.zjxy.hibernate.model.Score as b where a.studentID = b.studentID group by a.studentID").scroll();
		while(scoreResults.next()) {
			totalScoreList.add(new ScoreList(scoreResults.getString(0), 
					scoreResults.getString(1), scoreResults.getString(2), 
					scoreResults.getString(3), scoreResults.getLong(4), 
					scoreResults.getDouble(5)));
		}
		
		return totalScoreList;
	}
	
	// 关闭session
	public void closeSession() throws HibernateException {
		session.close();
	}
	
	// 得到session
	private Session getSession() throws HibernateException {
		return HibernateSessionFactory.currentSession();
	}
}