activatejz.asp

一个公司营销系统

<!--#include file="connn.asp"-->
<%
user=request("user")
    dim sql 
   dim rs
   set rs=server.createobject("adodb.recordset")
   sql="update user set key1='1',key2='1',key3='1',key4='1',key5='1' where username like '" & user& "' " 
   rs.open sql,conn,1,1
   set rs=nothing  
   conn.close
   set conn=nothing
   response.write "<br>" 
   response.write "<center>"
   response.write "该用户被成功全部激活!"
   response.write "<br>"
   response.write "你的网站的地址是：http://www.tiyi.net/sh/index.asp?user=你的用户名"
   response.write "<br>"
   response.write "<a href=javascript:this.close();>关闭窗口</a> "
   response.write "</center>"
   response.write "<br>"
%>