owner3c.asp

本网上拍卖系统选用ASP + SQL Server进行开发, 是一个基于Brower/ Server (浏览器/ 服务器) 并采用C2C (Customer to Customer 即个人——个人)运

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		
<table border="0" width="675" height="480" id="table3">


	<tr>
		<td bgcolor="#C0C0C0" align="center" valign="top"> 
      <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="799AE1" id="table4" height="352">
     
 <%
     
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='"&request("userid")&"';"
	set rs=Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,1	'以写入方式打开
	if rs.eof and rs.bof then
	Response.Write "<p align='center' class='contents'> 对不起，用户不存在！</p>"
else

	'session("pdtid")=rs("pdtid")
	'session("pdtykj")=rs("pdtykj")
%>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="94" height="52" align="right">
			<font color="#FF0000" size="1"><span style="font-family: 幼圆">用户名：</span></font></td>
			<td width="228" height="37"><font size="1" face="幼圆"><%=rs("usersn")%></font></td>
			<td width="97" height="37" align="right">
			<font color="#FF0000" size="1">
			<span style="font-family: 幼圆">&nbsp; 真实姓名：</span></font></td>
			<td width="230" height="37"><font size="1" face="幼圆"><%=rs("username")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="94" height="52" align="right">
			<font color="#FF0000" size="1">
			<span style="font-family: 幼圆">性别：</span></font></td>
			<td width="228" height="37"><font size="1" face="幼圆">　<%=rs("usersex")%></font></td>
			<td width="97" height="37" align="right">
			<font color="#FF0000" size="1"><span style="font-family: 幼圆">地址 
			：</span></font></td>
			<td width="230" height="37"><font size="1" face="幼圆">　<%=rs("useraddr")%></font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="94" height="52" align="right">
			<font color="#FF0000" size="1">
			<span lang="EN-US" style="font-family: 幼圆">Email：</span></font></td>
			<td width="228" height="52"><font size="1" face="幼圆">　<%=rs("useremail")%></font></td>
			<td width="97" height="52" align="right">
			<font color="#FF0000" size="1">
			<span style="font-family: 幼圆">邮政编码：</span></font></td>
			<td width="230" height="52"><font size="1" face="幼圆">　<%=rs("userzip")%></font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="94" height="53" align="right">
			<font color="#FF0000" size="1">
			<span style="font-family: 幼圆">身份证号：</span></font></td>
			<td width="228" height="53"><font size="1" face="幼圆"><%=rs("usercred")%>　</font></td>
			<td width="97" height="53" align="right">
			<font color="#FF0000" size="1"><span style="font-family: 幼圆">固定电话：</span></font></td>
			<td width="230" height="53"><font size="1" face="幼圆"><%=rs("usertel")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="94" height="51" align="right">
			<font color="#FF0000" size="1">
			<span style="font-family: 幼圆">移动电话：</span></font></td>
			<td width="228" height="51"><font size="1" face="幼圆">　<%=rs("usermobile")%></font></td>
			<td width="97" height="51" align="right">
			<font color="#FF0000" size="1">
			<span lang="EN-US" style="font-family: 幼圆">QQ：</span></font></td>
			<td width="230" height="51"><font size="1" face="幼圆">　<%=rs("userqq")%></font></td>
		</tr>
<%
end if
rs.close
set rs=nothing
%>
        <tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="83" colspan="4"><font color="#FF0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<b>&nbsp;<a href="mypsp.asp"><font color="#FF0000" size="2" face="幼圆"><span style="text-decoration: none">返回&gt;&gt;&gt;</span></font></a></b></font></td>
			<td height="83">　</td>
		</tr>


		</table>
		</td>
		 
	</tr>
	 
</table>