📄 del.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>删除信息界面|毕业设计选题系统</title>
<link href="../css/Style.css" rel="stylesheet" type="text/css" />
</head>
<BODY leftMargin=0 topMargin=0 marginwidth="0">
<!--#include file=../top.asp-->
<!--#include file=top.asp-->
<div align="center"><td><table width="768" border="0" bgcolor="#FFFFFF"><tr><td><div align="left">
<%
Dim TYP
TYP = Request.QueryString("type")
Dim ID
ID = Request.QueryString("id")
If TYP = "teacher" Then
%>
<p>教师删除成功</p>
<p>所选教师已成功删除，<a href="list.asp?list=5"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 点击返回教师列表</a></p>
<%
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "delete from dbo.teacher where tea_id='"&ID&"'"
conn.CursorType = 1
conn.LockType = 3
conn.Open()
Set conn = Nothing
End If
If TYP = "student" Then
%>
<p>学生删除成功</p>
<p>所选学生已成功删除，<a href="list.asp?list=6"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 点击返回学生列表</a></p>
<%
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "select * from dbo.student where stu_id='"&ID&"'"
conn2.CursorType = 0
conn2.LockType = 1
conn2.Open()
If conn2("stu_works")<>"0000" Then
Dim WID
WID = conn2("stu_works")
Dim conn3
Set conn3=Server.CreateObject("ADODB.RecordSet")
conn3.ActiveConnection = "DSN=hw;User ID=sa"
conn3.Source = "update dbo.works set works_state='2' where works_id='"&WID&"'"
conn3.CursorType = 1
conn3.LockType = 3
conn3.Open()
Set conn3=Nothing
End If
Set conn2 = Nothing
Dim conn4
Set conn4=Server.CreateObject("ADODB.RecordSet")
conn4.ActiveConnection = "DSN=hw;User ID=sa"
conn4.Source = "delete from dbo.student where stu_id='"&ID&"'"
conn4.CursorType = 1
conn4.LockType = 3
conn4.Open()
Set conn4 = Nothing
End If
If TYP = "works" Then
%>
<p>选题删除成功</p>
<p>所选选题已成功删除，<a href="list.asp?list=1"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 点击返回选题列表</a> <a href="list.asp?list=2"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 审核题目清单</a> <a href="list.asp?list=3"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 待选题目清单</a> <a href="list.asp?list=4"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 已选题目清单</a></p>
<%
Dim conn5
Set conn5=Server.CreateObject("ADODB.RecordSet")
conn5.ActiveConnection = "DSN=hw;User ID=sa"
conn5.Source = "select * from dbo.works where works_id='"&ID&"'"
conn5.CursorType = 0
conn5.LockType = 1
conn5.Open()
If conn5("works_state") = "3" Then
Set conn5 = Nothing
Dim WID2
WID2 = conn5("works_id")
Dim conn6
Set conn6=Server.CreateObject("ADODB.RecordSet")
conn6.ActiveConnection = "DSN=hw;User ID=sa"
conn6.Source = "update dbo.student set stu_works='0000' where stu_works='"&WID2&"'"
conn6.CursorType = 1
conn6.LockType = 3
conn6.Open()
Set conn6 = Nothing
End If
Set conn5 = Nothing
Dim conn7
Set conn7=Server.CreateObject("ADODB.RecordSet")
conn7.ActiveConnection = "DSN=hw;User ID=sa"
conn7.Source = "delete from dbo.works where works_id='"&ID&"'"
conn7.CursorType = 1
conn7.LockType = 3
conn7.Open()
Set conn7 = Nothing
End If
%>
</div></td></tr></table></td></div>
<!--#include file=botton.asp-->
<!--#include file=../botton.asp-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -