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

四川交通职业技术学院信息工程系项目设计文档题 目：学生在线考试系统班 级 软件13-1 学 号 20131645、20132907、20132185、20132266 姓 名 姜维川、郑雨云、侯鉴航、邓凯 任课教师 吉朝明 二O一五 年 6 月目录1 需求描述32 系统功能描述32.1 系统功能图32.2 系统主流程图33 数据库设计54 界面原型设计55 类设计66 关键代码88 项目总结249程序错误报告2510参考文献25学生在线考试系统文档1 需求描述该系统主要是由前台学生端和后台教师端两部分组成。前台学生端即是学生通过在线考试后得到分数，后台教师端即是对试卷和学生的信息进行管理。2 系统功能描述2.1 系统功能图系统功能图如图1所示。图1 系统功能图2.2 系统主流程图系统主流程图如图2所示。图2 系统主流程图3 数据库设计本系统选择Mysql数据库，建立名为testsystem.mdb的数据库，涉及到主要的数据库表设计如表1-表2-表3所示。表1 test字段名字段类型可否为空说明idINT（10）Not null主键testidINT（10）Not nullsidINT（10）NULLcontenttextNot nullgradeINT（10）Not nullansweridINT（10）Not null表2 answer字段名字段类型可否为空说明idINT（10）Not null主键tidINT（10）Not nullcontenttextNot null表3 student字段名字段类型可否为空说明idINT（10）Not null主键uidINT（10）Not nullnamevarchar(30)Not nullprofessionalIdINT（10）Not nulldepartmentINT（10）Not nullxhINT（10）Not nullsexvarchar(30)Not nulltikeIdINT（10）Not nullageINT（10）Not null4 界面原型设计1. 前台首页2. 后台首页5 类设计本系统设计了action、Aspect、dao、filter、model、service六个类，具体说明及相关类代码如下：（1） action类action+TestAction( )+userAction( )（2） Aspect类Aspect+LogAspect( )（3）dao类dao+AnswerDao( )+DepartMentDao( )+GradeDao( )+ProfessionalDao( )+SubjectDao( )+TestDao( )+UserDao( )（4）filter类filter+MyFilter( )（5） model类model+Answer( )+Department( )+Grade( )+GradeJSon( )+Loganderror( )+Professional( )+Student( )+StudentJson( )+Subject( )+Test( )+Users( )（6） service类Service+AnswerManage( )+DepartmentManage( )+Factory( )+GradeManage( )+ProfessionalManage( )+SubjectManage( )+TestManage( )+UserManagerImp( )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 AnswerDaoprivate SessionFactory sessionFactory;private Session sess;private Transaction transaction;private void createsession()sess=sessionFactory.openSession();transaction=sess.beginTransaction();private void destory()mit();sess.close();sessionFactory.close();public AnswerDaoImp() Configuration configuration=new Configuration();configuration.configure();ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties().buildServiceRegistry();SessionFactory sessionFactory=configuration.buildSessionFactory(serviceRegistry);/为当前的sessionFactory赋值this.sessionFactory=sessionFactory;Overridepublic List getanswers() Session session=sessionFactory.openSession();Query query=session.createQuery(from Answer);List answers=query.list();session.close();return answers;Overridepublic 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;Overridepublic 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;Overridepublic boolean saveanswer(Answer answer) try createsession();sess.save(answer);mit();destory();return true; catch (Exception e) / TODO: handle exceptionreturn false;Overridepublic boolean updateanswer(Answer answer) try createsession();sess.update(answer);destory();return true; catch (Exception e) / TODO: handle exceptionreturn false;Overridepublic 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 TestDaoprivate SessionFactory sessionFactory;private Session sess;private Transaction transaction;private void createsession()sess=sessionFactory.openSession();transaction=sess.beginTransaction();private void destory()mit();sess.close();sessionFactory.close();public TestDaoImp() Configuration configuration=new Configuration();configuration.configure();ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties().buildServiceRegistry();SessionFactory sessionFactory=configuration.buildSessionFactory(serviceRegistry);/为当前的sessionFactory赋值this.sessionFactory=sessionFactory;Overridepublic 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;Overridepublic 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;Overridepublic List getTest() / TODO Auto-generated method stubreturn null;Overridepublic boolean saveTest(Test test) / TODO Auto-generated method stubreturn false;Overridepublic boolean updateTest(Test test) / TODO Auto-generated method stubreturn false;Overridepublic boolean deleteTest(Test test) / TODO Auto-generated method stubreturn 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 com.test.model.Users;import com.test.service.Factory;public class UserDaoImp implements UserDaoprivate SessionFactory sessionFactory;private Session sess;private Transaction transaction;private void createsession()sess=sessionFactory.openSession();transaction=sess.beginTransaction();private void destory()mit();sess.close();sessionFactory.close();public UserDaoImp()Configuration configuration=new Configuration();configuration.configure();ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties().buildServiceRegistry();SessionFactory sessionFactory=configuration.buildSessionFactory(serviceRegistry);/为当前的sessionFactory赋值this.sessionFactory=sessionFactory;Overridepublic boolean select_user(Users user) System.out.println(开始执行查找用户操作);Configuration configuration=new Configuration();configuration.configure();ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties().buildServiceRegistry();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;elseSystem.out.println(没有找到有用户);return false;Overridepublic 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;elsereturn student;Overridepublic 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);elsereturn null;Overridepublic boolean updateStudent(Student student) try createsession();sess.update(student);destory();return true; catch (Exception e) / TODO: handle exceptionreturn false;Overridepublic int saveUsers(Users user) int uid=-1;try createsession();sess.save(user);uid=user.getId();destory();return uid; catch (Exception e) / TODO: handle exceptionreturn uid;Overridepublic int saveStudent(Student student) int id=-1;try createsession();sess.save(student);id=student.getId();destory();return id; catch (Exception e) / TODO: handle exceptionreturn id;Overridepublic 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;elsereturn null;Overridepublic 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.getDepartment();Professional professional=Factory.getProfessionalManage().getProFeProfessionalById(student.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;elsereturn 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 GradeDaoprivate SessionFactory sessionFactory;private Session sess;private Transaction transaction;private void createsession()sess=sessionFactory.openSession();transaction=sess.beginTransaction();private void destory()mit();sess.close();sessionFactory.close();public GradeDaoImp() Configuration configuration=new Configuration();configuration.configure();ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(configuration.getProperties().buildServiceRegistry();SessionFactory sessionFactory=configuration.buildSessionFactory(serviceRegistry);/为当前的sessionFactory赋值this.sessionFactory=sessionFactory;Overridepublic 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;Overridepublic 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;Overridepublic boolean saveGrade(Grade grade) try createsession();sess.save(grade);destory();return true; catch (Exception e) System.out.println(e.getMessage();return false;Overridepublic 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;Overridepublic boolean updateSubject(Grade grade) try createsession();sess.update(grade);destory();return true; catch (Exception e) / TODO: handle exceptionreturn false;Overridepublic List getGradeBySid(int sid) Session session=sessionFactory.openSession();Query query;if(sid=-1)query=session.createQuery(from Grade);else query=session.createQuery(from Grade where subject.id=+sid);List grades=query.list();session.close();return grades;Overridepublic List getAllGradeJSON() Session session=sessionFactory.openSession();Query query=session.createQuery(from Grade);List grades=query.list();JsonConfig config =