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

📄 del_customer_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>
<title>确认删除客户信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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 * from GSCOTT.user_info_table where user_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
%>
<div align="center"><center>
<table border="0" height="450" width="552" cellspacing="0" cellpadding="0">
  <!--DWLayoutTable-->
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="77" colspan="3" align="center" valign="middle"><font color="#000000" size="5" face="黑体"><strong>您是否要删除下面的客户信息</strong></font></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td width="205" height="27" align="right" valign="middle" class="bd_font_size">客户ID:</td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_id")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" valign="middle" class="bd_font_size"><div align="right"> 客户姓名:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_name")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">身份证号:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_idcard")%></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right"> 所在省份:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_province")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right"> 所在城市:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_city")%></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right"> 客户地址:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_address")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">邮编: </div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_zipcode")%></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">联系电话:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_telphone")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">手机:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_mobilephone")%></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">Email:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_email")%></td>
    </tr>
  <tr align="center" valign="middle" bgcolor="#FFFFFF">
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">注册时间:</div></td>
    <td colspan="2" valign="middle" class="bd_font_size"><%=rs("user_date")%></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" class="bd_font_size"><div align="right">备注:</div></td>
    <td colspan="2" align="center" valign="middle" class="bd_font_size"><%=rs("user_remark")%></td>
    </tr>
  <tr>
    <td height="44" colspan="2" align="right" valign="middle" class="bd_font_size"><a href=del_customer_sav.asp?id=<%=request.QueryString("id")%>>确定删除</a>&nbsp;&nbsp;	</td>
	<td width="287" align="left" valign="middle" class="bd_font_size">&nbsp;&nbsp;<a href='javascript:history.go(-1)'>返回上一页</a></td>
    </tr>
  <tr>
    <td height="5"></td>
    <td width="60"></td>
    <td></td>
  </tr>
  </table>
<% rs.close
   set rs=nothing %>
</center>
</div>
</body>
</html>

⌨️ 快捷键说明

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