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> &gt;&gt; <%= 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+"&nbsp;&nbsp;请输入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+"&nbsp;&nbsp;请输入SQL语句"
return false;
}
else
{
obj.className="d_ok"
obj.innerHTML=ok+"&nbsp;&nbsp;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+"&nbsp;&nbsp;命令已成功执行";
GE("go").disabled="";
}
if(str!="0")
{
GE("err").className="d_err";
GE("err").innerHTML=err+"&nbsp;&nbsp;命令执行失败"+unescape(str);
GE("go").disabled="";
}
}

}
}
</script>
<% 
call foot()
end sub 
call connend()
%>