bookview.asp

来自「ASP+SQL Server的图书馆管理系统」· ASP 代码 · 共 117 行

ASP
117
字号
<!--#include File="ConnDB.asp"-->
<html>
<head>
<title>查看图书信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=style.css rel=STYLESHEET type=text/css>
</head>
<Script language="javascript">
function newOrder(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=150";
  var newOrder=window.open(url,"newOrder",oth);
  newOrder.focus();
  return false;
}

function OpenBask(Book_id){
  var url;
  url = "BookIn.asp?book_id=" + Book_Id;
  newOrder(url);
}
</Script>

<body>
<%
  set rs=server.createobject("adodb.recordset")  
  Dim id,iname
  id = Request.QueryString("Book_Id")
  sql = "Select * From Book_Info Where Book_id=" & Cint(id)
  Set rsBook_Info = conn.Execute(sql)
  If rsBook_Info.Eof Then
    Response.Write "没有此图书信息"
    Response.End
  Else
    iname = rsBook_Info("Book_ImageFile")
    conn.Execute(sql)

%>
     <form method="POST"  name="form1">
     <table border="1" width="100%" cellspacing="1" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
          <tr> 
            <td width="70%"><font color=blue>图书类别</font>
<%
  sql = "SELECT * FROM Book_Type WHERE type_id=" & rsBook_Info("book_type")
  rs.Open sql,conn,3,3
  If rs.EOF Then
%>  没有类别信息
<%
  Else
    Response.Write(rs("type_name"))
  End If
  rs.Close
%>
              </select>
            </td>
            <td width="30%" rowspan="4" align=center><% If IsNull(iname) Or iname = "" Then%>
            <img src="images\noImg.jpg" width="120" border=0>
   			<%Else%><img src="images\<%=rsBook_Info("Book_ImageFile")%>" width="90" border=0>
        	<%End If%></td>
				</tr>
          <tr> 
            <td><font color=blue>图书名称</font>
            <%=rsBook_Info("Book_Name")%></td>
          </tr>
          <tr> 
            <td><font color=blue>作者</font>
            <%=rsBook_Info("BOOK_Author")%></td>
          </tr>
          <tr> 
            <td><font color=blue>出版社</font>
            <%=rsBook_Info("Book_Press")%></td>
          </tr>
          <tr> 
            <td colspan="2"><font color=blue>出版日期</font>
            <%=rsBook_Info("Book_PrsDate")%></td>
          </tr>
		  <tr> 
            <td colspan="2"><font color=blue>上架日期</font>
            <%=rsBook_Info("Book_AddDate")%></td>
          </tr>
		  <tr> 
            <td colspan="2"><font color=blue>图书数量</font>
            <%=rsBook_Info("Book_Total")%></td>
          </tr>
		  <tr> 
            <td colspan="2"><font color=blue>是否在库</font>
            <%=rsBook_Info("Book_Entitle")%></td>
          </tr>
          <tr> 
            <td colspan="2"><font color=blue>图书简介</font>
            </td>
          </tr>
          <tr> 
            <td colspan="2"><%=rsBook_Info("Book_Remark")%></td>
          </tr>
        </table>
        <p align="center"><center>
        <a href="javascript:window.close();">[关闭]</a></center></p>
      </form>
<%End If%>      
</body>















⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?