📄 delqueren.asp
字号:
<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 bookno
dim bookname
dim lendnumber
dim flag
flag = 1
bookno = request.Form("bookno")
bookname = request.Form("bookname")
if (bookno="" ) or (bookname="") then
%>
<table border="1" width="100%" id="table1">
<tr>
<td>
<p align="center"><b><font size="4">请填写要删除书目的完整信息!</font></b></td>
</tr>
<tr>
<td>
<p align="center"> </td>
</tr>
<tr>
<td>
<p align="center"><b>请<a href="admbooklist.asp">返回</a>重新填写!</b></td>
</tr>
</table>
<% flag = 0
else
if not(isnumeric(bookno)) 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="admbooklist.asp">返回</a>! </font></b></td>
</tr>
</table>
<% flag = 0
end if
end if
%>
<%
if (flag = 1) then
strConn = "DSN=dblib;uid=;pwd=;database=db"
strSQL ="select * from Tbook where bookno = " & bookno & "and bookname = '"& bookname &"'"
set objrst = GetADORecordset(strConn,strSQL)
if objrst.bof and objrst.eof 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="admbooklist.asp">返回</a></td>
</tr>
</table>
<% flag = 0
else
lendnumber = objrst.fields("lendnumber")
End if
ENd if
%>
<%
if (flag = 1) then
if (lendnumber >=1) 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="admbooklist.asp">返回</a>!</font></b></td>
</tr>
</table>
<%
else
dim strConn1
dim strSQL1
dim objrst1
strConn1 = "DSN=dblib;uid=;pwd=;database=db"
strSQL1 = "delete from Tbook where bookno = " & bookno & " and bookname = '" & bookname & "'"
Set Conn1 = Server.CreateObject("ADODB.Connection")
Set objrst1= Server.CreateObject("ADODB.Recordset")
Conn1.Open strConn1
objrst1.Open strSQL1, Conn1, 0, 1
Conn1.Close
Set Conn1 = Nothing
%>
<table border="1" width="100%" height="59%" id="table1">
<tr>
<td align="center" height="36"><b><font size="4">书籍删除成功</font></b></td>
</tr>
<tr>
<td align="center"></td>
</tr>
<tr>
<td height="38">
<p align="center"><b><a href="admbooklist.asp">返回</a> </b></td>
</tr>
</table>
<%
end if
End if
%>
</body>
</html>
<%
'======================================================================
' 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
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -