【正文】 char(20)FALSEFALSE執(zhí)行人、修改人上傳人uploadervarchar(20)FALSEFALSE上傳人完成時(shí)間plieteDateDatetimeFALSEFALSE完成時(shí)間審核時(shí)間checkDateDatetimeFALSEFALSE審核時(shí)間令牌IDtokenbigint(20)FALSEFALSE令牌ID任務(wù)實(shí)例IDtaskInstancebigint(20)FALSEFALSE任務(wù)實(shí)例ID流程IDprocessInstancebigint(20)FALSEFALSE流程ID所屬教師teacherIntFALSEFALSE所屬教師發(fā)起人審核意見(jiàn)appContentvarchar(200)FALSEFALSE發(fā)起人審核意見(jiàn)續(xù)表勘誤表字段名字段類型PKNULL缺省注釋發(fā)起人部門sendDeptvarchar(20)FALSEFALSE發(fā)起人部門接收人部門receiveDeptvarchar(20)FALSEFALSE接收人部門上傳時(shí)間uploadDateDatetimeFALSEFALSE上傳時(shí)間欄目columnsvarchar(45)FALSETRUE欄目所屬班級(jí)classIDIntFALSEFALSE所屬班級(jí)修改完成時(shí)間executeDateDatetimeFALSEFALSE修改完成時(shí)間文件個(gè)數(shù)fileCountIntFALSEFALSE文件個(gè)數(shù)是否需要備份isNeedBakBitFALSEFALSE是否需要備份文件類型typevarchar(45)FALSEFALSE文件類型勘誤狀態(tài)statusSmallint(6)FALSEFALSE勘誤狀態(tài)(8) 課件成品 CDEL_FINALLY_FILE表結(jié)構(gòu)的定義，如表411所示：表 411 課件成品表字段名字段類型PKNULL缺省注釋文件IDfileIDIntTRUETRUE文件ID課件IDcoursewareIDIntFALSETRUE課件ID令牌IDtokenbigint(20)FALSEFALSE令牌ID任務(wù)實(shí)例IDtaskInstancebigint(20)FALSEFALSE任務(wù)實(shí)例ID流程IDprocessInstancebigint(20)FALSEFALSE流程ID成品文件名Namevarchar(64)FALSEFALSE成品文件名文件類型TypeSmallint(6)FALSETRUE文件類型 0為視頻文件，1為頁(yè)面文件加密方法encryptionSmallint(6)FALSEFALSE加密方法網(wǎng)站路徑urlvarchar(256)FALSEFALSE網(wǎng)站路徑存放路徑Pathvarchar(256)FALSEFALSE存放路徑創(chuàng)建者creatorvarchar(64)FALSEFALSE創(chuàng)建者創(chuàng)建時(shí)間createTimeDatetimeFALSEFALSE創(chuàng)建時(shí)間操作人operatorbigint(20)FALSEFALSE操作人續(xù)表課件成品表字段名字段類型PKNULL缺省注釋加密時(shí)間operTimeDatetimeFALSEFALSE加密時(shí)間上傳人uploadManbigint(20)FALSEFALSE上傳人上傳時(shí)間uploadTimeDatetimeFALSEFALSE上傳時(shí)間審查內(nèi)容checkContentTextFALSEFALSE審查的內(nèi)容標(biāo)志remarkTextFALSEFALSE標(biāo)志文件格式類型RealsSmallint(6)FALSEFALSE0文件格式類型mediaSmallint(6)FALSEFALSE0FlvSmallint(6)FALSEFALSE0mp3Smallint(6)FALSEFALSE0WmaSmallint(6)FALSEFALSE0(9) 任務(wù)表 CDEL_JOB表結(jié)構(gòu)的定義，如表412所示：表 412 任務(wù)表字段名字段類型PKNULL缺省注釋任務(wù)IDjobIDIntTRUETRUE任務(wù)ID班級(jí)IDclassIDIntFALSETRUE班級(jí)ID發(fā)起人creatorvarchar(45)FALSETRUE發(fā)起人發(fā)起時(shí)間createTimeDatetimeFALSETRUE發(fā)起時(shí)間狀態(tài)statusvarchar(45)FALSETRUE狀態(tài)令牌IDtokenbigint(20)FALSEFALSE令牌ID任務(wù)實(shí)例IDtaskInstancebigint(20)FALSEFALSE任務(wù)實(shí)例ID流程IDprocessInstancebigint(20)FALSEFALSE流程ID任務(wù)說(shuō)明jobExplainTextFALSEFALSE任務(wù)說(shuō)明任務(wù)到期時(shí)間overTimeDatetimeFALSETRUE任務(wù)到期時(shí)間講義notesSmallint(6)FALSETRUE講義手寫板tabletSmallint(6)FALSEFALSE手寫板是否實(shí)驗(yàn)exprimentSmallint(6)FALSEFALSE是否實(shí)驗(yàn)老師IDteacherIDIntFALSETRUE老師ID續(xù)表任務(wù)表字段名字段類型PKNULL缺省注釋是否獨(dú)立制作aloneIntFALSETRUE0s0為否 1為是任務(wù)標(biāo)題titlevarchar(128)FALSEFALSE任務(wù)標(biāo)題(10) 錄制表CDEL_REC表結(jié)構(gòu)的定義，如表413所示：表 413 錄制表字段名錄制表字段類型PKNULL缺省注釋錄制IDrecIDIntTRUETRUE錄制ID教師IDteacherIDIntFALSETRUE教師ID班級(jí)IDclassIDIntFALSETRUE班級(jí)ID令牌IDtokenbigint(20)FALSEFALSE令牌ID任務(wù)實(shí)例IDtaskInstancebigint(20)FALSEFALSE任務(wù)實(shí)例ID流程IDprocessInstancebigint(20)FALSEFALSE流程ID錄制時(shí)間recDateDatetimeFALSEFALSE錄制時(shí)間錄制時(shí)長(zhǎng)recLongIntFALSEFALSE錄制時(shí)長(zhǎng)錄制內(nèi)容recContentTextFALSEFALSE錄制內(nèi)容第一次錄制?firstSmallint(6)FALSEFALSE第一次錄制?攝錄人員recervarchar(20)FALSEFALSE攝錄人員保存路徑saveURLvarchar(100)FALSEFALSE保存路徑手寫板tabletSmallint(6)FALSEFALSE手寫板講義notesSmallint(6)FALSEFALSE講義預(yù)約IDreservationIDIntFALSETRUE預(yù)約IDfirst字段說(shuō)明：當(dāng)值為0時(shí)，表示第一次錄制；當(dāng)值為1時(shí)，表示正常錄制；當(dāng)值為2時(shí)，表示試錄錄制；當(dāng)值為3時(shí)，表示重錄。第五章 詳細(xì)設(shè)計(jì) 時(shí)序圖的設(shè)計(jì)時(shí)序圖是UML行為圖，它通過(guò)描述對(duì)象之間發(fā)送消息的時(shí)間順序顯示多個(gè)對(duì)象之間的動(dòng)作協(xié)作關(guān)系，多用作表示用例的行為順序，當(dāng)執(zhí)行一個(gè)用例行為時(shí)，時(shí)序圖中每一條消息對(duì)應(yīng)了一個(gè)類操作或狀態(tài)機(jī)中引起轉(zhuǎn)化的觸發(fā)事件，在這里列出了三個(gè)分別是發(fā)起勘誤時(shí)序圖、教務(wù)自檢時(shí)序圖以及音視頻采集時(shí)序圖，分別如圖5553所示：圖 51 發(fā)起勘誤時(shí)序圖圖 52 教務(wù)自檢時(shí)序圖圖 53 音視頻采集時(shí)序圖 類圖的設(shè)計(jì)類圖是顯示模型的靜態(tài)結(jié)構(gòu)，根據(jù)該系統(tǒng)設(shè)計(jì)類圖，如圖54所示：圖 54 系統(tǒng)類圖第六章 系統(tǒng)實(shí)現(xiàn) 核心實(shí)現(xiàn)代碼 工作流程定義實(shí)現(xiàn)發(fā)起勘誤流程定義：?xml version= encoding=UTF8?processdefinition xmlns=urn:: name=erratr ! 泳道，用于定義角色和用戶 swimlane name=erracademicleader assignment class=.BaseSwimlaneAssignHandler / /swimlane swimlane name=errcwleader ! 流程執(zhí)行者委派的實(shí)現(xiàn)類 assignment class=.BaseSwimlaneAssignHandler //swimlane swimlane name=errcwemp assignment class=.BaseSwimlaneAssignHandler / /swimlane swimlane name=errexecutor assignment class=.ExecutorAssignHandler / /swimlane swimlane name=errleader assignment class=.LeaderAssignHandler / /swimlane ! 起始結(jié)點(diǎn) startstate name=SS_init task name=TK_ErErrReport/task transition to=TN_leaderCheck/transition ! 流程離開(kāi)結(jié)點(diǎn)觸發(fā)事件 event type=nodeleave action name=AC_SetVariable class=./action/event/startstate ! 任務(wù)結(jié)點(diǎn) tasknode name=TN_leaderCheck !— 指定執(zhí)行者和任務(wù)的實(shí)現(xiàn)類 task name=TK_ErLeaderCheck swimlane=erracademic leader/task transition to=TN_leaderAssign/transition /tasknode tasknode name=TN_leaderAssign task name=TK_ErLeaderAssign swimlane=errcwleader/task! 流程轉(zhuǎn)移下個(gè)結(jié)點(diǎn) transition to=TN_memberOperate/transition/tasknode tasknode name=TN_memberOperate task name=TK_ErMemberOperate swimlane=errcwemp/task transition to=TN_upload/transition /tasknode tasknode name=TN_upload task name=TK_ErUpload swimlane=errcwemp2/task transition to=TN_applicantCheck/transition /tasknode tasknode name=TN_applicantCheck task name=TK_ErApplicantCheck swimlane=erracademicemp/task ! 有兩路的分支 transition to=DS_isNeedBak name=tr_