📄 admin.asp
字号:
<link rel="stylesheet" type="text/css" href="bao.css">
<%
page=Request.QueryString("page")
if len(page)>0 and isnumeric(page) then
page=int(page)
else
page=1
end if
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From baoming Order By time DESC", conn, 3
rs.PageSize=10
size=rs.PageSize
rsnum=rs.RecordCount
IF rsnum=0 then
response.write "<center>对不起，暂时还没有人报名!</center>"%>
<%
Response.end
end if
total=int(rsnum/size)
if (rsnum mod size)>0 then
total=total+1
end if
if page<1 or page>total then
page=1
end if
%>
<%if page=1 then
rs.AbsolutePosition=1
end if
if page>1 then
rs.AbsolutePosition=(page-1)*10
end if
%>
<%b=1%>
<HTML>
<HEAD>
<title>灵感网络考试网报名信息查询管理系统</title>
<base target="footnotes">
</HEAD>
<BODY>
<center><b><font size="4">灵感网络招生考试网报名信息查询管理系统</font></b></center><br>
<%for i=1 to 10%>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" style="border-left:3px solid #800000; border-right:3px solid #800000; border-collapse: collapse" bordercolor="#800000" width="79%" id="AutoNumber1" height="1">
<tr>
<td width="15%" height="25" style="border-left: 3px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p> <b>姓名:</b></td>
<td width="13%" height="25"><p align="center"><%=rs("name")%></td>
<td width="15%" height="25">
<p align="center"><b>年龄:</b></td>
<td width="7%" height="25"><p align="center"><%=rs("age")%></td>
<td width="15%" height="25">
<p align="center"><b>性别:</b></td>
<td width="5%" height="25">
<p align="center"><%=rs("sex")%></td>
<td width="14%" height="25">
<p align="center"><b>出生日期:</b></td>
<td width="37%" height="25">
<p align="center"><%=rs("date1")%></td>
</tr>
<tr>
<td width="12%" height="25" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p> <b>民族:</b></td>
<td width="13%" height="25">
<p align="center">
<%=rs("minzu")%></td>
<td width="15%" height="25">
<p align="center"><b>学历:</b></td>
<td width="60%" height="25" colspan="5">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="101%" id="AutoNumber2" height="31">
<tr>
<td width="17%" height="31" style="border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bordercolor="#800000">
<%=rs("xl")%></td>
<td width="22%" height="31" style="border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bordercolor="#800000">
<b>特长:</b></td>
<td width="62%" height="31" style="border-left-width: 1; border-top-width: 1; border-bottom-width: 1">
<%=rs("tc")%></td>
<td width="100%" height="31" style="border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1">
</td>
<td width="100%" height="31" style="border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1">
<p align="center"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="12%" height="25" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>有何奖项:</b></td>
<td width="56%" height="25" colspan="5"><p align="center"><%=rs("jx")%></td>
<td width="15%" height="25">
<p align="center"><b>籍贯:</b></td>
<td width="17%" height="25"><p align="center"><%=rs("jg")%></td>
</tr>
<tr>
<td width="12%" height="25" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>政治面貌:</b></td>
<td width="13%" height="25">
<p align="left"><p align="center"><%=rs("zzmm")%></td>
<td width="75%" height="25" colspan="6">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3" height="30">
<tr>
<td width="27%" height="30" style="border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bordercolor="#800000">
<p align="center"><b>毕业学校:</b></td>
<td width="73%" height="30"><p align="center"><%=rs("byschool")%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="12%" height="25" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>家庭住址:</b></td>
<td width="35%" height="25" colspan="3"><p align="center"><%=rs("address")%></td>
<td width="15%" height="25">
<p align="center"><b>身份证号码:</b></td>
<td width="38%" height="25" colspan="3"><p align="center"><%=rs("number")%></td>
</tr>
<tr>
<td width="12%" height="26" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>联系电话:</b></td>
<td width="28%" height="26" colspan="2"><p align="center"><%=rs("phone")%></td>
<td width="60%" height="26" colspan="5">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber4" height="28">
<tr>
<td width="30%" height="28" style="border-left-width: 1; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>邮政编码:</b></td>
<td width="70%" height="28"><p align="center"><%=rs("youbian")%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="12%" height="26" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>系别:</b></td>
<td width="88%" height="26" colspan="7">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5" height="30">
<tr>
<td width="17%" height="30" style="border-left-width: 1; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1"><p align="center"><%=rs("xb")%></td>
<td width="16%" height="30" style="border-left-width: 1; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>专业一:</b></td>
<td width="25%" height="30" style="border-left-width: 1; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("zy1")%></td>
<td width="16%" height="30" style="border-left-width: 1; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>专业二:</b></td>
<td width="26%" height="30"><p align="center"><%=rs("zy2")%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="12%" height="26" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><b>高考成绩:</b></td>
<td width="88%" height="26" colspan="7">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber6" height="33">
<tr>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center">语文</td>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center">数学</td>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center">英语</td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">物理</td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">化学</td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">生物</td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">政治</td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">历史</td>
<td width="12%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center">地理</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="12%" height="26" style="border-left-style: solid; border-left-width: 3; border-top-width: 1; border-bottom-width: 1">
<p align="center"><font color="#800000"><b>或会考成绩</b></font></td>
<td width="88%" height="26" colspan="7">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber6" height="33">
<tr>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center"><%=rs("chinese")%></td>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center"><%=rs("shuxue")%></td>
<td width="11%" height="33" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-top-width: 1; border-bottom-width: 1" bgcolor="#FFFFFF" bordercolor="#800000">
<p align="center"><%=rs("english")%></td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("wuli")%></td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("huaxue")%></td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("shenwu")%></td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("zhengzhi")%></td>
<td width="11%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("lishi")%></td>
<td width="12%" height="33" bgcolor="#FFFFFF" bordercolor="#800000" style="border-left: 1px solid #800000; border-right: 1px solid #800000; border-top-width: 1; border-bottom-width: 1">
<p align="center"><%=rs("dili")%></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<form name="form<%=b%>" method="post" action="delete.asp?id=<%=b%>">
<p align="center">
<input type="submit" value="删除" name="B1"></center>
报名表填写时间:<%=rs("time")%> 所报学校:<%=rs("school")%></p>
</form>
</p>
<%
rs.Movenext
b=b+1
num=num+1
if rs.eof then
response.end
end if
next%>
<div align="center">
<%if page=1 then%>
上一页**<a href="admin.asp?page=<%=page+1%>">下一页</a>**第<%=page%>页/共<%=total%>页
<%end if%>
<%if page=total then%>
<a href="admin.asp?page=<%=page-1%>">上一页</a>**下一页**第<%=page%>页/共<%=total%>页
<%end if%>
<%if page>1 and page<total then%>
<a href="admin.asp?page=<%=page-1%>">上一页</a>**<a href="admin.asp?page=<%=page+1%>">下一页</a>**第<%=page%>页/共<%=total%>页
<%end if%>
</div>
<%rs.close%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -