?? show.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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" />
<style type="text/css">
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
body {
background-color: #E7EEF5;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.STYLE2 {
font-size: 16px;
font-family: "黑體";
color: #FFFFFF;
}
.tb2{
margin-top: 3px;
margin-right: 0px;
margin-bottom: 3px;
margin-left: 0px;
}
.style4 {font-size: 16px; font-family: "黑體"; color: #000000; }
-->
</style>
</head>
<!--#include file="conn.asp"-->
<%
id=trim(request("id"))
if id<>"" then
sql="select * from [book] where id="&Id
set rs=conn.execute(sql)
else
response.write"<script language='javascript'>alert('操作錯誤！');window.location.href='index.asp';</script>"
response.end
end if
%>
<body>
<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" align="center" cellpadding="0" cellspacing="1" bgcolor="#C5D5E4" class="tb2">
<tr>
<td height="38" valign="top"><table width="100%" border="0">
<tr></tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="94%" valign="top"><table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td height="30" align="center" valign="middle" background="img/T_bg.gif" class="title_bg"><span class="style4">詳細信息</span></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#0099CC">
<tr bgcolor="#FFFFFF">
<td width="22%" height="25" align="right" valign="middle"><strong>書名：</strong></td>
<td width="18%" height="25" align="left"><%=rs("b_name")%> </td>
<td width="20%" height="25" align="right" valign="middle"><strong>ISBN：</strong></td>
<td width="40%" height="25" align="left"><%=rs("b_isbn")%> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle"><strong>作者：</strong></td>
<td height="25" align="left"><%=rs("b_WRITER")%> </td>
<td height="25" align="right" valign="middle"><strong>出版社：</strong></td>
<td height="25" align="left"><%=rs("b_CONCERN")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle"><strong>出版日期：</strong></td>
<td height="25" align="left"><%=rs("b_DATE")%></td>
<td height="25" align="right" valign="middle"><strong>上架日期：</strong></td>
<td height="25" align="left"><%=rs("b_CHECK_DATE")%></td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="30" colspan="4"><p><strong>庫存數量：</strong><font color="#FF0000"><%=rs("b_num")%></font> <strong>外借數量：</strong><font color="#FF0000"><%n_wj=conn.execute("select count(*) as ct from jieyue where book_id="&id)("ct")
response.Write n_wj%></font> <strong>可借數量：</strong><font color="#FF0000"><%=(rs("b_num")-n_wj)%></font></p> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle"><strong>簡介：</strong></td>
<td height="50" colspan="3" align="left" valign="top"><%=rs("b_REMARK")%></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td height="30" colspan="4" valign="middle"><a href="#" onclick="history.back();"><font color="#FF0000">返回</font></a> <a href="javascript:window.close();"><font color="#FF0000">關閉窗口</font></a> <%if session("id")<>"" then%><a href="yd2.asp?id=<%=rs("id")%>" target="_self"><font color="#FF0000">預定該圖書</font></a>
<%end if%></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr></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 + -