ziliao.asp
来自「本网上拍卖系统选用ASP + SQL Server进行开发, 是一个基于Brow」· ASP 代码 · 共 141 行
ASP
141 行
<%
SqlDatabaseName = "paimai" '数据库名
SqlUsername = "sa" '用户名
SqlPassword = " " '用户密码
Dim Conn,ConnStr
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider = Sqloledb; Persist Security Info=false; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & ";"
Conn.Open ConnStr
sql="select * from [user] where userid='"&session("userid")&"';"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,3,3
%>
<form action="ziliaoasp.asp" method="post">
<table border="0" width="675" id="table1" height="480" bgcolor="#C0C0C0">
<tr>
<td height="9" colspan="3" align="left" valign="top">
<font size="5">
<font color="#FF0000" face="华文中宋">我的注册资料</font> </font></td>
</tr>
<tr>
<td height="9" colspan="3" align="center" valign="top">
<font color="#FF0000" face="华文中宋">带*的为必填项！</font></td>
</tr>
<tr>
<td width="86%" align="center" valign="top" colspan="3"> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">用户名：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="usersn" value="<%=rs("usersn")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* 用户登录时所用</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">姓 名：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="username" value="<%=rs("username")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* 真实姓名</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">密 码：</font></td>
<td width="31%" align="center" valign="top">
<input type="password" style="WIDTH: 184px; HEIGHT: 21px" name="userpwd" value="<%=rs("userpwd")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">*
6位以上</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">确认密码：</font></td>
<td width="31%" align="center" valign="top">
<input type="password" style="WIDTH: 184px; HEIGHT: 21px" name="userrpwd" value="<%=rs("userrpwd")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">*
6位以上与上面相同</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">性 别：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="usersex" value="<%=rs("usersex")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* </font> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">家庭地址：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="useraddr" value="<%=rs("useraddr")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">*
现在的居住地址</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">注册Email：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="useremail" value="<%=rs("useremail")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">*
请用常用邮箱</font></td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">邮政编码：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="userzip" value="<%=rs("userzip")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* </font> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">身份证号：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="usercred" value="<%=rs("usercred")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* </font> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">电 话：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="usertel" value="<%=rs("usertel")%>"></td>
<td width="47%" align="left" valign="top">
<font color="#FF0000" size="1" face="华文中宋">* </font> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">移动电话：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="usermobile" value="<%=rs("usermobile")%>"></td>
<td width="47%" align="left" valign="top"> </td>
</tr>
<tr>
<td width="19%" align="right" valign="top">
<font color="#FF0000" size="2" face="华文中宋">QQ 号 码：</font></td>
<td width="31%" align="center" valign="top">
<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="userqq" value="<%=rs("userqq")%>"></td>
<td width="47%" align="left" valign="top"> </td>
</tr>
<tr>
<td width="86%" align="center" valign="top" colspan="3"> </td>
</tr>
<tr>
<td width="19%" align="center" valign="top"> </td>
<td width="31%" align="center" valign="top">
<input type="submit" value="修改" name="submit"></td>
<td width="47%" align="center" valign="top"> </td>
</tr>
</table>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?