?? admin.asp
字號(hào):
<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>對(duì)不起,暫時(shí)還沒有人報(bào)名!</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>
<title>靈感網(wǎng)絡(luò)考試網(wǎng)報(bào)名信息查詢管理系統(tǒng)</title>
<base target="footnotes">
</HEAD>
<BODY>
<center><b><font size="4">靈感網(wǎng)絡(luò)招生考試網(wǎng)報(bào)名信息查詢管理系統(tǒng)</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>學(xué)歷:</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>特長(zhǎng):</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>有何獎(jiǎng)項(xiàng):</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>畢業(yè)學(xué)校:</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>身份證號(hào)碼:</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>聯(lián)系電話:</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>
<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>專業(yè)一:</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>專業(yè)二:</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>高考成績(jī):</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">數(shù)學(xué)</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">化學(xué)</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>或會(huì)考成績(jī)</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>
報(bào)名表填寫時(shí)間:<%=rs("time")%> 所報(bào)學(xué)校:<%=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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -