gmykjc.asp

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

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		<form action="gmykjcasp.asp" method="post">
<table border="0" width="675" height="510" 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 [pykj] where pdtid='"&request("pdtid")&"';"
	set rs=Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,1	'以写入方式打开
	session("pdtid")=rs("pdtid")
	session("pdtykj")=rs("pdtykj")
	
	session("pdtname")=rs("pdtname")
	session("pdtowner")=rs("pdtowner")
	session("pdtdesc")=rs("pdtdesc")
	session("pdtoldnew")=rs("pdtoldnew")
%>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="192" height="207" rowspan="4"><font size="1" face="幼圆"><img src=<%=rs("pdtimage")%> width=192 height=207  ></font></td>
			<td width="103" height="37">
			<div align="center"><font color="#FF0000" size="1" face="幼圆">商品名称</font></div></td>
			<td width="357" height="37" colspan="3"><font size="1" face="幼圆"><%=rs("pdtname")%></font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="103" height="37">
			<font color="#FF0000" size="1" face="幼圆">商品描述</font></td>
			<td width="357" height="37" colspan="3"><font size="1" face="幼圆"><%=rs("pdtdesc")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="103" height="39">
			<font color="#FF0000" size="1" face="幼圆">商品价格</font></td>
			<td width="110" height="39"><font face="幼圆"><font size="1"><%=rs("pdtykj")%></font><font size="1" color="#FF0000">　元</font></font></td>
			<td width="81" height="39"><font color="#FF0000" size="1" face="幼圆">商品新旧</font></td>
			<td width="160" height="39"><font size="1" face="幼圆"><%=rs("pdtoldnew")%>　</font></td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td width="103" height="40">
			<font color="#FF0000" size="1" face="幼圆">商品数量</font></td>
			<td width="110" height="40"><font face="幼圆"><font size="1"><%=rs("pdtbuyam")%></font><font size="1" color="#FF0000">　个</font></font></td>
			<td width="81" height="40"><font color="#FF0000" size="1" face="幼圆">所有者</font></td>
			<td width="160" height="40"><a href="owner1.asp?pdtowner=<%=rs("pdtowner")%>">
			<font size="1" face="幼圆"><%=rs("pdtowner")%></font></td>
		</tr>
<%
rs.close
set rs=nothing
%>
        <tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="8" colspan="5">　</td>
			<td height="120" rowspan="4">　</td>
		</tr>


		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="8" colspan="5">
				<p><font face="幼圆" size="1" color="#FF0000"><input type="text" name="bidamount" size="20">　　购买数量</font></p>
			
			</td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="31" colspan="5">
				<p><font face="幼圆" size="1" color="#FF0000"><input type="text" name="bidtime" size="20" value="<% Response.write year(now()) & "." & month(now()) & "." & day(now())%>">　　购买时间　</font></p>
			
			</td>
		</tr>
		<tr height="20" bgcolor="#FFFFFF" align="center">
			<td height="48" colspan="5" rowspan="2">
			<input type="submit" value="购买" name="submit" ></td>
		</tr>
		
		</table>
		</td>
		 
	</tr>
	 
</table>