ykjpxgc.asp

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

<%

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 [pykj] 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  name="form"action="ykjpxgcasp.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="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝名称：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtname" value="<%=rs("pdtname")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 要出售的商品名称</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝主人：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtowner" value="<%=rs("pdtowner")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的所有者</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝描述：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtdesc" value="<%=rs("pdtdesc")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的简要描述,最多50个字</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝图片：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtimage" value="<%=rs("pdtimage")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品图片的网络地址</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝新旧：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtoldnew" value="<%=rs("pdtoldnew")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的新旧(全新,二手)</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝价格：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtykj" value="<%=rs("pdtykj")%>"></td>
				<td width="53%" align="left" valign="top">
				<font color="#FF0000" size="1">* 商品的价格</font></td>
			</tr>
			<tr>
				<td width="15%" align="right" valign="top">
				<font color="#FF0000" size="2" face="华文中宋">宝贝数量：</font></td>
				<td width="30%" align="center" valign="top">
				<input type="text" style="WIDTH: 184px; HEIGHT: 21px" name="pdtbuyam" value="<%=rs("pdtbuyam")%>"></td>
				<td width="53%" 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="15%" align="center" valign="top">　</td>
				<td width="30%" align="center" valign="top">
			
				<input type="submit" value="修改" name="submit"></td>
				<td width="53%" align="center" valign="top">　</td>
			</tr>
		</table>