📄 book.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
booktype=Request.QueryString("if")
%>
<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.stand.value=="")
{
alert("请填写书籍所在的架号！")
document.form1.stand.focus()
return false;
}
if(document.form1.floor.value=="")
{
alert("请填写书籍所在的层号！")
document.form1.floor.focus()
return false;
}
if(document.form1.book_author.value=="")
{
alert("请填写书籍作者名称！")
document.form1.book_author.focus()
return false;
}
if(document.form1.book_concern.value=="")
{
alert("请填写书籍出版社名称！")
document.form1.book_concern.focus()
return false;
}
document.form1.submit()
}
function checknum(objname)
{
if (isNaN(eval("document.form1."+objname+".value"))==true)
{
alert("请输入正确的数字，不能输入字母或其他符号")
eval("document.form1."+objname).value=""
eval("document.form1."+objname+".focus()")
return false;
}
}
//-->
</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>
(书籍信息<%if booktype="add" then Response.Write "录入"%>)</center>
<form name=form1 action=book.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=stand maxlength=20 size=16
onblur=checknum('stand')>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
位置层号
<input class=in maxlength=20 size=16 name=floor
onblur=checknum('floor')>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
图书作者
<input class=in maxlength=20 size=16 name=book_author >
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
出版社名
<input class=in maxlength=20 size=16 name=book_concern >
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
图书类别
<select name=book_team style="width=110">
<% '获取书籍类别信息
sql="select * from library_team order by team_id desc"
set rs=session("cn").execute(sql)
do while not rs.eof
Response.Write "<option value="&rs("team_id")
Response.Write ">"&rs("book_team")&"</option>"
rs.movenext
loop
rs.close()
set rs=nothing
%>
</select>
</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")
stand=Request.Form("stand")
floor=Request.Form("floor")
book_author=Request.Form("book_author")
book_concern=Request.Form("book_concern")
team_id=Request.Form("book_team")
'查询此书籍编号是否存在
sql="select count(*) from library_book"
sql=sql&" where book_id='"&book_id&"'"
set cou=session("cn").execute(sql)
if cou(0)=0 then
'编号不存在，求最大ID值然后加1
sql="select max(id),count(*) from library_book"
set rs=session("cn").execute(sql)
if rs(1)=0 then
id=1
else
id=rs(0)+1
end if
'将书籍信息存放到数据库中。
sql="insert into library_book(id,book_id,book_name"
sql=sql&" ,stand,floor,book_author,book_concern,team_id,sf_return)"
sql=sql&" values ("&id&",'"&book_id&"','"&book_name&"',"&stand
sql=sql&","&floor&",'"&book_author&"','"&book_concern&"',"&team_id&",'N')"
session("cn").execute(sql)
Response.Redirect "book.asp?comm=信息添加成功！"
else
'书籍编号存在不能添加书籍，返回添加页面
Response.Redirect "book.asp?comm=信息曾经录入过，本次添加不成功！"
end if
end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -