📄 student.asp

📁 在线考试系统

💻 ASP

字号:

<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!---#include file="conn.asp"--->
<link href="main.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body bgcolor="#97D9FD" leftmargin="0" topmargin="0" rightmargin="0" bottommargin="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bordercolorlight="#000000" bordercolordark="#ffffff">
  <tr > 
    <td  height="40" align="center" valign="middle" >
<h3 align="center">学生管理 </h3>
      
    </td>
  </tr>
  <tr>
    <td height="40" align="center"> &nbsp;
      <a href="studentadd.asp">添加新学生</a>
      <hr width="100%"></td>
  </tr>
  <tr> 
    <td valign="top">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
        <tr align="center" > 
          <th >学号</th>
          <th >姓名</th>
          <th >性别</th>
          <th >出生日期</th>
          <th colspan="2">操作</th>
        </tr>
        <%
  set rst=conn.execute("select * from Student")
  while not rst.eof
  %>
        <tr align="center" bgcolor="#E0F1FC"> 
          <td><%=rst("StuId")%></td>
          <td bgcolor="#E0F1FC"><%=rst("Name")%></td>
          <td><%=rst("Sex")%></td>
          <td bgcolor="#E0F1FC"><%=rst("Birthday")%></td>
          <td ><a href="StudentModify.asp?id=<%=rst("StuId")%>">修改</a></td>
          <td ><a href="StudentUpdate.asp?oper=del&id=<%=rst("StuId")%>" onclick="return confirm('确定要删除吗？');">删除</a></td>
        </tr>
        <%
  rst.movenext
  wend
    rst.close()
  conn.close()
  set rst=nothing
  set conn=nothing
  %>
      </table></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -