pwd_up_x.asp

来自「企业员工年度综合评测系统 Access(V1.060118)版」· ASP 代码 · 共 23 行

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="forbidon.asp" -->
<!--#include file="conn.asp" -->
<%
var admin=Session("admin");
var departmentid=Session("departmentid");
if(String(Request("pwd")) != "undefined"){ pwd1 = String(Request("pwd"));}
var cmd = Server.CreateObject("ADODB.Command");
var sql="";
if(Session("isvgm")==0)
    {sql="UPDATE department   SET pw1='"+ pwd1 + "' WHERE departmentid="+departmentid+" AND admin1='"+admin+"' ";}
if(Session("isvgm")==1)
    {sql="UPDATE department   SET pw2='"+ pwd1 + "' WHERE departmentid="+departmentid+" AND admin2='"+admin+"' ";}
cmd.ActiveConnection = MM_conn_STRING;
cmd.CommandText = sql;
cmd.CommandType = 1;
cmd.CommandTimeout = 0;
cmd.Prepared = true;
cmd.Execute();
Response.Write("<script language='javascript'>window.alert('密码修改成功');location=('main.asp');</script>");
Response.End();

%>