www.gusucode.com > 漂亮的地方旅游景点景观介绍网站源代码 > admin/data/exe.asp
<!--#include file="../config.asp" --> <link href="../inc/mm.css" rel="stylesheet" type="text/css"> <% call zwtj() call chkqx(3,12) dim jg jg=Trim(Request.QueryString("jg")) select case action case "go" call go() case "" call show() end select sub go() on error resume next dim sqlstr sqlstr=getForm("sqlstr",1,1) if sqlstr<>"" then 'conn.begintrans conn.execute(sqlstr) 'if conn.errors.count>0 then ''有错误发生 'conn.rollbacktrans''回滚 'end if 'conn.CommitTrans ''提交事务 if err.number=0 then call errs(0) else call errs("<ul><li>"&err.description&"</li></ul>") end if else call cc("请输入SQL语句") end if end sub '显示 sub show() mytit="执行SQL语句" %> <form action="" method="post"> <table width="100%" border="0" cellpadding="5" cellspacing="1" class="wb"> <tr> <td width="100%" height="24" background="/images/admin/bg.gif" id="tit"><a href="../main.asp"><strong>管理首页</strong></a><strong> >> <%= mytit %></strong></td> </tr> <tr> <td align="center" bgcolor="#FCFCFA"><textarea style="width:100%;" name="sqlstr" cols="100" rows="16" class="inp" id="sqlstr" onfocus="on_input('err');this.className='focus'" onblur="out_sql();this.className='inp'"></textarea></td> </tr> <tr> <td bgcolor="#FCFCFA"><div id="err"></div></td> </tr> <tr> <td bgcolor="#FCFCFA"><input name="go" type="button" class="button_1" id="go" value="执行" onclick="goo()" onmouseover="this.className='button_2'" onmouseout="this.className='button_1'"/></td> </tr> </table> </form> <SCRIPT language="javascript" event="onkeydown" for="document"> if(event.keyCode==13&&event.srcElement.type!='button'&&event.srcElement.type!='submit'&&event.srcElement.type!='reset'&&event.srcElement.type!='textarea'&&event.srcElement.type!='') goo(); </SCRIPT> <script language="javascript"> function on_input(objname){ var strtxt; var obj=GE(objname); obj.className="d_on"; switch (objname){ case "err": strtxt=lion+" 请输入SQL语句..."; break; } obj.innerHTML=strtxt; } function out_sql() { var obj=GE("err") var objs=GE("sqlstr") if(ls(objs.value)<6) { obj.className="d_err" obj.innerHTML=err+" 请输入SQL语句" return false; } else { obj.className="d_ok" obj.innerHTML=ok+" SQL语句已输入" return true; } } function goo() { var chk=true if (!out_sql()){chk=false;} if(chk==true) { GE("go").disabled="disabled"; var Ajax = new oAjax("?action=go",backs); var arrKey = new Array("sqlstr"); var arrValue =new Array(escape(GE("sqlstr").value)); Ajax.Post(arrKey,arrValue); GE("err").innerHTML=loading; function backs(str) { if(str=="0") { GE("err").innerHTML=ok+" 命令已成功执行"; GE("go").disabled=""; } if(str!="0") { GE("err").className="d_err"; GE("err").innerHTML=err+" 命令执行失败"+unescape(str); GE("go").disabled=""; } } } } </script> <% call foot() end sub call connend() %>