user_update.asp

Dreamweaver 8网页设计与网站建设 第2版.rar

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="../Connections/connUser1.asp" -->
<%
// *** Restrict Access To Page: Grant or deny access to this page
var MM_authorizedUsers="123";
var MM_authFailedURL="restrict.asp";
var MM_grantAccess=false;
if (String(Session("MM_Username")) != "undefined") {
  if (false || (String(Session("MM_UserAuthorization"))=="") || (MM_authorizedUsers.indexOf(String(Session("MM_UserAuthorization"))) >=0)) {
    MM_grantAccess = true;
  }
}
if (!MM_grantAccess) {
  var MM_qsChar = "?";
  if (MM_authFailedURL.indexOf("?") >= 0) MM_qsChar = "&";
  var MM_referrer = Request.ServerVariables("URL");
  if (String(Request.QueryString()).length > 0) MM_referrer = MM_referrer + "?" + String(Request.QueryString());
  MM_authFailedURL = MM_authFailedURL + MM_qsChar + "accessdenied=" + Server.URLEncode(MM_referrer);
  Response.Redirect(MM_authFailedURL);
}
%>
<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
  MM_editAction += "?" + Request.QueryString;
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Update Record: set variables

if (String(Request("MM_update")) == "form1" &&
    String(Request("MM_recordId")) != "undefined") {

  var MM_editConnection = MM_connUser1_STRING;
  var MM_editTable  = "Userinfo";
  var MM_editColumn = "Username";
  var MM_recordId = "'" + Request.Form("MM_recordId") + "'";
  var MM_editRedirectUrl = "user_updateok.asp";
  var MM_fieldsStr = "Password|value";
  var MM_columnsStr = "Password|',none,''";

  // create the MM_fields and MM_columns arrays
  var MM_fields = MM_fieldsStr.split("|");
  var MM_columns = MM_columnsStr.split("|");
  
  // set the form values
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    MM_fields[i+1] = String(Request.Form(MM_fields[i]));
  }

  // append the query string to the redirect URL
  if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
    MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
  }
}
%>
<%
// *** Update Record: construct a sql update statement and execute it

if (String(Request("MM_update")) != "undefined" &&
    String(Request("MM_recordId")) != "undefined") {

  // create the sql update statement
  MM_editQuery = "update " + MM_editTable + " set ";
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    var formVal = MM_fields[i+1];
    var MM_typesArray = MM_columns[i+1].split(",");
    var delim =    (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
    var altVal =   (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
    var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
    if (formVal == "" || formVal == "undefined") {
      formVal = emptyVal;
    } else {
      if (altVal != "") {
        formVal = altVal;
      } else if (delim == "'") { // escape quotes
        formVal = "'" + formVal.replace(/'/g,"''") + "'";
      } else {
        formVal = delim + formVal + delim;
      }
    }
    MM_editQuery += ((i != 0) ? "," : "") + MM_columns[i] + " = " + formVal;
  }
  MM_editQuery += " where " + MM_editColumn + " = " + MM_recordId;

  if (!MM_abortEdit) {
    // execute the update
    var MM_editCmd = Server.CreateObject('ADODB.Command');
    MM_editCmd.ActiveConnection = MM_editConnection;
    MM_editCmd.CommandText = MM_editQuery;
    MM_editCmd.Execute();
    MM_editCmd.ActiveConnection.Close();

    if (MM_editRedirectUrl) {
      Response.Redirect(MM_editRedirectUrl);
    }
  }

}
%>
<%
var rsUser_update__MM_Username = "123";
if (String(Session("Username")) != "undefined" && 
    String(Session("Username")) != "") { 
  rsUser_update__MM_Username = String(Session("Username"));
}
%>
<%
var rsUser_update = Server.CreateObject("ADODB.Recordset");
rsUser_update.ActiveConnection = MM_connUser1_STRING;
rsUser_update.Source = "SELECT Username, Password  FROM Userinfo  WHERE Username = '"+ rsUser_update__MM_Username.replace(/'/g, "''") + "'";
rsUser_update.CursorType = 0;
rsUser_update.CursorLocation = 2;
rsUser_update.LockType = 1;
rsUser_update.Open();
var rsUser_update_numRows = 0;
%>

<html><!-- InstanceBegin template="/Templates/index.dwt.asp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>修改密码</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>

<table width="750" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> 
    <td width="129" height="147" valign="top"><img src="../images/yy.gif" width="129" height="146"></td>
    <td width="656" valign="top"><img src="../images/bt.gif" width="620" height="147"></td>
  </tr>
  <tr> 
    <td height="28" align="center" valign="top" bgcolor="#CCFFFF"><font color="#000000">DMX.COM</font></td>
    <td align="center" valign="top" bordercolor="#FF0033" bgcolor="#66FFFF"> 
      <% var today=new Date();
		month=today.getMonth()+1;
		Response.Write(today.getYear()+"年"+month+"月"+today.getDate()+"日")%>
    </td>
  </tr>
</table>
<table width="752" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> 
    <td width="785" height="27" valign="top" bgcolor="#99FF99"> 
      <hr>
      <font color="#000000" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="../index.asp">首页</a>│<a href="../temp_show/temp0.asp">模板</a>│<a href="../Frameset/Frameset-1.htm">框架</a>│<a href="../Photo/index.htm">相册</a>│<a href="../dbadm/admin.asp">数据库管理</a>∣<a href="../map/map.htm">图像地图</a>│<a href="../media/media.asp">媒体</a></font><font size="2">|<a href="../Text/text_m.htm">命名锚记</a>|<a href="../dh/dh.htm">动画|</a></font> 
    </td>
  </tr>
</table>
<table width="752" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> <!-- InstanceBeginEditable name="EditRegion3" --> 
    <td width="750" height="137" valign="top">
<div align="center">
        <p><font color="#FF0000" size="5">修改密码</font></p>
        <p>你的用户名为<%= Session("MM_Username") %></p>
        <form name="form1" method="POST" action="<%=MM_editAction%>">
          <p>请输入新密码： 
            <input name="Password" type="password" id="Password" size="20">
          </p>
          <p> 
            <input type="submit" name="Submit" value="确认">
          </p>
          <input type="hidden" name="MM_update" value="form1">
          <input type="hidden" name="MM_recordId" value="<%= rsUser_update.Fields.Item("Username").Value %>">
        </form>
        <p><font color="#000000" size="3"><a href="../index.asp">取消修改密码</a></font></p>
      </div></td>
    <!-- InstanceEndEditable --></tr>
</table>
</body>
<!-- InstanceEnd --></html>
<%
rsUser_update.Close();
%>