📄 propose.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/conn.asp" -->
<%
set rs_propose=Server.CreateObject("ADODB.RecordSet")
sql="SELECT * FROM DB_bookinfo WHERE memo = '特别推荐' ORDER BY BookName DESC"
rs_propose.open sql,conn,3,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>重点推荐</title>
<link href="style.css" rel="stylesheet">
</head>
<body leftmargin="0" topmargin="0">
<table width="535" height="317" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td width="535" height="194" align="center" valign="top" background="images/bg_listmain.jpg">
<table width="97%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td height="18"> </td>
</tr>
<tr>
<td height="30"><img src="images/propose.gif" width="210" height="30"></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="center">
<table width="97%" height="128" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td>
<%
'分页'
rs_propose.pagesize=2
page=CLng(Request("page"))
if page<1 then page=1
rs_propose.absolutepage=page
for i=1 to rs_propose.pagesize %>
<table width="100%" height="118" border="0" cellpadding="-2" cellspacing="-2">
<tr>
<td colspan="2"><img src="images/light.gif" width="11" height="13"><strong>
<%=rs_propose("BookName")%></strong></td>
<td width="28%" rowspan="5"> <div align="center" color="#C60001">
<%mypath="images/cover/"&rs_propose("cover")%>
<img src="<%=mypath%>" width="105" height="150" border="1">
</div></td>
</tr>
<tr>
<td width="36%"><font color="#C60001"> 书号：
<%=rs_propose("BookID")%></font></td>
<td width="36%"><font color="#C60001"> 作者：
<%=rs_propose("Writer")%></font></td>
</tr>
<tr>
<td colspan="2"><font color="#C60001"> 出版社：
<%=rs_propose("TPI")%></font></td>
</tr>
<tr>
<td><font color="#C60001"> 单价：
<%=rs_propose("Price")%>（元）</font></td>
<td><font color="#C60001"> 出版日期：
<%=rs_propose("pDate")%></font></td>
</tr>
<tr>
<td colspan="2"><font color="#C60001"> 简介：<br>
<%=rs_propose("Introduce")%></font></td>
</tr>
<tr>
<td colspan="3">------------------------------------------------------------
<img src="images/add.gif" width="18" height="18" align="absbottom">
<a href="buycar_add.asp?bookID=<%= rs_propose("bookID")%>"
target="_blank">添加至购物车</a>
</td>
</tr>
</table>
<%
rs_propose.movenext
if rs_propose.eof then exit for
next %>
</td>
</tr>
<tr>
<td>
<% if page<>1 then %><a href=<%=path%>?page=1>第一页</a>
<a href=<%=path%>?page=<%=(page-1)%>>上一页</a>
<%end if
if page<>rs_propose.pagecount then %>
<a href=<%=path%>?page=<%=(page+1)%>>下一页</a>
<a href=<%=path%>?page=<%=rs_propose.pagecount%>>最后一页</a>
<%end if %>
<tr>
</table>
<div align="center"></div></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<%
rs_propose.Close()
Set rs_propose = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -