delsuject.asp

java书店管理系统 java书店管理系统 java书店管理系统

<!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<%
	Dim strID ,strUrl
	strID = Request.QueryString("ID")
	strUrl = "index_Suject.asp?ID=" & strID
	If strID &"" = "" Then
		Response.Write("参数错误！")
		Response.End
	End If 


	Dim rs ,strSql 
	strSql = "DELETE FROM Suject WHERE ID = " &strID &" DELETE FROM TeachingSuject WHERE SujectID = " &strID 
	Set rs = Server.CreateObject("ADODB.Recordset")
	rs.open strSql,conn,3,1
	Response.Redirect(strUrl)
	

%>