booksave.asp
来自「ASP+SQL Server的图书馆管理系统」· ASP 代码 · 共 64 行
ASP
64 行
<!--#include File="ConnDB.asp"-->
<html>
<head>
<title>保存图书信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=hz-gb-2312"></head>
<body>
<%
Dim StrAction
StrAction = Request.QueryString("action")
Set rs = Server.CreateObject("ADODB.RECORDSET")
Set rs1 = Server.CreateObject("ADODB.RECORDSET")
If StrAction="add" Then
sql="Select * from Book_Info"
rs.Open sql,Conn,1,3
rs.AddNew
rs("Book_Type") = Request("book_Type")
rs("book_Name")= Request("book_name")
rs("book_AddDate")= Date()
rs("book_Author") = request("book_Author")
rs("book_Press") = Request("book_Press")
rs("book_ImageFile") = request("book_imageFile")
rs("book_total")=1
rs("book_PrsDate")=Request("book_PrsDate")
rs("Book_Remark")=Request("book_Remark")
rs("Book_ImageFile")=request("upimage")
rs.Update
response.write "<h3>图书信息成功保存</h3>"
Else
sql="Select * from Book_Info where book_id="&request.form("book_id")
rs1.Open sql,Conn,1,3
rs1("Book_Type") = Request("Book_Type")
rs1("book_Name")= Request("book_name")
rs1("book_AddDate")= Date()
rs1("book_Author") = request("book_Author")
rs1("book_Press") = Request("book_Press")
rs1("book_total")=request("book_total")
rs1("book_PrsDate")=Request("book_PrsDate")
rs1("Book_Remark")=Request("book_Remark")
rs1.Update
response.write request("upimage")
response.write "<h3>图书信息成功修改</h3>"
End If
Set rs = Nothing
%>
</body>
<script language="javascript">
opener.location.reload();
setTimeout("window.close()",600);
</script>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?