📄 main.asp
字号:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<!--对用户登录身份进行判断，非法用户返回登录页面-->
<%if not session("user_session_id")=Session.SessionID then%>
<SCRIPT LANGUAGE=javascript>
parent.window.location.href="../default.asp"
</SCRIPT>
<%end if%>
<!--没有提交数据-->
<%if Request.Form("hid")="" then%>
<HEAD>
<TITLE>图书馆管理系统</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="../css/scss.css" type=text/css rel=stylesheet>
<style TYPE="text/css">
<!--
.in
{
BORDER-RIGHT: rgb(127,127,127) 1px solid;
BORDER-TOP: rgb(127,127,127) 1px solid;
FONT-SIZE: 9pt;
BORDER-LEFT: rgb(127,127,127) 1px solid;
BORDER-BOTTOM: rgb(127,127,127) 1px solid;
BACKGROUND-COLOR: #ffffff
}
//-->
</STYLE>
<SCRIPT LANGUAGE=javascript>
<!--
function cli()
{
if(document.form1.book_id.value=="")
{
alert("请填写书籍编号！")
document.form1.book_id.focus()
return false;
}
if(document.form1.book_name.value=="")
{
alert("请填写书籍名称！")
document.form1.book_name.focus()
return false;
}
if(document.form1.card_id.value=="")
{
alert("请填写借书卡号！")
document.form1.card_id.focus()
return false;
}
if(document.form1.card_name.value=="")
{
alert("请填写借者姓名！")
document.form1.card_name.focus()
return false;
}
document.form1.submit()
}
//-->
</SCRIPT>
</HEAD>
<!--显示书籍借阅页面-->
<BODY text=#000000 bgColor=#f7f7f7 leftMargin=0 topMargin=0
onload="document.form1.book_id.focus();">
<!--#include file=../inc/top.asp-->
<DIV ID="commentsboard" CLASS="popcomments"> </DIV>
<center><h4>图书借阅系统</h4></center>
<form name=form1 action=main.asp method=post >
<table cellspacing=0 cellpadding=0 width=100% border=0>
<tr align=center>
<td valign=center bgcolor=#f7f7f7 height=30>
书籍编号
<input name=book_id class=in size=16 maxlength=10>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
书籍名称
<input class=in name=book_name maxlength=40 size=16>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
借书卡号
<input class=in name=card_id maxlength=20 size=16 >
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
借者姓名
<input class=in maxlength=20 size=16 name=card_name>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
借阅时间
<input class=in maxlength=20 size=16
name=lend_time value=<%=date()%> readonly>
</td>
</tr>
<tr>
<td height=30 align=middle valign=center
bgcolor=#f7f7f7 colspan=2>
<input type=hidden name=hid value="ok">
<input type=button name=butt value=" 提交 "
class=in onclick="javascript:cli()">
<input type=reset name=re value=" 取消 " class=in>
</td>
</tr>
</table>
<center><%=Request.QueryString("comm")%></center>
</form>
</BODY>
</HTML>
<%'接收书籍借阅信息
else
book_id=Request.Form("book_id")
book_name=Request.Form("book_name")
card_id=Request.Form("card_id")
card_name=Request.Form("card_name")
lend_time=Request.Form("lend_time")
'判断此书是否已经借出
sql="select count(*) from library_book where "
sql=sql&" book_id='"&book_id&"' and sf_return='N'"
set book=session("cn").execute(sql)
'判断此卡是否存在
sql="select count(*) from card where card_id='"&card_id&"'"
set ca=session("cn").execute(sql)
if book(0)=0 or ca(0)=0 then
'书已借出或卡号不存在则返回
Response.Redirect "main.asp?comm=信息不正确，请重新添加！"
else
'求借阅图书的最大ID＋1，将借阅信息放到数据库中，将书籍借阅信息置成已借阅。
sql="select max(id),count(*) from lend_book"
set rs=session("cn").execute(sql)
if rs(1)=0 then
id=1
else
id=rs(0)+1
end if
sql="insert into lend_book(id,book_id,book_name,card_id"
sql=sql&",card_name,lend_time) values ("&id&",'"&book_id&"'"
sql=sql&" ,'"&book_name&"','"&card_id&"'"
sql=sql&",'"&card_name&"','"&lend_time&"')"
session("cn").execute(sql)
sql="update library_book set sf_return='Y'"
sql=sql&" where book_id='"&book_id&"'"
session("cn").execute(sql)
Response.Redirect "main.asp?comm=信息添加成功！"
end if
end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -