在線考試系統(tǒng)數(shù)據(jù)庫設(shè)計與實現(xiàn)-在線瀏覽
2025-05-12 00:07本頁面
【正文】 ONTENT VARCHAR2(40) , ANSWER VARCHAR2(10) , SCORE CHAR(4) , CONSTRAINT TITLE_PK PRIMARY KEY ( CNO , TITLENO ) ENABLE )。//創(chuàng)建學(xué)生答題表CREATE TABLE PAPER ( CNO CHAR(4) NOT NULL , SNO CHAR(9) NOT NULL , TITLENO CHAR(4) NOT NULL , SANSWER VARCHAR2(10) , GETSCORE CHAR(4) , CONSTRAINT PAPER_PK PRIMARY KEY ( CNO , SNO , TITLENO ) ENABLE )。ALTER TABLE PAPERADD CONSTRAINT PAPER_FK2 FOREIGN KEY( SNO )REFERENCES STUDENT( SNO )ON DELETE CASCADE ENABLE。CREATE USER teacer1 IDENTIFIED BY 123456 。Commit。CALL MANASTU (39。,39。39。)；Create or replace procedure manatea(tid in CHAR,password in varchar2)IsBeginInsert into teacherValues(TID, PASSWORD)。End。teacher139。12345639。Commit。CALL MANACOU (39。,39。)；Create or replace procedure manasc(o in CHAR,sno in char)IsBeginInsert into SCValues(o, sno,NULL)。End。000139。4141005139。score1 char(4)。Sno1 char(9)。exception when no_data_found then (39。)。if Sanswer_input = answer1 THEN Insert into paper Values(o_input,sno_input,titleno_input,sanswer_inut,score1)。039。END IF。End。000139。4141005139。0139。B39。//修改題目存儲過程//修改題目create or replace procedure XGTM( o_input in char, titleno_input in char, titlecontent_input in varchar2)isbeginupdate title set = titlecontent_inputWHERE = o_input AND = titleno_input。end。mit。//修改分數(shù)create or replace procedure XGFS( o_input in char, titleno_input in char, score_input in char)isbeginupdate title set = score_inputWHERE = o_input AND = titleno_input。end。beginv_sql := 39。EXECUTE IMMEDIATE v_sql using o_input,sno_input。//成績統(tǒng)計過程（學(xué)生考試完成點擊提交時）create or replace procedure TJ(o_input in char,sno_input in char)istotle number(10,0)。update sc set = totleWHERE = o_input AND = sno_input。end。000139。4141005039。 查詢//查卷（視圖）CREATE or replace VIEW PAPER_VIEW_41410051(titleno,titlecontent,answer,sanswer,gerscore)AS SELECT ,FROM title,paperWHERE = AND = AND =39。order by titleno。Col answer format a47。正確答案是39。你的答案是39。得分39。4141005139。//查看試題SELECT ,FROM titleWHERE =39。order by titleno。000139。//查看課程平均分Select avg(grade) from scWhere =39。 登陸設(shè)計由于做登陸的時候分表查詢用戶信息一直出bug，經(jīng)過搜索解決辦法后決定建立一個教師學(xué)生用戶表來解決問題create table P_USER ( username CHAR(9), password VARCHAR2(20), ) 從此表中只判斷登陸是否成功。 charset=UTF8 titlelogin/title /head body form action=://localhost:8080/loginServlet/LoginServlet method=post 歡迎使用在線考試系統(tǒng) 用戶名：input type=text name=username /br/ 密碼：input type=password name=password /br/ input type=submit value=登錄 / /form /body
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1