📄 backbookdone.asp
字号:
<html>
<head>
<title>显示书目</title>
</head>
<body bgcolor=#FF6600>
<%
dim userno
dim username
dim bookno
dim bookname
dim borrownumber
dim flag
dim flag1
flag1 = 1
flag = 1
dim strConn
dim strSQL
dim objrst
userno = request.Form("userno")
username = request.Form("username")
bookno = request.Form("bookno")
bookname = request.Form("bookname")
if (userno = "") or (username = "") or (bookno="") or (bookname="") then
%>
<table border="1" width="100%" id="table2">
<tr>
<td align="center"><b><font size="4"><b>请填写完整信息！</b></font></b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><b><font size="4">请<a href="backbook.asp">返回</a>!</font></b></td>
</tr>
</table>
<% flag = 0
userno = 0
bookno = 0
flag1 =0
else
if not(isnumeric(userno)) or not(isnumeric(bookno)) then
response.redirect "backnumbererr.asp"
end if
End if
strConn = "DSN=dblib;uid=;pwd=;database=db"
strSQL = "select * from Tuser where userno = " &userno & "and username = '"& username &"'"
set objrst = GetADORecordset (strConn,strSQL)
if objrst.bof and objrst.eof then
if (flag1 = 1 ) then
%>
<table border="0" width="100%">
<tr>
<td align="center"><font size=5 color=navy><b>您输入的姓名和学号不符!请重新输入!</td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><font size=5 color=navy><b>
<a href="backbook.asp">返回</a></td>
</tr>
</table>
<%
end if
flag = 0
else
borrownumber = objrst.fields("borrownumber")
End if
%>
<%
dim strConn1
dim strSQL1
dim objrst1
dim nownumber
dim lendnumber
strConn1= "DSN=dblib;uid=;pwd=;database=db"
strSQL1 = "select * from Tbook where bookno = " &bookno & "and bookname = '"& bookname &"'"
set objrst1 = GetADORecordset (strConn1,strSQL1)
if objrst1.bof and objrst1.eof then
if (flag1 = 1 ) then
%>
<table border="0" width="100%">
<tr>
<td align="center"><font size=5 color=navy><b>您输入的书名和书号不符!请重新输入!</td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><font size=5 color=navy><b>
<a href="backbook.asp">返回</a></td>
</tr>
</table>
<%
end if
flag = 0
else
nownumber = objrst1.fields("nownumber")
lendnumber = objrst1.fields("lendnumber")
End if
%>
<%
'======================================================================
' GetADORecordset -- Gets an ADO recordset given a connectionstring,
' sql query string.
'
'==============================
Function GetADORecordset(strConn, strSQL)
On Error Resume Next
Dim objConnection
Dim objRecordset
Err.Clear
' Setup an ADO connection to the database:
Set objConnection = Server.CreateObject("ADODB.Connection")
Set objRecordset = Server.CreateObject("ADODB.Recordset")
objConnection.ConnectionString = strConn
objConnection.Open
Set objRecordset.ActiveConnection = objConnection
objRecordset.Source = strSQL
objRecordset.CursorLocation = 3
objRecordset.Open
If Err Then
Set GetADORecordset = Nothing
If Not HaveError() Then
SetError "GetADORecordset", Err.number, Err.Description
End If
Else
Set GetADORecordset = objRecordset
End If
End Function
%>
<%If (flag = 1) then
userno = request.Form("userno")
username = request.Form("username")
%>
<%
dim strConn2
dim strSQL2
dim objrst2
strConn2 = "DSN=dblib;uid=;pwd=;database=db"
strSQL2 = "delete from Tborrowed where id=(select top 1 id from Tborrowed where userno = " & userno & " and bookno = " & bookno & ")"
Set Conn2 = Server.CreateObject("ADODB.Connection")
Set objrst2= Server.CreateObject("ADODB.Recordset")
Conn2.Open strConn2
objrst2.Open strSQL2, Conn2, 0, 1
Conn2.Close
Set Conn2 = Nothing
dim strConn3
dim ADOObjConn3
dim strSQL3
dim objrst3
strConn3 = "DSN=dblib;uid=;pwd=;database=db"
set objrst3= server.CreateObject("ADODB.Recordset")
strSQL3 = "select * from Tuser where userno = " & userno
objrst3.Open strSQL3, strConn3 , 1, 3
if objrst3.bof and objrst3.eof then
response.write "<html> <head>"
response.write "<title>错误</title>"
response.write "</head><body>"
response.write "<br><br><center><font size=5 color=navy><b>数据库操作错误<br>"
response.write "</body></html>"
response.redirect borrowbook.asp
else
borrownumber = borrownumber-1
objrst3.fields("borrownumber").value = borrownumber
objrst3.update
set objrst3 = nothing
End if
dim strConn4
dim strSQL4
dim objrst4
set objrst4= server.CreateObject("ADODB.Recordset")
strConn4 = "DSN=dblib;uid=;pwd=;database=db"
strSQL4 = "select * from Tbook where bookno = " & bookno
objrst4.Open strSQL4, strConn4 , 1, 3
if objrst4.bof and objrst4.eof then
response.write "<html> <head>"
response.write "<title>错误</title>"
response.write "</head><body>"
response.write "<br><br><center><font size=5 color=navy><b>数据库操作错误<br>"
response.write "</body></html>"
response.redirect borrowbook.asp
else
nownumber = nownumber + 1
lendnumber = lendnumber - 1
objrst4.fields("nownumber").value =nownumber
objrst4.fields("lendnumber").value = lendnumber
objrst4.update
set objrst4 = nothing
End if
%>
<table border="0" width="100%">
<tr>
<td align="center"><b><font size="5">操作成功!</font></b></td>
</tr>
<tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><b><font size="5"><a href="backbook.asp">返回</a></font></b></td>
</tr>
</table>
<%End IF
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -