总共有三个部分。。我一个一个的写出来。。请给我讲讲相关的知识。好吗?
主要功能是。组合查询。一个学生的考试情况。。
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>学生历史查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<link rel="stylesheet" href="2cc.css" type="text/css">
</head>
<body background="MTVTD.GIF">
<div id="Layer1" style="position:absolute; left:1px; top:1px; width:448px; height:48px; z-index:1"><img src="TB.GIF" width="850" height="99"></div>
<center>
<p> </p>
<p> </p>
<p> </p>
</center>
<center><font size="7" color="blue">学生历史查询</font><br>
<table>
<tr><td align="center" colspan="6"><font size="5" color="blue">请输入查询信息</font></td></tr>
<form method="post" action="findhistory2.asp">
<tr>
<td align="right">项目:</td>
<td><select name="xm">
<option>学号</option>
<option>科目</option>
主要功能是。组合查询。一个学生的考试情况。。
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>学生历史查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<link rel="stylesheet" href="2cc.css" type="text/css">
</head>
<body background="MTVTD.GIF">
<div id="Layer1" style="position:absolute; left:1px; top:1px; width:448px; height:48px; z-index:1"><img src="TB.GIF" width="850" height="99"></div>
<center>
<p> </p>
<p> </p>
<p> </p>
</center>
<center><font size="7" color="blue">学生历史查询</font><br>
<table>
<tr><td align="center" colspan="6"><font size="5" color="blue">请输入查询信息</font></td></tr>
<form method="post" action="findhistory2.asp">
<tr>
<td align="right">项目:</td>
<td><select name="xm">
<option>学号</option>
<option>科目</option>
解决方案 »
- 三层构架的方式
- sql server如何处理0001-1-1 0:00:00
- fck "Invalid file type"
- 请问:这个使用Dictionary遇到的问题 ??
- 表单提交成功后,如何自动更改该表单页面内某些域的值?
- 超高难读-文件上传问题。在线给(100分)
- 本地正常,远程出现Server Error in '/' Application错误
- 服务器无法加载应用程序 '/LM/W3SVC'。错误是 '找不到指定的元数据。aspnet网页不能浏览
- StackOverflowException 异常,为难ing
- 问题虽小,不简单,怎么知道一个树结点的父结点
- 这个错误怎么解决??
- 哪一本书好???
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>学生历史查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<link rel="stylesheet" href="2cc.css" type="text/css">
</head>
<body background="MTVTD.GIF">
<div id="Layer1" style="position:absolute; left:1px; top:1px; width:448px; height:48px; z-index:1"><img src="TB.GIF" width="850" height="99"></div>
<center>
<p> </p>
<p> </p>
<p> </p>
</center>
<center>
<font size="7" color="blue">学生历史查询</font><br>
<%
if request.servervariables("REQUEST_METHOD")="POST" then
xm=request("xm")
cx=request("cx")
tj=request("tj")
if xm="学号" then
if len(cx)>2 then
cx=request("cx")+" "+request("ff")+" "+"stid"+request("fh")+"'"+request("z")+"'"
tj=request("tj")+" "+request("ff")+" "+request("xm")+request("fh")+request("z")
else
cx="stid"+request("fh")+"'"+request("z")+"'"
tj=request("xm")+request("fh")+request("z")
end if
elseif xm="科目" then
if len(cx)>2 then
cx=request("cx")+" "+request("ff")+" "+"subject"+request("fh")+"'"+request("z")+"'"
tj=request("tj")+" "+request("ff")+" "+request("xm")+request("fh")+request("z")
else
cx="subject"+request("fh")+"'"+request("z")+"'"
tj=request("xm")+request("fh")+request("z")
end if
elseif xm="总分" then
z=request("z")
if isnumeric(z)=0 then
%>
<font size="7" color="red">警告:总分错误。<br>
不能添加。</font>
<%
else
if len(cx)>2 then
cx=request("cx")+" "+request("ff")+" "+"zscore"+request("fh")+"'"+request("z")+"'"
tj=request("tj")+" "+request("ff")+" "+request("xm")+request("fh")+request("z")
else
cx="zscore"+request("fh")+"'"+request("z")+"'"
tj=request("xm")+request("fh")+request("z")
end if
end if
end if
%>
<table>
<tr><td align="center" colspan="6"><font size="5" color="blue">请输入查询信息</font></td></tr>
<form method="post" action="findhistory2.asp">
<tr>
<td align="right">项目:</td>
<td><select name="xm">
<option>学号</option>
<option>科目</option>
<option>总分</option></select></td>
<td align="right">符号:</td>
<td><select name="fh">
<option>=</option>
<option>></option>
<option><</option>
</select></td>
<td align="right">值:</td><td><input type="text" name="z" maxlength="20" size="20"></td></tr>
<tr>
<td align="right" colspan="4">方式:</td>
<td><select name="ff">
<option>and</option>
<option>or</option>
</select></td>
</tr>
<tr>
<td align="right">条件:</td>
<td colspan="5"><input type="text" name="tj" size="60" value="<%=""&tj&""%>" readonly=""></td>
</tr>
<tr>
<input type="hidden" name="cx" value="<%=""&cx&""%>">
<td align="center" colspan="5"><input name="input" type="submit" value="添加"></td>
<td align="center"><input name="input" type="reset"></td>
</tr>
</form>
<tr>
<form method="post" action="findhistory3.asp">
<input type="hidden" name="cx" value="<%=""&cx&""%>">
<td align="center" colspan="6"><input name="input" type="submit" value="查询"></td>
</form>
</tr>
</table>
<%end if%>
</center>
</body>
</html>
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<title>学生历史查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<link rel="stylesheet" href="2cc.css" type="text/css">
</head>
<body background="MTVTD.GIF">
<div id="Layer1" style="position:absolute; left:1px; top:1px; width:448px; height:48px; z-index:1"><img src="TB.GIF" width="850" height="99"></div>
<center>
<p> </p>
<p> </p>
<p> </p>
</center>
<center>
<font size="7" color="blue">学生历史查询</font><br>
<%
if request.servervariables("REQUEST_METHOD")="POST" then
xx=request("cx")
if xx="" then
response.redirect"findhistory1.asp"
end if
cx="select * from history where "+request("cx")
set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=student;UID=aspbook;PWD=aspbook"
set yf=Server.CreateObject("ADODB.Recordset")
yf.open cx,conn
if yf.eof then
%>
<font size="7" color="red">警告:没有此学生历史。<br>
不能查询。</font>
<%else%>
<table border="1">
<tr>
<td align="center">学号</td>
<td align="center">科目</td>
<td align="center">试题总数</td>
<td align="center">完全正确</td>
<td align="center">非完全正确</td>
<td align="center">试卷满分</td>
<td align="center">最终得分</td>
</tr>
<%while not yf.eof%>
<tr>
<%for i=0 to yf.fields.count-1%>
<td align="center"><%=yf(i)%></td>
<%next%>
</tr>
<%
yf.movenext
wend
%>
</table>
<%
end if
end if
%>
</center>
</body>
</html>
不好意思。。代码有点长。。我确实看不懂了。。请高手。。帮我讲讲。。写写注释。谢谢了。。