📄 changeuserinfo.asp
字号:
<%@ language="vbscript" %>
<%
if request("username")="" or request("password")="" then
response.write "fill username and password!"
response.write "<a href='changeuserinfo.htm'>try agan!<a>"
response.end
else
set conn=server.createObject("ADODB.Connection")
dbpath=server.mappath("club.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs=server.createobject("ADODB.Recordset")
sql="select * from user_info where username='"&trim(request("username"))&"' and password='"&trim(request("password"))&"' "
rs.open sql,conn
if rs.bof and rs.eof then
response.write "can't find you?"
response.write "<a href='changeuserinfo.htm'>try again!<a>"
rs.close
conn.close
set rs=nothing
set conn=nothing
response.end
else
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<meta name="ProgId" content="中国人民">
<title>用户信息修改</title>
<link rel="stylesheet" href="club.css">
<style type="text/css">
<!--
.botton {font-size: 12px; background-color: #FFFFF8}
-->
</style>
<script language=javascript>
function check()
{
var ff=document.yjupdate
if(ff.password.value.length<4)
{
alert("密码长度必须大于三位！")
ff.password.focus()
return false;
}
if(ff.password.value!=ff.verpsw.value)
{
alert("两次输入的密码不一样哦！");
ff.password.focus();
return false;
}
if(ff.yborn.value.length>0||ff.mborn.value.length>0||ff.dborn.value.length>0)
{
var mmy=parseInt(ff.yborn.value);
var mmm=parseInt(ff.mborn.value);
var mmd=parseInt(ff.dborn.value);
if(mmy.length<=0||mmy.length<4||isNaN(mmy)||mmy>2000||mmy<1900)
{
alert("出生年份有误！请您检查是否为以下情况：\r\n\n1.录入了全角数字！\r\n2.位数不足四位！\r\n3.录入了其它非数字字符！\r\n4.年份超出正常范围！\r\n5.未填写年份！\r\n\n请核查后更正！");
ff.yborn.focus();
return false;
}
if(mmm.length<=1||isNaN(mmm)||mmm<1||mmm>12)
{
alert("出生月份有误！请您检查是否为以下情况：\r\n\n1.录入了全角数字！\r\n2.月份超出了范围！\r\n3.录入了其它非数字字符！\r\n4.未填写月份！\r\n\n请核查后更正！");
ff.mborn.focus();
return false;
}
if(mmd.length<=0||isNaN(mmd)||mmd<=0||mmd>31)
{
alert("出生日期有误！请您检查是否为以下情况：\r\n\n1.录入了全角字符！\r\n2.日期超出了范围！\r\n3.录入了其它非数字字符！\r\n4.未填写日期！\r\n\n请核查后更正！");
ff.dborn.focus();
return false;
}
var months=new Array("","一","二","三","四","五","六","七","八","九","十","十一","十二")
if((mmm==4||mmm==6||mmm==9||mmm==11)&&mmd>30)
{
alert(months[mmm]+"月份只有30天呀，请更正！OK？^&^");
ff.mborn.focus();
return false;
}
if(mmm==2)
{
if(!((mmy%4==0&&mmy%100!=0)||mmy%400==0)&&mmd>29)
{
alert("朋友："+mmy+"年"+"2月只有29天呀！请更正OK？^&^");
ff.dborn.focus();
return false;
}else if(mmd>28)
{
alert("朋友："+mmy+"年"+"2月只有28天呀！请更正OK？^&^");
ff.dborn.focus();
return false;
}
}
}
if(ff.city.value.length<=0)
{
alert("请输入所在城市！");
ff.city.focus();
return false;
}
if(ff.signs.value.length>120)
{
alert("签名长度己超过120字，请更正！");
document.yjupdate.signs.focus();
return false;
}
return true;
}
</script>
</head>
<body bgcolor="#FFFFF8">
<form method="POST" action="updateuserinfo.asp" name="yjupdate" onsubmit="return check()">
<input type="hidden" name="username" value="<%=request("username")%>">
<table
border="1" width="65%" borderColorDark="#FFFFFF" borderColorLight="#000000"
cellspacing="0" bgcolor="#CFCFFE" align="center">
<tr>
<td colspan="2" align="center" height="41"><font color="#006633">〖用户信息修改〗</font></td>
</tr>
<tr>
<td width="31%" align="right">〖用户名〗</td>
<td width="69%"><%=rs("username")%> </td>
</tr>
<tr>
<td width="31%" align="right">〖密码〗</td>
<td width="69%">
<input type="password" name="password" size="20"
value="<%=rs("password")%>" class="botton" maxlength="15">
</td>
</tr>
<tr>
<td width="31%" align="right" nowrap>〖校验密码〗</td>
<td width="69%">
<input type="password" name="verpsw" size="20" value="<%=rs("password")%>" class="botton" maxlength="15">
</td>
</tr>
<tr>
<td width="31%" align="right">〖E-mail〗</td>
<td width="69%">
<input type="text" name="email" size="30" value="<%=rs("email")%>" class="botton" maxlength="25">
</td>
</tr>
<tr>
<td width="31%" align="right">〖性别〗</td>
<td width="69%">
<select name="sex" size="1" class="botton">
<option value="先生">先生</option>
<option value="小姐">小姐</option>
<option value="不告诉你">不告诉你</option>
<option selected value="<%=rs("sex")%>"><%=rs("sex")%></option>
</select>
</td>
</tr>
<tr>
<td width="31%" align="right" nowrap>〖出生年月〗</td>
<td width="69%">
<input type="text" name="yborn" size="6" value="<%=year(rs("born"))%>" class="botton" maxlength="4">
年
<input type="text" name="mborn" value="<%=month(rs("born"))%>" size="4" maxlength="2" class="botton">
月
<input type="text" name="dborn" value="<%=day(rs("born"))%>" size="4" maxlength="2" class="botton">
日 </td>
</tr>
<tr>
<td width="31%" align="right">〖主页〗</td>
<td width="69%">
<input type="text" name="homepage" size="36" value="<%=rs("homepage")%>" class="botton" maxlength="30">
</td>
</tr>
<tr>
<td width="31%" align="right">〖城市〗</td>
<td width="69%">
<input type="text" name="city" size="20" value="<%=rs("city")%>" class="botton" maxlength="16">
</td>
</tr>
<tr>
<td width="31%" align="right">〖电话〗</td>
<td width="69%">
<input type="text" name="phone" size="26" value="<%=rs("phone")%>" class="botton" maxlength="20">
</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">◇签名（不能超过120字）</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">
<textarea rows="4" name="signs" cols="33" class="botton"><%=rs("signs")%></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="FFFFF8">
<input type="submit" value="更改" name="B1" class="botton">
</td>
</tr>
</table>
</form>
<%rs.close
conn.close
set rs=nothing
set conn=nothing
end if
end if%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -