📄 as_updata_book_2.asp
字号:
<!-- #include file="conn.asp" -->
<body bgcolor="">
<SCRIPT LANGUAGE="vbScript">
<!--
Sub update(bookID)
If f1.t1.value="" Then
msgbox"图书名不能为空!"
elseif not (isnumeric(f1.t5.value)) then
msgbox"必须为数字！"
elseif ((f1.t5.value)>999 or (f1.t5.value)<1) then
msgbox"不能小于1或大于999！"
else
f1.hid_bookID.value=bookID
f1.action="as_updata_book_2.asp?q=update"
f1.submit
End If
End sub
//-->
</SCRIPT>
<FORM METHOD=POST ACTION="" name="f1">
<INPUT TYPE="hidden" name="hid_bookID">
<%
Dim str,str1,bookID
bookID=request("hid_bookID")
If request("q")="update" Then
str="update book set Book_Name='" & request("t1") & "',Book_Author='" & request("t2") & "',Book_Press='" & request("t3") & "', Book_Category='" & request("t4") & "', Book_Price='" & request("t5") & "' where book_ID='" & bookID & "'"
conn.execute(str)
'成功后跳转
response.write"<SCRIPT LANGUAGE='JavaScript'>"
response.write"alert('更新成功!');"
response.write "location.href='see_book.asp'"
response.write"</SCRIPT>"
End if
Set rec=conn.execute("select * from book where book_ID='" & bookID & "'")
%>
<TABLE border="1" align="center">
<TR>
<TD height="50"><CENTER>更新图书</CENTER></TD>
</TR>
<TR>
<TD height="40">图书名：<INPUT TYPE="text" NAME="t1" value=<%=rec(1)%>> <FONT COLOR="red">*</FONT></TD>
</TR>
<TR>
<TD height="40">作 者：<INPUT TYPE="text" NAME="t2" value=<%=rec(2)%>></TD>
</TR>
<TR>
<TD height="40">出版社：<INPUT TYPE="text" NAME="t3" value=<%=rec(3)%>></TD>
</TR>
<TR>
<TD height="40">类 别：
<SELECT NAME="t4" value=<%=rec(4)%>>
<OPTION VALUE="文学艺术类">文学艺术类
<OPTION VALUE="计算机类">计算机类
<OPTION VALUE="社会科学类">社会科学类
<OPTION VALUE="自然科学类">自然科学类
<OPTION VALUE="外文书籍类">外文书籍类
<OPTION VALUE="其他">其他
</SELECT>
</TD>
</TR>
<TR height="40">
<TD>价 格：<INPUT TYPE="text" NAME="t5" value=<%=rec(6)%>>元</TD>
</TR>
<TR height="40">
<TD><CENTER><INPUT TYPE="button" value=" 更新 " onclick="update(<%=rec(0)%>)"> <INPUT TYPE="reset" value=" 取消 "></CENTER></TD>
</TR>
<TR>
<TD><FONT SIZE="4" COLOR="red"><CENTER>*为必填内容</CENTER></FONT></TD>
</TR>
</TABLE>
</FORM>
</body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -