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

📄 update_company.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT"%>
<%
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<title>公司资料更改</title>
</head>
<%
    companyname=session("company_name")
    set rs=server.createobject("adodb.recordset")
    sql="select * from GSCOTT.company_info_table where company_name='"&companyname&"'"
    rs.open sql,connstr,3,3
%>
<body topmargin="20">
<!-- #include file="pagetop.asp" -->
<div align="center"><center>
<form method="POST" action="update_company_sav.asp?companyname=<%=companyname%>">
<table width="550"  border="0" cellpadding="0" cellspacing="0" bgcolor="#F2F2F2">
  <tr>
    <td height="20" colspan="4" align="center" bgcolor="E4E2FE"><font size="-1">请输入修改信息</font></td>
    </tr>
  <tr>
    <td width="23%" height="20" align="right"><font size="-1">公司名称:</font></td>
    <td width="27%" height="20">
      <font size="-1"><%=rs("company_name")%> </font>   </td>
    <td width="23%"></td>
    <td width="27%"></td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1"> 执照号:</font></div></td>
    <td height="20"><font size="-1"><input name="idcard" type="text" id="idcard" maxlength="20" value="<%=rs("company_idcard")%>"></font>    </td>
    <td><div align="right"><font size="-1">联系人:</font></div></td>
    <td><font size="-1"><input name="linkman" type="text" id="linkman" value="<%=rs("company_linkman")%>" maxlength="10"> </font>   </td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1"> 所在省份:</font></div></td>
    <td height="20"><font size="-1"><input name="province" type="text" id="province" maxlength="20" value="<%=rs("company_province")%>"></font></td>
    <td height="20"><div align="right"> <font size="-1">所在城市:</font></div></td>
    <td><font size="-1"><input name="city" type="text" id="city" maxlength="20" value="<%=rs("company_city")%>"> </font>   </td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1"> 公司地址:</font></div></td>
    <td height="20"><font size="-1"><input name="address" type="text" id="address" maxlength="100" value="<%=rs("company_address")%>">  </font>  </td>
    <td height="20"><div align="right"><font size="-1">邮编: </font></div></td>
    <td><font size="-1"><input name="zipcode" type="text" id="zipcode" maxlength="10" value="<%=rs("company_zipcode")%>"></font></td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1">联系电话:</font></div></td>
    <td height="20"><font size="-1"><input name="telphone" type="text" id="telphone" maxlength="15" value="<%=rs("company_telphone")%>"></font></td>
    <td height="20"><div align="right"><font size="-1">联系人手机:</font></div></td>
    <td><font size="-1"><input name="lmmobilephone" type="text" id="lmmobilephone" maxlength="15" value="<%=rs("company_lmmobilephone")%>"></font></td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1">联系人Email:</font></div></td>
    <td height="20"><font size="-1"><input name="lmemail" type="text" id="lmemail" maxlength="50" value="<%=rs("company_lmemail")%>"></font></td>
    <td height="20"><div align="right"><font size="-1">传真:</font></div></td>
    <td><font size="-1">
      <input name="fax" type="text" id="fax" maxlength="15" value="<%=rs("company_fax")%>">
    </font></td>
  </tr>
  <tr>
    <td height="20" align="right"><font size="-1">注册时间:</font></td>
    <td height="20"><font size="-1"><%=rs("company_date")%></font></td>
    <td height="20">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td height="20"><div align="right"><font size="-1">备注(可不填):</font></div></td>
    <td colspan="3"><font size="-1"><textarea name="Remark" cols="60" rows="10" id="Remark"><%=rs("company_remark")%></textarea></font></td>
  </tr>
  <tr align="center">
    <td height="30" colspan="4"><font size="-1"><input type="submit" name="Submit" value="确定"></font>
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <font size="-1"><input name="Reset" type="reset" id="Reset2" value="重置"></font></td>
  </tr>
</table>
</form>
</center></div>
<!-- #include file="pagefooter.html" -->
</body>
</html>

⌨️ 快捷键说明

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