<hr width="50%">
<table align="center" border="0" width="50%">
<tr><td><b>准考证号:</b><%=rs("student_test_num ")%></td></tr>
<tr><td><b>姓名:</b><%=rs("student_name ")%></td></tr>
<tr><td><b>类别: </td></tr>
<tr><td><b>成绩:</b><%=rs("Test_score")%></td></tr></table>
<%rs.close
set rs=nothing
else response.Write("姓名错误,请重填!")
end if%>
B、用JSP实现,请在横线处填写出相关语句
seachscore.jsp页面关键代码:
<center><font size="4"><b>计算机等级考试成绩查询</b></font></center>
<center><b>请输入准考证号和姓名</b></center>
<table align="center" cellpadding="0" cellspacing="0" border="1">
<tr><td><b>准考证号:</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页面关键代码:
<@ INCLUDE file="CONN.JSP"%>
<script language="JavaScript">
Function ShowClass(String TEST_CLASS){
if(TEST_CLASS =='6') document.write("三级 for 网络技术");
if(TEST_CLASS =='5') document.write("三级 for 数据库技术");
if(TEST_CLASS =='4') document.write("三级 for 软件技术");
if(TEST_CLASS =='1') document.write("三级 for 微机技术及应用");
}
</script>
<%
if(testnum ==""||testname ==""){
%><script>alert("准考证号和姓名必填,请重输!")</script><script>history.go(-1)</script><% }
);
if(!rs.next()){
%><script>alert("准考证号错误,请重填!")</script><script>history.go(-1)</script><%