📄 modify2.asp
字号:
<!--#include file="conn.asp"-->
<% if session("user")="" then
response.write"<script>alert('对不起，您还没有登陆，如果您已经注册，请先登陆!');history.back(-1);</script>"
response.End()
end if %>
<html>
<head>
<title>高中学生成绩在线管理系统ASP1.0版---制作：冷剑无情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#CCCCCC" text="#000000">
<table width="635" border="5" cellspacing="2" cellpadding="4" align="center" bordercolor="#FFFFFF">
<tr>
<td height="371">
<table width="597" border="0" cellspacing="0" cellpadding="0" height="362" align="center">
<tr>
<td height="71">
<div align="center"><b><font size="6" face="楷体_GB2312"><br>
高中学生成绩在线管理系统</font></b></div>
</td>
</tr>
<tr>
<td height="23">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2">The
Management System Of High School Students Date</font></div>
</td>
</tr>
<tr>
<td height="241" valign="top">
<br>
<table width="500" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="center"><font color="#FF0000"><b>(请在各学科相应的文本框中修改成绩数据)</b></font></div>
</td>
</tr>
</table>
<form name="form2" method="post" action="modifyok.asp?grade=<%=request.querystring("grade")%>&class=<%=request.querystring("class")%>">
<table width="613" border="0" cellspacing="0" cellpadding="0" height="18" align="center">
<tr>
<td width="85" height="14">
<div align="left"><font size="2"> 学号</font></div>
</td>
<td width="65" height="14">
<div align="left"><font size="2">姓名</font></div>
</td>
<td width="51" height="14">
<div align="center"><font size="2">语文</font></div>
</td>
<td width="57" height="14">
<div align="center"><font size="2">数学</font></div>
</td>
<td width="46" height="14">
<div align="center"><font size="2">英语</font></div>
</td>
<td width="53" height="14">
<div align="center"><font size="2">物理</font></div>
</td>
<td width="52" height="14">
<div align="center"><font size="2">化学</font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2">生物</font></div>
</td>
<td width="50" height="14">
<div align="center"><font size="2">政治</font></div>
</td>
<td width="46" height="14">
<div align="center"><font size="2">历史</font></div>
</td>
<td width="58" height="14">
<div align="center"><font size="2">地理</font></div>
</td>
</tr>
</table>
<% for i=1 to request.form("checkbox").count
dim rs
dim sql
set rs=server.createobject("adodb.recordset")
sql="select*from scores where id="&trim(Request("checkbox")(i))&""
rs.open sql,conn,1,3
%>
<table width="613" border="0" cellspacing="0" cellpadding="0" height="8" align="center">
<tr>
<td width="77" height="6">
<div align="left"><font size="2">
<input type="text" name="testnumber<%=i%>" size="11" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("testnumber")%>">
</font></div>
</td>
<td width="70" height="6">
<div align="left"><font size="2">
<input type="text" name="name<%=i%>" size="8" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("name")%>">
</font></div>
</td>
<td width="50" height="6">
<div align="center"><font size="2">
<input type="text" name="language<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("language")%>">
</font></div>
</td>
<td width="56" height="6">
<div align="center"><font size="2">
<input type="text" name="mathe<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("mathe")%>">
</font></div>
</td>
<td width="45" height="6">
<div align="center"><font size="2">
<input type="text" name="english<%=i%>" size="6"style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("english")%>" >
</font></div>
</td>
<td width="52" height="6">
<div align="center"><font size="2">
<input type="text" name="physics<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("physics")%>">
</font></div>
</td>
<td width="51" height="6">
<div align="center"><font size="2">
<input type="text" name="chemical<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("chemical")%>">
</font></div>
</td>
<td width="49" height="6">
<div align="center"><font size="2">
<input type="text" name="biological<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("biological")%>">
</font></div>
</td>
<td width="49" height="6">
<div align="center"><font size="2">
<input type="text" name="politics<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("politics")%>">
</font></div>
</td>
<td width="45" height="6">
<div align="center"><font size="2">
<input type="text" name="history<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("history")%>">
</font></div>
</td>
<td width="53" height="6">
<div align="center"><font size="2">
<input type="text" name="geography<%=i%>" size="6" style="border: 1pt solid #EEEEEE;background-color:transparent" value="<%=rs("geography")%>">
</font></div>
</td>
</tr>
</table>
<input type="hidden" name="id<%=i%>" value="<%=rs("id")%>">
<%
rs.close
next
%>
<input type="hidden" name="num" value="<%=request.form("checkbox").count%>">
<input type="hidden" name="grade" value="<%=request.querystring("grade")%>">
<input type="hidden" name="class" value="<%=request.querystring("class")%>">
<div align="center"><br>
<input type="submit" name="Submit2" value=" 保存数据 " style="border: 1pt solid #EEEEEE">
<input type="reset" name="Submit3" value=" 重新输入 " style="border: 1pt solid #EEEEEE">
<br>
</div>
</form>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<div align="center"><font size="2" color="#000000" face="Arial, Helvetica, sans-serif">Copyright©
问剑网ASP小组 All right Reserved QQ:349643649</font><font size="2" color="#000000">
</font></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -