📄 mbook.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
book_id=Request.QueryString("book_id")
%>
<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();">
<DIV ID="commentsboard" CLASS="popcomments"> </DIV>
<%
sql="select * from library_book where book_id='"&book_id&"'"
set rs=session("cn").execute(sql)
if not rs.eof then
%>
<center><h4>图书管理系统</h4>
(书籍信息修改)</center>
<form name=form1 action=mbook.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
value=<%=rs("book_id")%> maxlength=10 readonly>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
书籍名称
<input class=in name=book_name maxlength=40
value=<%=rs("book_name")%> size=16>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
位置架号
<input class=in name=stand maxlength=20 size=16
value=<%=rs("stand")%> onblur=checknum('stand')>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
位置层号
<input class=in maxlength=20 size=16 name=floor
value=<%=rs("floor")%> onblur=checknum('floor')>
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
图书作者
<input class=in maxlength=20 size=16
value=<%=rs("book_author")%> name=book_author >
</td>
</tr>
<tr align=center>
<td height=30 valign=center bgcolor=#f7f7f7>
出版社名
<input class=in maxlength=20 size=16
value=<%=rs("book_concern")%> 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 rs1=session("cn").execute(sql)
do while not rs1.eof
Response.Write "<option value="&rs1("team_id")
if rs("team_id")=rs1("team_id") then
Response.Write " selected "
end if
Response.Write ">"&rs1("book_team")&"</option>"
rs1.movenext
loop
rs1.close()
set rs1=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=button name=re value=" 取消 "
class=in onclick="javascript:window.close()">
</td>
</tr>
</table>
<center><%=Request.QueryString("comm")%></center>
</form>
<%end if%>
</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="update library_book set book_name='"&book_name&"'"
sql=sql&",stand="&stand&",floor="&floor
sql=sql&",book_author='"&book_author&"'"
sql=sql&",book_concern='"&book_concern&"'"
sql=sql&" ,team_id="&team_id&" where book_id='"&book_id&"'"
session("cn").execute(sql)
%>
<SCRIPT LANGUAGE=javascript>
<!--
window.close()
//-->
</SCRIPT>
<%
end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -