pmpxgc.asp

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

<%

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

	
	if request("action")="mod" then
	sql="select * from [ppm] where pdtid='"&request("pdtid")&"'"
	set rs=Server.CreateObject("ADODB.Recordset")
	rs.open sql,conn,1,1
	'response.write rs("pdtid")
	'response.end
	session("pdtid")=rs("pdtid")
	end if

	
%>
<form action="pmpxgcasp.asp" method="post">
<table border="0" width="675" id="table1" height="510" bgcolor="#C0C0C0">
			<tr>
				<td height="9" colspan="3" align="left" valign="top">
				<font size="5" color="#FF0000">&nbsp;&nbsp;&nbsp; 拍卖方式发布宝贝 </font></td>
			</tr>
			<tr>
				<td height="9" colspan="3" align="center" valign="top">
				<font color="#FF0000">带*的为必填项！</font></td>
			</tr>
			<tr>
				<td width="86%" align="center" valign="top" colspan="3">　</td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝名称：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtname" value="<%=rs("pdtname")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 要出售的商品名称</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝主人：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtowner" value="<%=rs("pdtowner")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的所有者</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝描述：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtdesc" value="<%=rs("pdtdesc")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的简要描述,最多50个字</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝图片：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtimage" value="<%=rs("pdtimage")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品图片的网络地址</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2" >宝贝起拍时间：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtstart" value="<% Response.write year(now()) & "." & month(now()) & "." & day(now())%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 
				输入格式：(年.月.日)如(2007.01.01)</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝结束时间：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtend" value="<%=rs("pdtend")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 
				输入格式：(年.月.日)如(2007.01.01)</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝起拍价格：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtstartpri" value="<%=rs("pdtstartpri")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 宝贝拍卖的底价</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝加幅价格：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtadd" value="<%=rs("pdtadd")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 宝贝的加幅价格</font></td>
			</tr>
			<tr>
				<td width="21%" align="right" valign="top">
				<font color="#FF0000" face="华文中宋" size="2">宝贝新旧：</font></td>
				<td width="29%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtoldnew" value="<%=rs("pdtoldnew")%>"></td>
				<td width="48%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的新旧(全新,二手)</font></td>
			</tr>
			<tr>
				<td width="86%" align="center" valign="top" colspan="3">　</td>
			</tr>
			<tr>
				<td width="21%" align="center" valign="top">　</td>
				<td width="29%" align="center" valign="top">
				
				<input type="submit" value="修改" name="submit"></td>
				<td width="48%" align="center" valign="top">　</td>
			</tr>
		</table>