📄 nbook.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=top.asp-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="700" height="772" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="186" height="30" valign="top"><img src="pic/n1_gonggao.jpg" width="182" height="30"></td>
<td width="10" rowspan="8"> </td>
<td width="504" rowspan="8" valign="top" bgcolor="#fcfcf5">
<%
set rs=server.createobject("adodb.recordset")
sql="select * from books where sort_id="&request("n")
rs.open sql,conn,3,3
response.write "<table border=0>"
while Not rs.eof
response.write "<tr>"
response.write "<td rowspan=4>"
response.write "<img src="&rs("bk_pic")&" width=80 height=100>"
response.write "</td>"
response.write "<td>"
response.write "<a href=book1.asp?n="&rs("bk_name")&">"
response.write rs("bk_name")
response.write "</a>"
response.write "</td></tr>"
response.write "<tr><td>"
response.write rs("bk_author")
response.write "</td></tr>"
response.write "<tr><td>"
response.write rs("bk_jg")
response.write "</td></tr>"
response.write "<tr><td>"
response.write rs("bk_vjg")
response.write "</td></tr>"
rs.movenext
wend
response.write "</table>"
rs.close
set rs=nothing
%>
</td>
</tr>
<tr>
<td height="116" valign="top"> <table width="183" height="118" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td width="181" height="116" bgcolor="#fcfcf5">
<%
set rs1=server.createobject("adodb.recordset")
sql="select * from pub"
rs1.open sql,conn,3,3
response.write "<table border=0>"
while Not rs1.eof
response.write "<tr>"
response.write "<td>"
response.write rs1("pub_title")
response.write "</td>"
response.write "</tr>"
rs1.movenext
wend
response.write "</table>"
rs1.close
set rs1=nothing
%>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="25"><img src="pic/n1_login.jpg" width="182" height="25"></td>
</tr>
<tr>
<td height="76"> <table width="183" height="251" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td height="249" valign="top" bgcolor="#fcfcf5">
<% if session("user_name")="" then %>
<table width="181" height="67" border=0>
<form method="post" action="check.asp">
<tr>
<td width="66" ><div>用户名:</div></td>
<td width="105" ><div>
<input type="text" name=name size=12>
</div></td>
</tr>
<tr>
<div>
<td><p>密 码:</td>
甀 </div>
<td><div>
<input type="password" name=passwd size=12>
</div></td>
</tr>
<tr>
<td height="23"> <div>
<input name="submit" type="submit" value="登陆">
</div></td>
<td> <div><a href="reg.asp">注册</a></div></td>
</tr>
</form>
</table>
<% else %>
<p>
<table border=0>
<%
set rs2=server.createobject("adodb.recordset")
sql="select * from ps where name='"&session("user_name")&"'"
rs2.open sql,conn,3,3
%>
<tr>
<td width="56" bgcolor="#fcfcf5">用户名:</td>
<td width="118"><%=rs2("name")%></td>
</tr>
<tr>
<td bgcolor="#fcfcf5">地址:</td>
<td bgcolor="#fcfcf5"><%=rs2("address")%></td>
</tr>
<tr>
<td>电话:</td>
<td><%=rs2("tel")%></td>
</tr>
<tr>
<td height="20">E_mail:</td>
<td><%=rs2("e-mail")%></td>
</tr>
<tr>
<td>
<% if flag=0 then %>
<a href="quit.asp"><font size=2>退出</font></a>
<% end if %>
</td>
</tr>
<% rs2.close
set rs2=nothing %>
</table>
<p></p>
<% end if %>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="29"><img src="pic/n1_sousuo.jpg" width="182" height="25"></td>
</tr>
<tr>
<td height="69"> <table width="186" height="55" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td width="184" bgcolor="#Fcfcf5"><table width="184" border=0 cellspacing="1">
<form method="post" action="search1.asp?f=select&n=fdname">
<tr> 甀
<td width="58" bgcolor="#fcfcf5"><div>方式:</div></td>
<td width="119" bgcolor="#fcfcf5"> <div>
<select name="select">
<option selected>书名</option>
<option>作者</option>
</select>
</div></td>
</tr>
<tr>
<td bgcolor="#fcfcf5"> <div>关键字:</div></td>
<td bgcolor="#fcfcf5"> <div>
<input type="text" name=fdname size=12>
</div></td>
</tr>
<tr>
<td height="23" bgcolor="#fcfcf5"> </td>
<td bgcolor="#fcfcf5">
<input name="submit2" type="submit" value="搜索"></td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="24"><img src="pic/n1_paihang.jpg" width="182" height="25"></td>
</tr>
<tr>
<td height="165" valign="top"> <table width="186" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td width="184" height="163" valign="top" bgcolor="#fcfcf5">
<%
set rs3=server.createobject("adodb.recordset")
sql="select top 15 * from books order by bk_buy DESC"
rs3.open sql,conn,3,3
%>
<table border=0>
<% if Not rs3.eof then %>
<tr>
<td width="130"> <font size=2><a href="book1.asp?n=<%=rs3("bk_name")%>"><%=rs3("bk_name")%></a></font>
</td>
<td width="42"><%=rs3("bk_buy")%></td>
</tr>
<%
rs3.movenext
end if
%>
</table>
<p>
<%
rs3.close
set rs3=nothing
%>
</p></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<!--#include file=copy.asp-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -