change.asp

自做的购物网站

<%
if session("admin_name")="" then
    response.redirect "login.asp"
    response.end 
end if
%>
<!--#include file="conn.asp"-->
<!--#include file="css.asp"-->
<%set rs=server.createobject("adodb.recordset")%>
<%
if request("action")="change" then

sql="select top 1 * from admin"
rs.open sql,conn,3,3
rs("admin_name")=request("admin_name")
rs("admin_pass")=request("admin_pass")
rs.update
rs.close
response.write "密码更改成功"
else

%>
<table width="560" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td>
      <form method="POST" action="change.asp?action=change">
        <table cellspacing=1 cellpadding=0 width="560" align=center bgcolor=#999999 
border=0>
          <tbody> 
          <tr> 
            <td width="560" background=images/pics/tile_back.gif id=maintitleback> 
              <table cellspacing=0 cellpadding=3 width="100%" border=0>
                <tbody> 
                <tr> 
                  <td><img height=8 src="images/pics/nav_m.gif" width=8 
            border=0></td>
                  <td width="100%" height="30" valign="bottom" id=maintitle>用户管理 
                    -&gt; <strong>更改密码</strong></td>
                </tr>
                </tbody> 
              </table>
            </td>
          </tr>
          <tr> 
            <td id=mainbg> 
              <table cellspacing=1 cellpadding=4 width="100%" border=0 height="94">
                <tbody> 
                <tr> 
                  <%sql="select top 1 * from admin"
          rs.open sql,conn,3,3%>
                  <td width="100" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
                    <div align="center"><font color="#FFFFFF">用户名</font></div>
                  </td>
                  <td width="150" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
                    <div align="center"> <font color="#FFFFFF"> 
                      <input type="text" name="admin_name" size="20" value="<%=rs("admin_name")%>" class=input>
                      </font></div>
                  </td>
                  <td width="100" height="30" align=middle noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
                    <div align="center"><font color="#FFFFFF">密码</font></div>
                  </td>
                  <td height="30" colspan="2" align=middle noWrap 
          background=images/pics/tile_sub.gif id=titlemedium><font color="#FFFFFF">　 
                    <input type="text" name="admin_pass" size="20" value="<%=rs("admin_pass")%>" class=input>
                    </font></td>
                </tr>
                <tr> 
                  <td height="30" colspan="5" bgcolor=#ffffff>
                    <div align="center"><img src="../IMAGES/pics/seperator.gif" width="359" height="1"></div>
                  </td>
                </tr>
                <tr> 
                  <td id=mainfoot 
colspan=5 height="30"> 
                    <div align="center"> 
                      <table width="30%" border="0" align="center" cellpadding="0" cellspacing="0">
                        <tr> 
                          <td height="25">
                            <div align="center"> 
                              <input name=submit2 type=image 
      src="../IMAGES/pics/ok.gif" alt=进入 
      align=absMiddle width="45" height="20" cache tppabs="">
                            </div>
                            <div align="center"> </div>
                          </td>
                        </tr>
                      </table>
                    </div>
                  </td>
                </tr>
                </tbody> 
              </table>
              <%rs.close
        %>
            </td>
          </tr>
          </tbody> 
        </table>
        <%end if
set rs=nothing
conn.close
set conn=nothing
%>
      </form>
</td>
  </tr>
</table>