📄 del_pro_sav.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-weight: bold;
	font-family: "黑体";
}
-->
</style>
<link href="../../Css/bd_font_size.css" rel="stylesheet" type="text/css">
</head>

<body background="../img/updatebg.gif">
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select product_kindnum, product_isdel from GSCOTT.product_info_table where product_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
  product=rs("product_kindnum")
  rs("product_isdel")="y"
  rs.update
  rs.close
  set rs=nothing
%>
<div align="center"><center>
<table width="582" border="0" cellspacing="0" cellpadding="0">
  <!--DWLayoutTable-->
  <tr align="center" bgcolor="#808000">
    <td height="77" colspan="3" align="center" valign="middle"><span class="style1">商品<%=product%>已经删除</span></td>
    </tr>
  <tr align="center">
    <td width="179" height="20" align="right" valign="top" bgcolor="#DDDD00" class="bd_font_size"><a href="all_pro.asp">浏览全部商品信息</a></td>
    <td width="225" align="center" valign="top" bgcolor="#DDDD00" class="bd_font_size"><a href="update_pro.asp">继续删除</a></td>
    <td width="178" align="left" valign="top" bgcolor="#DDDD00" class="bd_font_size"><a href="../index.asp">返回主页</a></td>
  </tr>
</table>
</center></div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -