📄 del_yuanxi.asp
字号:
<!--#include file="inc/conn.asp"-->
<%
id=Trim(Request.QueryString("id"))
openDB
sql="select * from xi where x_name='"&id&"'"
set rs=conn.execute(sql)
if not rs.eof then
sql="delete from xi where x_name='"&id&"'"
set rs=conn.execute(sql)
sql="delete from stu where stu_xname='"&id&"'"
set rs=conn.execute(sql)
else
sql="select * from xueyuan where xy_name='"&id&"'"
set rs=conn.execute(sql)
xy_id=rs("xy_id")
sql="delete from xi where xy_id='"&xy_id&"'"
set rs=conn.execute(sql)
sql="delete from xueyuan where xy_name='"&id&"'"
set rs=conn.execute(sql)
sql="delete from stu where stu_xyname='"&id&"'"
set rs=conn.execute(sql)
end if
closeDB
Response.Redirect "add_yuanxi.asp"
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -