📄 sc.asp
字号:
<!--#include file="conn.asp"-->
<%
dim rs
dim sql
xh=request("xh")
zybj=request("zybj")
dim rs1
dim sql1
set rs1=server.createobject("adodb.recordset")
sql1="select * from zybjmc where zybj='" + zybj + "'"
rs1.open sql1,conn,3,3
bjbh = rs1("bjbh")
bjbh="b"+cstr(bjbh)
rs1.close
set rs1=nothing
dim rs2
dim sql2
set rs2=server.createobject("adodb.recordset")
sql2="select * from "&bjbh&" where xh='" + xh + "'"
rs2.open sql2,conn,3,3
rs2.delete
rs2.close
set rs2=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from cxb where xh='" + xh + "'"
rs.open sql,conn,3,3
rs.delete
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect("index0.asp")
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -