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

📄 update_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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改客户信息</title>
</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>
<form action="update_customer_sav.asp?id=<%=request.querystring("id")%>" method="post">
<table width="700"  border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" colspan="2">请输入客户信息的修改信息:</td>
    <td width="20%" align="right">&nbsp;</td>
    <td width="40%">&nbsp;</td>
  </tr>
  <tr>
    <td width="20%" height="30" align="right">客户ID:</td>
    <td width="20%" height="30">
      <%=rs("user_id")%>    </td>
    <td colspan="2" align="right">&nbsp;</td>
    </tr>
  <tr>
    <td height="30"><div align="right"> 客户姓名:</div></td>
    <td height="30"><input name="username" type="text" id="username" maxlength="8" value="<%=rs("user_name")%>">    </td>
    <td><div align="right">身份证号:</div></td>
    <td><input name="IDcard" type="text" id="IDcard" value="<%=rs("user_idcard")%>" maxlength="18">    </td>
  </tr>
  <tr>
    <td height="30"><div align="right"> 所在省份:</div></td>
    <td height="30"><input name="province" type="text" id="province" maxlength="20" value="<%=rs("user_province")%>"></td>
    <td><div align="right"> 所在城市:</div></td>
    <td><input name="city" type="text" id="city" maxlength="20" value="<%=rs("user_city")%>">    </td>
  </tr>
  <tr>
    <td height="30"><div align="right"> 客户地址:</div></td>
    <td height="30"><input name="address" type="text" id="address" maxlength="100" value="<%=rs("user_address")%>">    </td>
    <td><div align="right">邮编: </div></td>
    <td><input name="zipcode" type="text" id="zipcode" maxlength="10" value="<%=rs("user_zipcode")%>"></td>
  </tr>
  <tr>
    <td height="30"><div align="right">联系电话:</div></td>
    <td height="30"><input name="telphone" type="text" id="telphone" maxlength="15" value="<%=rs("user_telphone")%>"></td>
    <td><div align="right">手机:</div></td>
    <td><input name="mobilephone" type="text" id="mobilephone" maxlength="15" value="<%=rs("user_mobilephone")%>"></td>
  </tr>
  <tr>
    <td height="30"><div align="right">Email:</div></td>
    <td height="30"><input name="email" type="text" id="email" maxlength="50" value="<%=rs("user_email")%>"></td>
    <td><div align="right">注册时间:</div></td>
    <td><%=rs("user_date")%></td>
  </tr>
  <tr>
    <td><div align="right">备注(可不填):</div></td>
    <td colspan="3"><textarea name="Remark" cols="60" rows="10" id="Remark"><%=rs("user_remark")%></textarea></td>
  </tr>
  <tr align="center">
    <td height="30" colspan="4"><input type="submit" name="Submit" value="确定">
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="Reset" type="reset" id="Reset2" value="重置"></td>
  </tr>
  <tr align="right">
    <td height="20" colspan="4"><a href="javascript:history.go(-1)">返回上一页</a></td>
    </tr>
</table>
</form>
</center>
</div>
</body>
</html>

⌨️ 快捷键说明

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