学生在线考试系统项目设计文档

四川交通职业技术学院

信息工程系

项目设计文档

题目：学生在线考试系统

班级软件13-1

学号 20131645、20132907、20132185、20132266 姓名姜维川、郑雨云、侯鉴航、邓凯

任课教师吉朝明

二O一五年 6 月

目录

1 需求描述 (3)

2 系统功能描述 (3)

2.1 系统功能图 (3)

2.2 系统主流程图 (3)

3 数据库设计 (5)

4 界面原型设计 (5)

5 类设计 (6)

6 关键代码 (8)

8 项目总结 (24)

9程序错误报告 (25)

10参考文献 (26)

学生在线考试系统文档

1 需求描述

该系统主要是由前台学生端和后台教师端两部分组成。前台学生端即是学生通过在线考试后得到分数，后台教师端即是对试卷和学生的信息进行管理。

2 系统功能描述

2.1 系统功能图

系统功能图如图1所示。

图1 系统功能图

2.2 系统主流程图

系统主流程图如图2所示。

图2 系统主流程图

3 数据库设计

本系统选择Mysql数据库，建立名为testsystem.mdb的数据库，涉及到主要的数据库表设计如表1-表2-表3所示。

4 界面原型设计

1.前台首页

2.后台首页

5 类设计

本系统设计了action、Aspect、dao、filter、model、service六个类，具体说明及相关类代码如下：

（1）

（2）

（3）dao类

（4）

（5）

（6）service类

6 关键代码

（1）获取及更新题目答案

package com.test.dao;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.hibernate.service.ServiceRegistry;

import org.hibernate.service.ServiceRegistryBuilder;

import com.test.model.Answer;

import com.test.model.Department;

public class AnswerDaoImp implements AnswerDao{ private SessionFactory sessionFactory;

private Session sess;

private Transaction transaction;

private void createsession(){

sess=sessionFactory.openSession();

transaction=sess.beginTransaction();

}

private void destory(){

https://www.360docs.net/doc/ee1166934.html,mit();

sess.close();

sessionFactory.close();

}

public AnswerDaoImp() {

Configuration configuration=new Configuration();

configuration.configure();

ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildS erviceRegistry();

SessionFactory

sessionFactory=configuration.buildSessionFactory(serviceRegistry);

//为当前的sessionFactory赋值

this.sessionFactory=sessionFactory;

}

@Override

public List getanswers() {

Session session=sessionFactory.openSession();

Query query=session.createQuery("from Answer");

List answers=query.list();

session.close();

return answers;

}

@Override

public List getAnswersBytid(int tid) {

Session session=sessionFactory.openSession();

Query query=session.createQuery("from Answer where test.id="+tid);

List answers=query.list();

session.close();

return answers;

}

@Override

public Answer getAnswerById(int id) {

Session session=sessionFactory.openSession();

Query query=session.createQuery("from Answer d where d.id="+id);

List answers=query.list();

if(answers.size()>0){

session.close();

return answers.get(0);

}

return null;

}

@Override

public boolean saveanswer(Answer answer) {

try {

createsession();

sess.save(answer);

https://www.360docs.net/doc/ee1166934.html,mit();

destory();

return true;

} catch (Exception e) {

// TODO: handle exception

}

return false;

}

@Override

public boolean updateanswer(Answer answer) {

try {

createsession();

sess.update(answer);

destory();

return true;

} catch (Exception e) {

// TODO: handle exception

}

return false;

}

@Override

public boolean deleteanswer(Answer answer) {

createsession();

String sql="delete from Answer where id="+answer.getId();

Query query=sess.createQuery(sql);

if(query.executeUpdate()!=0){

destory();

return true;

}

return false;

}

}

（2）测试

package com.test.dao;

import java.util.ArrayList;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import net.sf.json.JSONArray;

import net.sf.json.JSONObject;

import org.aspectj.weaver.ast.And;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.hibernate.service.ServiceRegistry;

import org.hibernate.service.ServiceRegistryBuilder;

import com.test.model.Answer;

import com.test.model.Subject;

import com.test.model.Test;

import com.test.service.Factory;

public class TestDaoImp implements TestDao{

private SessionFactory sessionFactory;

private Session sess;

private Transaction transaction;

private void createsession(){

sess=sessionFactory.openSession();

transaction=sess.beginTransaction();

}

private void destory(){

https://www.360docs.net/doc/ee1166934.html,mit();

sess.close();

sessionFactory.close();

}

public TestDaoImp() {

Configuration configuration=new Configuration();

configuration.configure();

ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildS erviceRegistry();

SessionFactory

sessionFactory=configuration.buildSessionFactory(serviceRegistry);

//为当前的sessionFactory赋值

this.sessionFactory=sessionFactory;

}

@Override

public List getTestBySid(int sid) {

Session session=sessionFactory.openSession();

Query query;

if(sid==-1){

query=session.createQuery("from Test");

}

else{

query=session.createQuery("from Test where subject.id="+sid);

}

List tests=query.list();

session.close();

return tests;

}

@Override

public JSONArray getTestBySidJson(int sid){

Session session=sessionFactory.openSession();

Query query;

if(sid==-1){

query=session.createQuery("from Test");

}

else{

query=session.createQuery("from Test where subject.id="+sid);

}

List tests=query.list();

JSONObject jsonObject;

List alltest=new ArrayList();

for (Test test : tests) {

Set answers = new HashSet();

//List

listanswers=Factory.getAnswerManage().getAnswersBytid(test.getId());

Set currentanswer=test.getAnswers();

for (Answer answer : currentanswer) {

answer.setTest(null);

answers.add(answer);

}

test.setAnswers(answers);

test.setSubject(null);

alltest.add(test);

}

JSONArray jsonArray=new JSONArray().fromObject(tests);

session.close();

return jsonArray;

}

@Override

public List getTest() {

// TODO Auto-generated method stub

return null;

}

@Override

public boolean saveTest(Test test) {

// TODO Auto-generated method stub

return false;

}

@Override

public boolean updateTest(Test test) {

// TODO Auto-generated method stub

return false;

}

@Override

public boolean deleteTest(Test test) {

// TODO Auto-generated method stub

return false;

}

}

（3）用户操作

package com.test.dao;

import java.util.ArrayList;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.hibernate.service.ServiceRegistry;

import org.hibernate.service.ServiceRegistryBuilder;

import com.test.model.Department;

import com.test.model.Professional;

import com.test.model.Student;

import com.test.model.StudentJson;

import https://www.360docs.net/doc/ee1166934.html,ers;

import com.test.service.Factory;

public class UserDaoImp implements UserDao{

private SessionFactory sessionFactory;

private Session sess;

private Transaction transaction;

private void createsession(){

sess=sessionFactory.openSession();

transaction=sess.beginTransaction();

}

private void destory(){

https://www.360docs.net/doc/ee1166934.html,mit();

sess.close();

sessionFactory.close();

}

public UserDaoImp(){

Configuration configuration=new Configuration();

configuration.configure();

ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildS erviceRegistry();

SessionFactory

sessionFactory=configuration.buildSessionFactory(serviceRegistry);

//为当前的sessionFactory赋值

this.sessionFactory=sessionFactory;

}

@Override

public boolean select_user(Users user) {

System.out.println("开始执行查找用户操作");

Configuration configuration=new Configuration();

configuration.configure();

ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildS erviceRegistry();

SessionFactory

sessionFactory=configuration.buildSessionFactory(serviceRegistry);

Session session=sessionFactory.openSession();

//Transaction transaction=session.beginTransaction();

String sql=" from Users as u where u.loginId='"+user.getLoginId()+"' and u.loginPwd='"+user.getLoginPwd()+"' and u.role='"+user.getRole()+"'";

System.out.println(sql);

Query query=session.createQuery(sql);

List alluser=query.list();

//System.out.println(alluser);

if(alluser.size()>0){

System.out.println("找到有用户");

session.close();

return true;

}

else{

System.out.println("没有找到有用户");

return false;

}

}

@Override

public Student select_studentByUid(int uid) {

System.out.println("开始根据用户的Id查找学生了");

Session session=sessionFactory.openSession();

String hsql="from Student as s where s.uid="+uid;

System.out.println(hsql);

Query query=session.createQuery(hsql);

Student student=null;

List students=query.list();

session.close();

if(students.size()>0){

student=students.get(0);

return student;

}

else{

return student;

}

}

@Override

public Users getUserByLoginId(String LoginId) {

Session session=sessionFactory.openSession();

String sql=" from Users as u where u.loginId='"+LoginId+"'";

System.out.println(sql);

Query query=session.createQuery(sql);

List alluser=query.list();

if(alluser.size()>0){

System.out.println("找到有用户");

session.close();

return alluser.get(0);

else{

return null;

}

}

@Override

public boolean updateStudent(Student student) { try {

createsession();

sess.update(student);

destory();

return true;

} catch (Exception e) {

// TODO: handle exception

}

return false;

}

@Override

public int saveUsers(Users user) {

int uid=-1;

try {

createsession();

sess.save(user);

uid=user.getId();

destory();

return uid;

} catch (Exception e) {

// TODO: handle exception

}

return uid;

}

@Override

public int saveStudent(Student student) { int id=-1;

try {

createsession();

sess.save(student);

id=student.getId();

destory();

return id;

} catch (Exception e) {

// TODO: handle exception

return id;

}

@Override

public List getAllStudents() {

Session session=sessionFactory.openSession();

String sql=" from Student";

System.out.println(sql);

Query query=session.createQuery(sql);

List alluser=query.list();

if(alluser.size()>0){

System.out.println("找到有学生");

session.close();

return alluser;

}

else{

return null;

}

}

@Override

public List getAllstudentJson() {

createsession();

String sql=" from Student";

System.out.println(sql);

Query query=sess.createQuery(sql);

List alluser=query.list();

List studentJsons=new ArrayList();

if(alluser.size()>0){

for(Student student:alluser){

StudentJson studentJson=new StudentJson();

studentJson.setAge(student.getAge().toString());

Department

department=Factory.getDepartmentManage().getDepartMentById(student.getDepart ment());

Professional

professional=Factory.getProfessionalManage().getProFeProfessionalById(studen t.getProfessionalId());

studentJson.setDepartment(department.getDname());

studentJson.setId(student.getId());

studentJson.setName(student.getName());

studentJson.setProfessional(professional.getPname());

studentJson.setSex(student.getSex());

studentJson.setXh(student.getXh());

studentJsons.add(studentJson);

}

destory();

return studentJsons;

}

else{

return null;

}

}

}

（4）获取分数

package com.test.dao;

import java.util.ArrayList;

import java.util.List;

import net.sf.json.JSONArray;

import net.sf.json.JsonConfig;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.cfg.Configuration;

import org.hibernate.service.ServiceRegistry;

import org.hibernate.service.ServiceRegistryBuilder;

import com.test.model.Grade;

import com.test.model.GradeJSon;

import com.test.model.Professional;

import com.test.model.Student;

import com.test.model.Subject;

import com.test.service.Factory;

public class GradeDaoImp implements GradeDao{ private SessionFactory sessionFactory;

private Session sess;

private Transaction transaction;

private void createsession(){

sess=sessionFactory.openSession();

transaction=sess.beginTransaction();

}

private void destory(){

https://www.360docs.net/doc/ee1166934.html,mit();

sess.close();

sessionFactory.close();

}

public GradeDaoImp() {

Configuration configuration=new Configuration();

configuration.configure();

ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildS erviceRegistry();

SessionFactory

sessionFactory=configuration.buildSessionFactory(serviceRegistry);

//为当前的sessionFactory赋值

this.sessionFactory=sessionFactory;

}

@Override

public Grade getGradeByid(int id) {

Session session=sessionFactory.openSession();

Query query=session.createQuery("from Grade g where g.id="+id);

List grades=query.list();

if(grades.size()>0){

session.close();

return grades.get(0);

}

return null;

}

@Override

public List getGradeByUid(int uid) {

System.out.println("开始根据用户的id来查找了"+uid);

createsession();

Query query;

if(uid==-1){

query=sess.createQuery("from Grade");

}

else{

query=sess.createQuery("from Grade where student.uid="+uid);

}

List grades=query.list();

for (Grade grade : grades) {

System.out.println(grade.getId());

System.out.println(grade.getSubject().getName());

System.out.println(grade.getStudent().getUid());

}

destory();

return grades;

}

@Override

public boolean saveGrade(Grade grade) {

try {

createsession();

sess.save(grade);

destory();

return true;

} catch (Exception e) {

System.out.println(e.getMessage());

}

return false;

}

@Override

public boolean deleteGradeByid(int id) { createsession();

String sql="delete from Grade where id="+id;

Query query=sess.createQuery(sql);

if(query.executeUpdate()!=0){

destory();

return true;

}

return false;

}

@Override

public boolean updateSubject(Grade grade) { try {

createsession();

sess.update(grade);

destory();

return true;

} catch (Exception e) {

// TODO: handle exception

}

return false;

}

@Override