學生在線考試系統(tǒng)項目設計

線考試系統(tǒng)項目設計信息工程系項目設計文檔題目：學生在線考試系統(tǒng) 班級軟件13-1 學號、、、 姓名姜維川、鄭雨云、侯鑒航、鄧凱任課教師吉朝明學生在線考試系統(tǒng)文檔1需求描述該系統(tǒng)主要是由前臺學生端和后臺教師端兩部分組成。前臺學生端即是學生通過在線考試后得到分數(shù)，后臺教師端即是對試卷和學生的信息進行管理。2系統(tǒng)功能描述系統(tǒng)功能圖系統(tǒng)主流程圖開始學生在線考試系統(tǒng)學生端是前臺首頁學生信息修前臺首頁開始答題否繼續(xù)答題是查看分數(shù)退出教師端是后臺首頁查后臺首頁查看試卷增刪改查結束3數(shù)據(jù)庫設計本系統(tǒng)選擇Mysql數(shù)據(jù)庫，建立名為的數(shù)據(jù)庫，涉及到主要的數(shù)據(jù)庫表設計如字段字段名字段類型可否為空說明testidINTINTINTcontentNotnullgradeINT(10)NotnullansweridINT(10)NotnullNotnullNotnullNULL鍵字字段類型INTINTNotnullNotnullNotnull可否為空content字段名鍵字字段名字段類型可否為空INTNotnull鍵uidINTNotnullnamevarchar(30)NotnullprofessionalIdINTNotnulldepartmentINTNotnulltikeIdINTvarchar(30)INTNotnullNotnullNotnulleINTNotnull4界面原型設計1.前臺首頁2.后臺首頁5類設計本系統(tǒng)設計了action、Aspect、dao、filter、model、service六個類，具體碼如下：(1)action類action+TestAction()++userAction()(2)Aspect類Aspect+LogAspect()(3)dao類o+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類SService+AnswerManage()+DepartmentManage()+Factory()+GradeManage()+ProfessionalManage()+SubjectManage()++TestManage()+UserManagerImp()6關鍵代碼(1)獲取及更新題目答案packageclassAnswerDaoImpimplementsAnswerDao{privateSessionFactorysessionFactory;privateSessionsess;privateTransactiontransaction;privatevoidcreatesession(){sess=();transaction=();}privatevoiddestory(){}publicAnswerDaoImp(){Configurationconfiguration=newConfiguration();ServiceRegistryserviceRegistry=newServiceRegistryBuilder().applySettings()).buildServiceRegistry();SessionFactorysessionFactory=(serviceRegistry);pplySettings()).buildServiceRegistry();SessionFactorysessionFactory=(serviceRegistry);etAnswersBytid());Set<Answer>currentanswer=();for(Answeranswer:currentanswer){}}JSONArrayjsonArray=newJSONArray().fromObject(tests);returnjsonArray;}@OverridepublicList<Test>getTest(){pplySettings()).buildServiceRegistry();SessionFactorysessionFactory=(serviceRegistry);pplySettings()).buildServiceRegistry();SessionFactorysessionFactory=(serviceRegistry);Sessionsession=();oString());Departmentdepartment=().getDepartMentById());Professionalprofessional=().getProFeProfessionalById());}destory();returnstudentJsons;}elsereturnnull;}}}(3)獲取分數(shù)packageclassGradeDaoImpimplementsGradeDao{privateSessionFactorysessionFactory;privateSessionsess;privateTransactiontransaction;privatevoidcreatesession(){sess=();transaction=();}privatevoiddestory(){}publicGradeDaoImp(){Configurationconfiguration=newConfiguration();ServiceRegistryserviceRegistry=newServiceRegistryBuilder().applySettings()).buildServiceRegistry();SessionFactorysessionFactory=(serviceRegistry);etName());().getProfessional().getPid());().getProfessional().getPname());ing}romObject(gradeJSons);據(jù)庫沒連接2.操作語言出錯修正方法1.打開數(shù)據(jù)庫2.修正SQL語句時間2015-4-19編號CW0001錯誤提示原因修正方法JavaEE企業(yè)應用實戰(zhàn)——Struts2＋Spring＋Hibernate整合開[2][美