admessc.asp

来自「本网上拍卖系统选用ASP + SQL Server进行开发, 是一个基于Brow」· ASP 代码 · 共 70 行

<%

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 [admin] where adminid='"&session("adminid")&"';"
	set rs=Server.CreateObject("ADODB.Recordset")
	
	rs.open sql,conn,3,3
	
%>

<form action="admesscasp.asp" method="post">
<table border="0" width="675" id="table1" height="480" bgcolor="#C0C0C0">
			<tr>
				<td height="44" colspan="3" align="left" valign="top" bgcolor="#008080">
				<font size="5">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font>
				<font size="4" face="华文中宋" color="#EF6622"> <b>管理员资料 </b> </font></td>
			</tr>
			<tr>
				<td height="19" colspan="3" align="center" valign="top">
				<font color="#FF0000">带*的为必填项！</font></td>
			</tr>
			<tr>
				<td width="86%" align="center" valign="top" colspan="3" height="18"></td>
			</tr>
			<tr>
				<td width="16%" align="right" height="44" bgcolor="#008080">
				<b><font size="2" face="华文中宋" color="#EF6622">用户名：</font></b></td>
				<td width="30%" align="center" height="44" bgcolor="#008000">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="adminn" value="<%=rs("adminn")%>"></td>
				<td width="51%" align="left" height="44" bgcolor="#008080">
				<b><font size="1" face="华文中宋" color="#EF6622">* 管理员登录时所用</font></b></td>
			</tr>
			<tr>
				<td width="16%" align="right" height="44" bgcolor="#008080">
				<b><font size="2" face="华文中宋" color="#EF6622">密&nbsp;&nbsp;&nbsp; 码：</font></b></td>
				<td width="30%" align="center" height="44" bgcolor="#008000">
				<input type="password" style="WIDTH: 184px; HEIGHT: 21px" name="adminpwd" value="<%=rs("adminpwd")%>"></td>
				<td width="51%" align="left" height="44" bgcolor="#008080"><b>
				<font size="1" face="华文中宋" color="#EF6622">* 
				6位以上</font></b></td>
			</tr>
			<tr>
				<td width="16%" align="right" height="53" bgcolor="#008080">
				<b><font size="2" face="华文中宋" color="#EF6622">确认密码：</font></b></td>
				<td width="30%" align="center" height="53" bgcolor="#008000">
				<input type="password" style="WIDTH: 184px; HEIGHT: 21px" name="adminrpwd" value="<%=rs("adminrpwd")%>"></td>
				<td width="51%" align="left" height="53" bgcolor="#008080"><b>
				<font size="1" face="华文中宋" color="#EF6622">* 
				6位以上与上面相同</font></b></td>
			</tr>
			<tr>
				<td width="86%" align="center" valign="top" colspan="3" height="59">　</td>
			</tr>
			<tr>
				<td width="16%" align="center" valign="top">　</td>
				<td width="30%" align="center" valign="top">
				<input type="submit" value="修改" name="submit"></td>
				<td width="51%" align="center" valign="top">　</td>
			</tr>
		</table>