2011年計算機三級網(wǎng)絡(luò)技術(shù)考試課后習(xí)題及答案(8)

A、用ASP實現(xiàn)，請在橫線處填寫出相關(guān)語句

seachscore.asp頁面關(guān)鍵代碼:
<center><font size="4"><b>計算機等級考試成績查詢</b></font></center>
(1)                                          
<center><b>請輸入準(zhǔn)考證號和姓名</b></center>
<table align="center" cellpadding="0" cellspacing="0" border="1">
<tr><td><b>準(zhǔn)考證號：</b></td>
<td><input type="text" name="student_test_num"><br></td></tr>
<tr><td><b>姓名：</b></td>
<td><input type="text" name="student_name"><br></td></tr>
<tr><td colspan="2" rowspan="2" nowrap>
<center><input type="submit" value="查詢"></center></td></tr>
</table></form>

showscore.asp頁面關(guān)鍵代碼:

<!--#INCLUDE file="CONN.ASP" -->
<% Function ShowClass(Test_Class)
if Test_Class =6 then  response.Write"三級 for 網(wǎng)絡(luò)技術(shù)"
if Test_Class =5 then  response.Write"三級 for 數(shù)據(jù)庫技術(shù)"
if Test_Class =4 then  response.Write("三級 for 軟件技術(shù)")
if Test_Class =1 then  response.Write("三級 for 微機技術(shù)及應(yīng)用")
End Function %>
<% dim rs，testnum，testname
(2)                                                         
(3)                                                         
if testnum ="" or testname ="" then
%><script>alert("準(zhǔn)考證號和姓名必填，請重輸！")</script><script>history.go(-1)</script><%
end if
set rs=conn.execute(___(4)                                )
if rs.eof then
 %><script>alert("準(zhǔn)考證號錯誤，請重填！")</script><script>history.go(-1)</script><%
end if
if ____(5)                                 then
%>
<center><h4><%=rs("student_name ")%>同學(xué)，你的計算機等級考試成績?nèi)缦拢?lt;/h3>
<hr width="50%">
<table align="center" border="0" width="50%">
<tr><td><b>準(zhǔn)考證號：</b><%=rs("student_test_num ")%></td></tr>
<tr><td><b>姓名：</b><%=rs("student_name ")%></td></tr>
<tr><td><b>類別：</b>____(6)                                 </td></tr>
<tr><td><b>成績：</b><%=rs("Test_score")%></td></tr></table>
<%rs.close
set rs=nothing
else response.Write("姓名錯誤，請重填！")
end if%>

B、用JSP實現(xiàn)，請在橫線處填寫出相關(guān)語句

seachscore.jsp頁面關(guān)鍵代碼:

<center><font size="4"><b>計算機等級考試成績查詢</b></font></center>
 (1)                               
<center><b>請輸入準(zhǔn)考證號和姓名</b></center>
<table align="center" cellpadding="0" cellspacing="0" border="1">
<tr><td><b>準(zhǔn)考證號：</b></td>
<td><input type="text" name="student_test_num"><br></td></tr>
<tr><td><b>姓名：</b></td>
<td><input type="text" name="student_name"><br></td></tr>
<tr><td colspan="2" rowspan="2" nowrap>
<center><input type="submit" value="查詢"></center></td></tr>
</table></form>

showscore.jsp頁面關(guān)鍵代碼:

<@ INCLUDE file="CONN.JSP"%>
<script language="JavaScript">
Function ShowClass(String TEST_CLASS){
if(TEST_CLASS =='6') document.write("三級 for 網(wǎng)絡(luò)技術(shù)");
if(TEST_CLASS =='5') document.write("三級 for 數(shù)據(jù)庫技術(shù)");
if(TEST_CLASS =='4') document.write("三級 for 軟件技術(shù)");
if(TEST_CLASS =='1') document.write("三級 for 微機技術(shù)及應(yīng)用");
}
</script>
<%
(2)                                                         
(3)                                                         
if(testnum ==""||testname ==""){
%><script>alert("準(zhǔn)考證號和姓名必填，請重輸！")</script><script>history.go(-1)</script><%
}
rs=stmt.executeQuery(___(4)                                );
if(!rs.next()){
 %><script>alert("準(zhǔn)考證號錯誤，請重填！")</script><script>history.go(-1)</script><%
}
if(______(5)                                ){
%>
<center><h4><%=testname%>同學(xué)，你的計算機等級考試成績?nèi)缦拢?lt;/h3>
<hr width="50%">
<table align="center" border="0" width="50%">
<tr><td><b>準(zhǔn)考證號：</b><%=rs.getString("STUDENT_TEST_NUM ")%></td></tr>
<tr><td><b>姓名：</b><%=rs.getString("STUDENT_NAME ")%></td></tr>
<tr><td><b>類別：</b>______(6)                                 </td></tr>
<tr><td><b>成績：</b><%=rs.getString("TEST_SCORE")%></td></tr></table>
<%stmt.close();
con.close();
}%>

　　

　　相關(guān)推薦：

　　2011年計算機等級考試報名

　　2011年計算機等級考試報名方法