📄 booklist.asp
字号:
<!--#include file="ConnDB.asp"-->
<!--#include file="isAdmin.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书信息管理</title>
<link href="style.css" rel="stylesheet">
<script language="javascript">
function newwin(url) {
var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
oth = oth+",width=500,height=400";
var newwin=window.open(url,"newwin",oth);
newwin.focus();
return false;
}
function SelectChk()
{
var s=false;
var booksid,n=0;
var strid,strurl;
var nn = self.document.all.item("books")
for (j=0;j<nn.length;j++)
{
if (self.document.all.item("books",j).checked)
{
n = n + 1;
s=true;
booksid = self.document.all.item("books",j).id+"";
if(n==1)
{
strid = booksid;
}
else
{
strid = strid + "," + booksid;
}
}
}
strurl = "BookDelt.asp?book_id=" + strid;
if(!s) {
alert("请选择要删除的商品!");
return false;
}
if ( confirm("你确定要删除这些商品吗？")) {
form1.action = strurl;
form1.submit();
}
}
function sltAll()
{
var nn = self.document.all.item("books");
for(j=0;j<nn.length;j++)
{
self.document.all.item("books",j).checked = true;
}
}
function sltNull()
{
var nn = self.document.all.item("books");
for(j=0;j<nn.length;j++)
{
self.document.all.item("books",j).checked = false;
}
}
</script>
</head>
<!--#include file="head.asp"-->
<body link="#000080" vlink="#080080">
<form id="form1" name="form1" method="POST">
<p align="center"><b><font style="font-size: 12pt">图 书 信 息 管 理</font></b></font></p><BR>
<table width=670 border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<%
'读取当前商品类别编号
typeid = CLng(Request("type_id"))
If typeid < 0 Then
typeid = 0
End If
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet")
'读取图书类别
sql = "SELECT * FROM Book_Type ORDER BY Type_Id"
rs.Open sql,Conn,1,1
If rs.EOF Then
Response.Write("没有图书类别")
Else
Do While Not rs.EOF
If rs("type_id") = typeid Then
Response.Write(rs("Type_name"))
Else
Response.Write("<a href='BookList.asp?type_id=" & Trim(rs("type_id")) & "'>" & Trim(rs("Type_name")) & "</a>")
End If
Response.Write(" | ")
rs.MoveNext
Loop
End If
%>
</tr></table>
<table align=center border="1" cellspacing="0" width="68%" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF" style='FONT-SIZE: 9pt'>
<tr>
<td width="11%" height="27" align="center" bgcolor="#FEEC85"><strong>编号</strong></td>
<td width="26%" align="center" bgcolor="#FEEC85"><strong>名称</strong></td>
<td width="20%" align="center" bgcolor="#FEEC85"><strong>出版社</strong></td>
<td width="16%" align="center" bgcolor="#FEEC85"><strong>上架日期</strong></td>
<td width="14%" align="center" bgcolor="#FEEC85"><strong>修改</strong></td>
<td width="13%" align="center" bgcolor="#FEEC85"><strong>选择</strong></td>
</tr>
<%
rs.Close
'设置SQL语句，读取当前指定图书类别中的所有图书列表
If typeid=0 Then
sql = "SELECT * FROM Book_Info ORDER BY Book_AddDate"
Else
sql = "SELECT * FROM Book_Info WHERE book_type= " & Trim(typeid) & " ORDER BY Book_AddDate"
End If
rs.Open sql,Conn,1,1
If rs.EOF Then
Response.Write "<tr><td colspan=8 align=center>目前还没有图书。</td></tr></table>"
Else
'设置每页显示记录的数量
rs.PageSize = 8
'读取参数page，表示当前页码
iPage = CLng(Request("page"))
If iPage > rs.PageCount Then
iPage = rs.PageCount
End If
If iPage <= 0 Then
iPage = 1
End If
rs.AbsolutePage = iPage
For i=1 To rs.PageSize
n = n + 1
%>
<tr><td height="27" align="center"><%=n%></td>
<td><a href="BookView.asp?book_id=<%=rs("BOOK_id")%>" onClick="return newwin(this.href)"><%=rs("BOOK_Name")%></a></td>
<td align="center"><%=rs("book_Press")%></td>
<td align="center"><%=rs("book_AddDate")%></td>
<td align="center"><a href="bookEdit.asp?book_id=<%=rs("book_id")%>" onClick="return newwin(this.href)">修改</a></td>
<td align="center"><input type="checkbox" name="books" id="<%=rs("book_id")%>" style="font-size: 9pt"></td></tr>
<%
rs.MoveNext()
If rs.EOF Then
Exit For
End If
Next
%>
</table>
<p align="center">
<%
'显示页码
If rs.PageCount>1 Then
Response.Write "<table border='0'>"
Response.Write "<tr>"
Response.Write "<td><b>分页：</b></td>"
For i=1 To rs.PageCount
Response.Write "<td><a href='bookList.asp?type_id=" & Trim(typeid) & "&page=" & i & "'>"
Response.Write "[<b>" & i & "</b>]</a></td>"
Next
Response.Write "</tr></table>"
End If
End If
%>
<p align="center">
<input type="button" value="添加图书" onClick="newwin('bookAdd.asp')" name=add>
<input type="button" value="全 选" onClick="sltAll()" name=button1>
<input type="button" value="清 空" onClick="sltNull()" name=button2>
<input type="submit" value="删 除" name="tijiao" onClick="SelectChk()">
<br><br>
<input type=hidden name=books">
</form>
<tr>
<td><div align="center">Copyright 2007 </div></td>
</tr>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -