www.gusucode.com > ASP+ACCESS学生成绩查询系统毕业设计(源代码+论文+开题报告) > ASP+ACCESS学生成绩查询系统毕业设计(源代码+论文+开题报告)\score\score\update.asp
<%if session("password")<>"" then%>
<!--#include file="conn1.asp"-->
<%
id=trim(Request("id"))
sqlcmd = ("select * from bbs1 where id="&id) '查询id(ID号)这条记录
rs.Open sqlcmd,newconn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生成绩管理系统-修改记录</title>
<style type="text/css">
<!--
@import url("20041026_25175_stry_css.css");
.style1 {font-size: 24px}
body {
background-image: url(image/bg.jpg);
background-color: #3399FF;
}
-->
</style>
</head>
<body>
<img src="image/1.gif" width="942" height="92">
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" bgcolor="#999999"><div align="center" class="unnamed3write">学生成绩管理系统</div></td>
</tr>
</table>
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="unnamed_rld2">
<tr bgcolor="#EEEEEE">
<td width="100" height="25" align="center"><a href="index.asp">首页</a></td>
<td width="100" align="center"><a href="add.asp">添加单个成绩</a></td>
<td width="100" align="center"><a href="adds.asp">批量添加成绩</a></td>
<td width="100" align="center" bgcolor="#EEEEEE"><a href="res.asp">按学号查询</a></td>
<td width="100" align="center"><a href="res1.asp">按班级查询</a></td>
<td width="100" align="center"><font color="#0000CC" size="2"><a href="admin.asp">管理页面</a></font></td>
<td width="100" align="center">退出</td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form method="POST" action="modi.asp">
<table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="57" height="25" align="center">班级</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="bj" size="25" maxlength="30" class="editbox1" value="<%=rs("bj")%>">
</td>
</tr>
<tr>
<td height="25" align="center">学号</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="xh" size="25" maxlength="30" class="editbox1" value="<%=rs("xh")%>"></td>
</tr>
<tr>
<td width="57" height="25" align="center">姓名</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="user" size="25" maxlength="40" class="editbox1" value="<%=rs("user")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">课程</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input type="text" name="kc" size="25" class="editbox1" value="<%=rs("kc")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">成绩</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input name="cj" size="25" maxlength="100" class="editbox1" value="<%=rs("cj")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">学期</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input type="xq" name="xq" size="25" class="editbox1"value="<%=rs("xq")%>">
</td>
</tr>
<tr>
<td width="57" height="25" align="center">类型</td>
<td width="16" height="25"> </td>
<td width="225" height="25">
<input type="lx" name="lx" size="25" class="editbox1" value="<%=rs("lx")%>">
</td>
</tr>
<tr>
<td height="25" colspan="3">
<div align="center">
<input class=bottom name=B12 type=submit value="修改记录">
<input class=bottom name=B22 type=reset value="重新添写">
<input type="hidden" name="id" value="<%=rs("id")%>">
</div></td>
</tr>
</table>
<p> </p>
</form>
</td>
</tr>
</table>
<p> </p>
<p> </p>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" bgcolor="#999999"><div align="center" class="unnamed3write"><a href="http://www.163.com" class="unnamed3write">powered by deng131 </a></div></td>
</tr>
</table>
</body>
</html>
<%else
Response.Redirect "admpost.asp"
end if%>