📄 del_customer_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 {
	color: #000000;
	font-weight: bold;
	font-size: 24px;
	font-family: "黑体";
}
-->
</style>
<link href="../../Css/bd_font_size.css" rel="stylesheet" type="text/css">
</head>

<body class="bd_font_size">
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select user_id from GSCOTT.user_info_table where user_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
  user=rs(0)
  rs.delete
  rs.close
  set rs=nothing
%>
<div align="center"><center>
<table width="582" border="0" cellspacing="0" cellpadding="0">
  <!--DWLayoutTable-->
  <tr valign="middle" bgcolor="#808000">
    <td height="73" colspan="3" align="center"><span class="style1">客户<%=user%>信息已经删除</span></td>
  </tr>
  <tr>
    <td width="170" height="20" align="right" valign="top" bgcolor="#DDDD00"><a href="all_customer.asp">浏览全部客户信息</a></td>
    <td width="238" align="center" valign="top" bgcolor="#DDDD00"><a href="update_customer.asp">继续删除</a></td>
    <td width="174" align="left" valign="top" bgcolor="#DDDD00"><a href="../index.asp">返回主页</a></td>
  </tr>
</table>
</center></div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -