bookinsertdone.asp
来自「tushuguanlixitong 图书借阅系统 用ASP实现的 能实现简单的」· ASP 代码 · 共 98 行
ASP
98 行
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>录入成功</title>
</head>
<body bgcolor=#FF6600>
<%
dim bookname
dim sumnumber
dim nownumber
dim lendnumber
dim describe
dim flag
flag = 1
dim dbconn
dim ADOObjConn
dim strSQL
dim Adoobject
dim strConn
bookname = request.Form("bookname")
sumnumber = request.Form("sumnumber")
nownumber = sumnumber
lendnumber = 0
describe = request.Form("describe")
if (bookname="") or (sumnumber="") then
%>
<table border="1" width="100%">
<tr>
<td align="center"><b><font size="4">请填写完整的书名与数量!</font></b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><b><font size="4">请<a href="bookinsert.htm">返回</a>重新填写!</font></b></td>
</tr>
</table>
<%
flag = 0
end if
if (flag = 1) then
strConn = "DSN=dblib;uid=;pwd=;database=db"
set ADOObjConn = server.CreateObject ("ADODB.Connection")
ADOObjConn.ConnectionString = strConn
ADOObjConn.Open
set Adoobject = server.CreateObject ("ADODB.Recordset")
strSQL = "SELECT * from Tbook "
Adoobject.Open strSQL, ADOObjConn, 1, 3
Adoobject.AddNew
'存储用户信息
Adoobject.Fields ("bookname").Value =bookname
Adoobject.Fields ("sumnumber").Value =sumnumber
Adoobject.Fields ("nownumber").Value =nownumber
Adoobject.Fields ("lendnumber").Value =lendnumber
Adoobject.Fields ("describe").Value =describe
Adoobject.Update
Adoobject.Close
Set Adoobject = Nothing
%>
<table border="1" width="100%" id="table1" height="128" bordercolordark=#0000FF style="border-collapse: collapse">
<tr>
<td height="39" align="right" width="379">书名</td>
<td height="39"><%=bookname%> </td>
</tr>
<tr>
<td align="right" width="379"> 数量</td>
<td><%=sumnumber%> </td>
</tr>
<tr>
<td align="right" width="379"> 说明</td>
<td><%=describe%> </td>
</tr></table>
<table width="100%" high="22" height="34">
<tr>
<td >
<p align="center"><a href="bookinsert.htm">返回</a></td>
</tr>
</table>
<%
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?