testcmd.asp
来自「Active Server Pages 网页制作教程看之前请传到ASP空间。或者」· ASP 代码 · 共 36 行
ASP
36 行
<!-- #include virtual="/kjasp/func/DB.fun" -->
<%
Msg = "尚未输入指令"
DB = Request("DB")
If DB = Empty Then DB = "Sample.mdb"
SQL = Request("SQL")
On Error Resume Next
If SQL <> Empty Then
Set conn = GetMdbConnection( DB )
Set cmd = Server.CreateObject( "ADODB.Command" )
Set cmd.ActiveConnection = conn
cmd.CommandText = SQL
cmd.Execute
If Err.Number = 0 Then
Msg = "OK"
Else
Msg = Err.Description
End If
End If
%>
<HTML>
<BODY bgcolor="#FFFFFF">
<H2>TestCmd.asp -- Action Query 测试程序<HR></H2>
<FORM Action=TestCmd.asp Method=POST>
数据库:<INPUT Type=Text Name=DB Value="<%=DB%>"><BR>
指令:<INPUT Type=Text Name=SQL Size=50 Value="<%=SQL%>"><P>
<INPUT Type=Submit Value=" 执行">
</FORM>
<HR>指令执行情况: <FONT Color=Red><%=Msg%>!</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?