2009年高考成绩查询系统

功能简介:

可以按准考证号：  与 考生姓名：  查询出相关学生的成绩.此系统为最基础的ASP查询程序.建议ASP初学者学习参考...

查询结果代码:
<%
  dim zkzh2
  dim name2
  zkzh2 = Request("ksbh1")
  name2 = Request("name1")
 
sql="select * from chengji where name='"&trim(name2)&"' and ksbh='"&trim(zkzh2)&"' "
 set rs=server.createobject("adodb.recordset")
 rs.open sql,conn,1,3
 IF rs.eof Then
   response.Redirect("err.asp")
   else
%>

<table width="650" height="200" border="0" cellpadding="1" cellspacing="1" bordercolor="#000000">
  <tr>
    <td height="50"><div align="center" class="STYLE3">
      <%
   Response.Write("2009年高考成绩查询结果")
  
%>
    </div></td>
  </tr>
  <tr>
    <td height="33"> <span class="STYLE1">准考证号：<%=rs ("ksbh")%></br>
        考生姓名：
        <% =rs ("name") %>
        </br>
        考生类别：
        <% =rs ("leibie") %>
    </span></td>
  </tr>
  <tr>
    <td height="50"><span class="STYLE1">语文：</span>
    <% =rs ("yuwen") %>
    <span class="STYLE1">数学：</span>
   <% =rs ("shuxue") %>
    <span class="STYLE1">英语：</span>
    <% =rs ("yingyu") %>
    <span class="STYLE1">理基：</span>
    <% =rs ("liji") %>
    <span class="STYLE1">化学：</span>    <%=rs ("huaxue") %>
    <span class="STYLE1">生物：</span>
   <% =rs ("shengwu") %>
    <span class="STYLE1">总分：</span>
    <% =rs ("zongfen") %></td>
  </tr>
  <tr>
    <td height="50"> <span class="STYLE1">过分数线：</span>
      <% =rs ("gaokao") %></td>
  </tr>
</table>

 
<p class="STYLE2">
  <%  
end if
rs.close
set rs=nothing
%>