asp 中 sql字符串生成程序

sqlstrMaker.asp--------------------------------------------------------------------

<%
if request.Form("submit")<>"" and  request.Form("sqlstr")<>""  then
dim ziduan,strsql,strend
strsql=trim(request.Form("sqlstr"))
ziduan=replace(strsql,chr(32),"," )
strsql2=replace(strsql,chr(32)," & "','" & " )
strend="""+"insert into dgxx ("& ziduan &") values ('" & " +""+strsql2+ " & "')""
response.Write(strend)
end if
'end if
response.Write "insert into dgxx (ffdsa,fdsa) values ('" & ffdsa & "','" & fdsa & "')"
%>

<form name="form1" method="post" action="">
  <p> </p>
  <p>sql生成
    <input name="sqlstr" type="text" id="sqlstr" size="100">  
  </p>
  
  <div align="center">
    <input type="submit" name="Submit" value="提交">
  </div>
  </label>
</form>

sqlstrMaker.asp--------------------------------------------------------------------

文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: 字符串字符串
相关日志: