⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 update_pro_certain.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" %>
<html>
<%
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改产品信息</title>
<style type="text/css">
<!--
.style1 {
	font-size: 24px;
	font-family: "黑体";
}
-->
</style>
</head>

<body>
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select * from GSCOTT.product_info_table where product_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
%>
<div align="center"><center>
<form action="update_pro_sav.asp?id=<%=request.querystring("id")%>" method="post" name="myform">
<table width="582" height="900" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr align="center" valign="middle">
    <td height="73" colspan="2"><span class="style1">请输入修改的信息</span></td>
    </tr>
  <tr>
    <td width="206" height="27" align="right" valign="middle">产品型号:</td>
    <td width="376" align="center" valign="middle">
      <input name="Num" type="text" id="Num" value="<%=rs("product_kindnum")%>">    </td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle">产品类别:</td>
    <td align="center" valign="middle"><input name="kind" type="text" id="kind" value="<%=rs("product_kind")%>" maxlength="8">    </td>
  </tr>
  <tr>
    <td height="27" valign="middle"><div align="right"> 产品名称: </div></td>
    <td align="center" valign="middle"><input name="name1" type="text" id="name1" value="<%=rs("product_name")%>" maxlength="8">    </td>
    </tr>
  <tr>
    <td height="27" valign="middle"><div align="right">产品燃烧能力:</div></td>
    <td align="center" valign="middle"><input name="burn_ability" type="text" id="burn_ability" value="<%=rs("product_burn_ability")%>" maxlength="15">    </td>
  </tr>
  <tr>
    <td height="27" valign="middle"><div align="right"> 产品适用介质:
        
  </div></td>
    <td align="center" valign="middle"><input name="media" type="text" id="media" value="<%=rs("product_media_inuse")%>" maxlength="20">    </td>
    </tr>
  <tr>
    <td height="27" valign="middle"><div align="right">产品适应风温: </div></td>
    <td align="center" valign="middle"><input name="temp" type="text" id="temp" value="<%=rs("product_temp_inuse")%>" maxlength="10"></td>
  </tr>
  <tr>
    <td height="27" valign="middle"><div align="right"> 保修期: </div></td>
    <td align="center" valign="middle"><input name="RepairTime" type="text" id="RepairTime" value="<%=rs("product_repairtime")%>" maxlength="10">    </td>
    </tr>
  <tr>
    <td height="27" valign="middle"><div align="right">价格: </div></td>
    <td align="center" valign="middle"><input name="Price" type="text" id="Price" value="<%=rs("product_price")%>" maxlength="8"></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle">添加时间:</td>
    <td align="center" valign="middle"><%=rs("product_time")%></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle">销售数量:</td>
    <td align="center" valign="middle"><%=rs("product_salenum")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle">产品图片:</td>
    <td align="center" valign="middle"><a href="<%=rs("product_picpath")%>" target="_blank" title="图片预览">图片预览</a></td>
  </tr>
  <tr align="center" valign="middle">
    <td height="27" colspan="2"><input name="PicPath" type="text" id="PicPath" value="<%=rs("product_picpath")%>">
	  <input name="Pic" type="button" id="Pic" value="上传图片" onClick="window.open('upload_pic.asp?formname=myform&editname=PicPath&uppath=propic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">     
      (可不填)</td>
  </tr>
  <tr>
    <td height="182" valign="top"><div align="right">备注(可不填):</div></td>
    <td valign="top"><textarea name="Remark" cols="40" rows="10" id="Remark"><%=rs("product_remark")%></textarea></td>
  </tr>
  <tr align="center">
    <td height="24" colspan="2" valign="top"><input type="submit" name="Submit" value="修改">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="Reset" type="reset" id="Reset" value="重置"></td>
    </tr>
  <tr valign="middle">
    <td height="42" colspan="2" align="right"><a href="javascript:history.go(-1)">返回上一页</a></td>
    </tr>
  <tr>
    <td height="255">&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>
</form>
</center></div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -