return.asp

在线图书馆管理系统的具有前台后后台。前台用户系统主要功能是显示用户借阅信息及图书查找功能。后台管理员系统主要是负责前台信息的维护和图书书库的管理。本系统可以方便的使用户高效率地找到自己所需要的图书。另

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../inc/adconn.asp"-->
<!--#include file="../css.asp"-->
<% set rs=server.CreateObject("adodb.recordset") %>
<%
if session("admin_name")="" then 
response.end
end if%>
<% dim Title,Owner
if request("action")="return" then 
Title=Trim(Request("Title"))
Owner=Trim(Request("Owner"))
'sql="select * from book  where Title='"&Title&"' "
sql="select * from book where Title='"&Title&"' and Owner='"&Owner&"'"
rs.open sql,conn,1,3
if rs.eof then
     response.write "<script>alert('暂且没有借阅信息');location.href='return.asp'</script>"
      response.end
	  else
rs("Owner")=""
rs("Status")=0
rs("letime")=null
rs("Retime")=null
rs.update
	Response.Write "<script>alert('借阅归回成功!!');location.href='return.asp'</script>"
	Response.end 
	end if
end if
%>
	

<title>归还图书</title>

<p>&nbsp;</p>
<table width="100%" height="1" border="0" cellpadding="3"  cellspacing="1"  align="center">
  <tr>
    <td width="100%" class="title" bgcolor="#FFFFFF"><div align="center" style="font-weight: bold; font-family: Arial, Helvetica, sans-serif; font-size: 24px">借阅与归还管理</div></td>
  </tr>
    <tr>
      <td > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [<a href="rent.asp">图书借阅</a>]&nbsp;&nbsp;[<a href="return.asp">图书归还</a>]&nbsp;&nbsp;</td>
    </tr>
</table>
<form method="POST" name="form2" action="return.asp?action=return">

<table width=80% height=25% border="1" cellpadding=1 cellspacing=1   bordercolor="#CCFF99" align="center" >
	<tr  bgcolor="#FFCC99">
	  <td height=25 colspan=2 >&gt;&gt;图书归还</td>
	</tr>
	<tr><td class=TableBody2 align=right width=15% >图书名称：<br></td><td class=TableBody1 align=left><input type=text maxlength=50 name=Title size=50>
	*</td>
	</tr>
	
	<tr>
	  <td class=TableBody2 align=right width=15% >借阅人：</td>
	  <td class=TableBody1 align=left><input type=text maxlength=100 name=Owner size=50>
      *</td>
	</tr>
	
	
	
	
	
	<tr><td class=TableBody2 align=center colspan=2><input type=submit value=提交>&nbsp;<input type=reset value=重写></td></tr>
</table>
<input type=hidden name=IsAdd value=Yes>

</form>  
</body>