?? yd.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="pass2.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>圖書館管理系統</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!--#include file="conn.asp"-->
<%
if request("act")="del" then
id=trim(request("id"))
if not isnumeric(id) or id="" then
response.write"<script language='javascript'>alert('參數錯誤！');window.location.href='yd.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="delete from [yuding] where id="&cstr(id)
rs.open sql,conn,1,3
response.write"<script language='javascript'>alert('刪除成功！');window.location.href='yd.asp';</script>"
end if
%>
<%
set rs=conn.execute("select * from [yuding] where user_id="&session("id"))%>
<form name="form1" method="post" action="">
<center>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="150"><!--#include file="top.asp"--></td>
</tr>
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tb">
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="180" align="left" valign="top"><!--#include file="left.asp"--></td>
<td align="center" valign="top"><table width="95%" border="0" cellpadding="2" cellspacing="1" bgcolor="#FCE6C7">
<tr>
<td width="9%" height="25" align="center" valign="middle" bgcolor="#FFFFFF"><strong>ID</strong></td>
<td width="21%" height="25" align="center" valign="middle" bgcolor="#FFFFFF"><strong>圖書名稱</strong></td>
<td width="22%" align="center" valign="middle" bgcolor="#FFFFFF"><strong>類別</strong></td>
<td width="24%" height="25" align="center" valign="middle" bgcolor="#FFFFFF"><strong>預定時間</strong></td>
<td width="11%" height="25" align="center" valign="middle" bgcolor="#FFFFFF"><strong>狀態</strong></td>
<td width="13%" height="25" align="center" valign="middle" bgcolor="#FFFFFF"><strong>刪除</strong></td>
</tr>
<%
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
set rs=server.createobject("adodb.recordset")
sql = "select * from [yuding] where user_id="&session("id")&" order by id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td height=20 colspan=6 align=center bgcolor=#FFFFFF>您還沒有預定信息！</td></tr>"
response.end
end if
rs.Pagesize=10
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
On Error Resume Next
rs.move (ThisPage-1)*Pagesize
k=0
do while not rs.eof
book_id=rs("book_id")
set rss=conn.execute("select * from [book] where id="&book_id)
%>
<tr>
<td height="23" align="center" bgcolor="#FFFFFF"><%=k+1%></td>
<td height="23" align="center" bgcolor="#FFFFFF"><%=rss("b_name")%></td>
<td align="center" bgcolor="#FFFFFF"><%st=rss("b_sort")
response.Write conn.execute("select * from lb where id="&st)("name")%></td>
<td height="23" align="center" bgcolor="#FFFFFF"><%=rs("time")%></td>
<td height="23" align="center" bgcolor="#FFFFFF"><%=rs("zt")%></td>
<td height="23" align="center" bgcolor="#FFFFFF"><a href="?act=del&id=<%=rs("id")%>" target="_self" class="l">刪除</a></td>
</tr>
<%
rs.movenext
k=k+1
if k>=Pagesize then exit do
loop
rs.close
set rs=nothing
conn.close()
%>
</table>
<table width="95%" border="0" cellpadding="2" cellspacing="0">
<tr>
<td height="20" colspan="8" align="center"> 共有 <font color="#CC5200"><%=Allrecord%></font> 條記錄 ,共 <font color="#CC5200"><%=Allpage%></font> 頁, 現在是第 <font color="#CC5200"><%=ThisPage%></font> 頁
<%
if ThisPage<2 then
response.write "<font color=""#808080"">首頁</font> "
response.write "<font color=""#808080"">上一頁</font> "
else
response.write "<a href=?page=1>首頁</a> "
response.write "<a href=?page="&ThisPage-1&">上一頁</a> "
end if
if Allpage-ThisPage<1 then
response.write "<font color=""#808080"">下一頁</font> "
response.write "<font color=""#808080"">尾頁</font> "
else
response.write "<a href=?page="&(ThisPage+1)&">下一頁</a> "
response.write "<a href=?page="&Allpage&">尾頁</a> "
end if
%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="60"><!--#include file="bottom.asp"--></td>
</tr>
</table>
</center>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -