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 + -
显示快捷键?