【正文】 background=images/ class=STYLE1div align=center class=STYLE2考試成績/div/td /tr %conn = new conn()。table width=80% border=0 align=center cellpadding=0 cellspacing=0 tr td height=30table width=100% border=0 cellspacing=0 cellpadding=0 tr td width=15 height=30img src=images/ width=15 height=30 //td td width=1101 background=images/img src=images/ width=16 height=16 / span class=STYLE4我的成績/span/td td width=281 background=images/table border=0 align=right cellpadding=0 cellspacing=0 /table/td td width=14img src=images/ width=14 height=30 //td /tr /table/td /tr tr tdtable width=100% border=0 cellspacing=0 cellpadding=0 tr td width=9 background=images/amp。 int aa=(id)。 ResultSet rs1= (sql1)。 String sql1=select count(*) as id from Online_Examination_XJ where zhuanye=39。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。String zhuanye=(zhuanye)。ResultSet rss=(sqla)。+username+39。//教官部分body% String username=(String)(user1)。 int aa = (id)。 ResultSet rs1 = (sql1)。 String sql1 = select count(*) as id from Online_Examination_XJ where username=39。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。nbsp。關(guān)鍵代碼如下：//學(xué)員部分body % String username = (String) (user1)。input type=radio name=%=(name_input)% value=%=(xxd) %D:%=(xxd)%/div/td /tr%} %/tableinput type=submit value=提交試卷/form/body%}% 成績查詢模塊該模塊是考試成績查詢功能的模塊，分為學(xué)員查詢和教官查詢兩方面。amp。amp。input type=radio name=%=(name_input)% value=%=(xxc) %C:%=(xxc)%amp。amp。amp。input type=radio name=%=(name_input)% value=%=(xxb) %B:%=(xxb)%amp。amp。amp。input type=radio name=%=(name_input)% value=%=(xxa) %A:%=(xxa)%amp。amp。amp。amp。amp。amp。%=(timu) %/font/div/td /tr tr td width=60 height=18 background=images/ class=STYLE1/td td height=18 background=images/ class=STYLE1amp。amp。amp。amp。amp。amp。%form action= method=postinput type=hidden name=shuliang value=%=shuliang%input type=hidden name=student_name value=%=student_name%input type=hidden name=shijuan_name value=%=shijuan_name%input type=hidden name=zhuanye value=%=zhuanye%input type=hidden name=xueyuan value=%=xueyuan%table width=500 border=0 align=center cellpadding=0 cellspacing=1 bgcolor=c0de98 onmouseover=changeto() onmouseout=changeback() %while(()){ % tr td width=60 height=18 background=images/ class=STYLE1div align=center class=STYLE2 STYLE1題目%=aaa++ %：/div/td td height=18 background=images/ class=STYLE1font color=redamp。()。conn con3 = new conn()。int aaa=1。conn con = new conn()。(sql)。+username+39。+xueyuan+39。+zhuanye+39。039。+shijuan_name+39。+student_name+39。/script%}else{conn = new conn()。if(()){%scriptalert(您已經(jīng)考過了！)。conn n = new conn()。 and shijuan_name=39。%bfont size=6 color=blue%=(shijuan_name)%/font/bbr(共%=(timu_shuliang)%題，每題%=(meitifenshu)%分，總分%=(zongfen)%)(時間：%=(kaoshi_sj)%分鐘)brbr %String sql1=select * from Online_Examination_XJ where student_name=39。ResultSet rs11=(sql11)。+shijuan_name+39。xueyuan=new String((ISO88591),gb2312)。zhuanye=new String((ISO88591),gb2312)。shijuan_name=new String((ISO88591),gb2312)。student_name=new String((ISO88591),gb2312)。關(guān)鍵代碼如下：%String username=(String)(user1)。主數(shù)據(jù)庫名為User1，現(xiàn)將主要表結(jié)構(gòu)描述如表41下：表41考題類型表編號列名數(shù)據(jù)類型空標(biāo)記/主鍵說明1IdInt(4)N/Y編號2leixingvarchar(50)N/N考題題型表42 班級表編號列名數(shù)據(jù)類型空標(biāo)記/主鍵說明1IDInt(4)N/Y編號2banjivarchar(50)N/N班級名稱3xueyuanvarchar(50)N/N學(xué)院名稱表43 試卷信息表編號列名數(shù)據(jù)類型空標(biāo)記/主鍵說明1Idint(4)N/Y編號2shijuan_namevarchar(50)N/N試卷名稱3shijuan_bumenvarchar(50)N/Y試卷類型4timu_shuliangvarchar(50)N/N題目數(shù)量5meitifenshuvarchar(50)N/N每題分?jǐn)?shù)6zongfenvarchar(50)N/N總分7kaoshi_sjchar(10)N/N考試時間表44 人員表編號列名數(shù)據(jù)類型空標(biāo)記/主鍵說明1idInt(4)N/Y編號2UsernameVarchar(50)N/N賬號3passwordVarchar(50)N/N密碼4rnameVarchar(50)N/N姓名5TimeaVarchar(50)N/N生日6sexVarchar(50)N/N性別7XueyuanVarchar(50)N/N學(xué)院8zhuanyeVarchar(50)N/N專業(yè)9banjiVarchar(50)N/N班級10xuehaoVarchar(50)N/N學(xué)號11Varchar(50)N/N郵箱12qua