日期:2014-05-16 浏览次数:21344 次
<!--#include file="CONN.ASP"-->
<%
if request("action")="edit" then
set rs=server.createobject("adodb.recordset")
sql="select * from bmxt"
rs.open sql,conn,3,2
rs("T7")=trim(request.form("T7"))
rs("T13")=trim(request.form("T13"))
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('提交成功!');location.href('Bmxt_admin_modi_jiangcheng.asp');</script>"
end if
%>
<html>
<body>
<form name="form" method="post" action="?action=edit" onSubmit="return check(this)">
<table width="1000" border="1" bordercolordark="#ffffff" bordercolorlight="#993300" align="center" cellpadding="2" cellspacing="1" class="border">
<tr align="center">
<td >序号</td><td >班级</td><td>学号</b></td><td>姓名</td><td>本人手机</td><td>政治面貌</td>
</tr>
<%
set rs=server.CreateObject("ADODB.Recordset")
sql ="select * from bmxt order by id "
rs.open sql,conn,1,3
do while not rs.eof '循环显示出数据
%>
<tr align="center">
<td><%=rs("id")%></td><!--性别 -->
<td><%=rs("T2")%></td><!--班级 -->
<td><%=rs("t3")%></td><!--学号 -->
<td><%=rs("t4")%></td><!--姓名 -->
<td><input type="title" name="T7" value="<%=rs("T7")%>"></td><!--本人手机 -->
<td><input type="title" name="T13" value="<%=rs("T13")%>"></td><!--政治面貌 -->
</tr>
<%
rs.movenext
loop
%>
</table>
<table align="center"><tr><td align="center"><input type="submit" value="修改资料!" name="submit"></td></tr></table>
</form>
</body>
</html>