📄 updatesave.asp

📁 一个公司营销系统
💻 ASP
字号:
<!--#include file="../conn.asp"-->
<%
if session("username")="" or session("password")="" then
   session.timeout=5
   response.write "<script language='javascript'>"
   response.write "alert('账号或密码错误！');"
   response.write "history.go(-1);"
   response.write "</script>"
   response.end
else
   username=session("username")
end if
dim sql 
dim rs 
sql="update  user set password='"&request("password")&"',card='"&request("card")&"',bank='"&request("bank")&"',name='"&request("name")&"',email='"&request("email")&"',nickname='"&request("nickname")&"',egold='"&request("egold")&"',qq='"&request("qq")&"',address='"&request("address")&"',postcard='"&request("postcard")&"',bbs='"&request("bbs")&"' where username like '" & username & "' " 
conn.execute sql
Set rs= Server.CreateObject("ADODB.Recordset") 
sql1="select * from user  where username like '" & username & "' " 
rs.open sql1,conn,3,2
%>

<html>
<head>
<style>
<!--
p{color:000000;FONT-FAMILY: "??"; font-size: 9pt ;line-height: 20px;}
a {color:#000000;FONT-FAMILY: "??"; font-size: 9pt ;text-decoration:none}
a:hover {color:red;text-decoration:underline;; FONT-FAMILY: "??"; font-size: 9pt}
-->
<!--
a:link {FONT-FAMILY: "??";  font-size: 9pt; color:#000000; text-decoration: none}
td { color:#0000000;FONT-FAMILY: "??"; font-size: 9pt ;line-height: 18px; } a:visited {FONT-FAMILY: "??";  font-size: 9pt; color:#000000}
-->
</style>

<script>
function chkemail(a)
  {    var i=a.length;
       var temp = a.indexOf('@');
       var tempd = a.indexOf('.');
       if (temp > 1) {
          if ((i-temp) > 3){
               if (tempd!=-1){
                     return 1;
               }

          }
        }
      return 0;
  }
function checkForm()
{
 if ((document.AddUserForm.bank.value=="")||(document.AddUserForm.email.value=="")||(document.AddUserForm.nickname.value==""))
 {
  alert("请正确输入表中信息！");
 }
 else if (chkemail(document.AddUserForm.email.value)==0)
 {
  alert("请输入正确的Email地址！");
 }
 else {
  document.AddUserForm.submit();
 }
}
</script>
<style>
<!--
p{color:000000;FONT-FAMILY: "宋体"; font-size: 9pt ;line-height: 18px;}
a {color:#000000;FONT-FAMILY: "宋体"; font-size: 9pt ;text-decoration:none}
a:hover {color:red;text-decoration:underline;; FONT-FAMILY: "宋体"; font-size: 9pt}
-->
a:link {FONT-FAMILY: "宋体";  font-size: 9pt; color:#000000; text-decoration: none}
td { color:#0000000;FONT-FAMILY: "宋体"; font-size: 9pt ;line-height: 18px; } a:visited {FONT-FAMILY: "宋体";  font-size: 9pt; color:#000000}
-->
</style>
<title>修改个人信息</title>
</head>

<body bgcolor="#7bb5de">
<div align="center">

     <table border="0" width="60%" cellpadding="4" class=lowcolor cellspacing="0" bordercolor="#111111" style="border-collapse: collapse">
      
    <tr> 
      <td align="right" width="28%" background="../Images/lvbg.gif" height="28"> 
        <div align="center">用 户 名：</div>
        </td>
        
      <td width="72%" align="left" background="../Images/lvbg.gif" height="28"><font color="red"><%=username%></font></td>
      </tr>
      <tr>
        
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <p align="right">密码：</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("password")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="center"></div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">　</td>
      </tr>
      <tr>
        
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="right">银行卡卡号：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("card")%></font></td>
      </tr>
      
    <tr> 
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="right">姓  名：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("name")%></font></td>
      </tr>
      <tr>
        
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="right">开 户 行：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("bank")%></font></td>
      </tr>
      
    <tr> 
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="right">Email：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("email")%></font> 
      </td>
      </tr>
      <tr>
        
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="right">昵 称：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> <font color="#FF0000"><%=rs("nickname")%></font> 
      </td>
      </tr>
      <tr>
        <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <p align="right">E-Gold帐号：</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("egold")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
      <p align="right">QQ：</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("qq")%></font> 
      </td>
      </tr>
      <tr>
        <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">
        <p align="right">通信地址：</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("address")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="right" width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">邮政编码:</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("postcard")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="right" width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">图片URL(上):</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("ad1")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="right" width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">链接至URL(上):</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("adurl1")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="right" width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">图片URL(下):</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("ad2")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="right" width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC">链接至URL(下):</td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("adurl2")%></font> 
      </td>
      </tr>

      <tr>
        <td width="28%" height="30" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
          <div align="right">我的论坛：</div>
        </td>
        
      <td width="72%" align="left" valign="middle" style="border-right: 1px solid #C9D8AD" bgcolor="#F6F6EC"><font color="#FF0000"><%=rs("bbs")%></font> 
      </td>
      </tr>
      
    <tr> 
      <td align="center" colspan="2" style="border-left: 1px solid #C9D8AD; border-right: 1px solid #C9D8AD; border-bottom: 1px solid #C9D8AD" bgcolor="#F6F6EC"> 
        <div align="center"><b><font color="#FF0000" style="font-size: 14px">修改成功！</font></b></div>
        </td>
      </tr>
    </table>

</div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -