⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 update.asp

📁 .添加单个成绩 2.批量添加成绩 3.通过搜索并修改与删除 4.直接修改 5.可以批量删除 6.可以直接GO到达你想到达的页 7.分页显示 8.代码精简 9.整合部分重复代码 1
💻 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();
}
-->
</style>
</head>
<body>

<p>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" bgcolor="#999999"><div align="center" class="unnamed3write">25175学生成绩管理系统v1.51</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>&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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>
</form>
</td>
  </tr>
</table>
<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://by2005.w3.zcxp.net/" class="unnamed3write">陕西广播电视大学2004播音与主持艺术专业</a></div></td>
          </tr>
        </table>
</body>
</html>
<%else
Response.Redirect "admpost.asp"
end if%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -