show.asp

寝室管理文档 网站目的： 为了更好的管理寝室同学们的信息资料

<!--#include file="conn.asp"-->
<!--#include file="exit.asp"-->
<%
exec="select * from xuesheng order by id"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<table width="628" height="24" border="1" align="center" cellpadding="1" cellspacing="0">
<tr>
<td width="66" height="22" bgcolor="#FFFF00"><span style="font-weight: bold">序号</span></td>
<td width="66" bgcolor="#FFFF00"><span style="font-weight: bold">学号</span></td>
<td width="66" bgcolor="#FFFF00"><span style="font-weight: bold">姓名</span></td>
<td width="273" bgcolor="#FFFF00"><span style="font-weight: bold">专业</span></td>
<center><td colspan="3" bgcolor="#FFFFFF"><span style="font-weight: bold">操作</span></td>
</center>
</tr>
<%
if rs.eof and rs.bof then
response.write "暂时无信息，请<a href='add.asp'>添加</a>"
response.write "||<a href='login.asp'>返回</a>"
response.write "||<a href='change.asp'>修改个人资料</a>"
else
response.write "<a href='login.asp'>返回</a>"
response.write "||<a href='change.asp'>修改个人资料</a><br><br>"
do while not rs.eof
%>
<tr>
<td width="66" height="22" bgcolor="#00FF00" ><%=rs("id")%></td>
<td width="66" bgcolor="#00FF00" ><%=rs("xuehao")%></td>
<td width="66" bgcolor="#00FF00" ><%=rs("xingming")%></td>
<td width="273" bgcolor="#00FF00" ><%=rs("zhuanye")%></td>
<td width="58" bgcolor="#00FFFF"><a href="add.asp">添加</a></td>
<td width="58" bgcolor="#00FFFF"><a href="modify.asp?id=<%=rs("id")%>" target="_self">编辑</a></td>
<td width="58" bgcolor="#00FFFF" >
<a href="del.asp?id=<%=rs("id")%>" onclick="delyn()">删除</a></td>
</tr>
<%
rs.movenext
loop
end if
%>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<script language="javascript">
<!--
function delyn(){
yn=window.confirm("你确实要塞除数据吗？");
if(yn)
   return ture;
else
   return false;
}
//-->
</script>