typedelt.asp

来自「ASP+SQL Server的图书馆管理系统」· ASP 代码 · 共 47 行

ASP
47
字号
<!--#include file="ConnDB.asp"-->

<html>
<head>
<title>删除图书类别</title>
<link href=style.css rel=STYLESHEET type=text/css>
</head>
<body>
<%
  '从数据库中批量删除类别信息
  Dim id,sql
  
  id = Request.QueryString("type_id")
  sql = "DELETE FROM book_Type WHERE type_id In (" & id & ")"
   Set Rs = Conn.Execute(sql)

  sql = "Delete From book_Type Where type_id In ("&id&")"
  Conn.Execute(sql)

  Set Rs = Nothing
  Conn.Close()
 
 ' Response.Write "<h2>成功删除!</h2>"
%>

</body>
<script language="javascript">
  alert("成功删除!");
  location.href = "bookList.asp?flag=0";
</script>
</html>















⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?