companyinfo.asp

oracle9i程序事例集

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<div align="center"><center>

<table width="180" border="0" cellpadding="0" cellspacing="0">

<tr>
  <td height="18" align="center" bgcolor="E4E2FE"><font size="-1" color="#0000FF">公司-Zone</font></td>
</tr>
<tr> 
  <td> 
  <div align=center> 
      <% if session("company_name")="" then %>
      <table width="180" border="0" cellspacing="1" cellpadding="1" align="center">
      <form name="companylogin" method="post" action="check_company_login.asp">
      <tr> 
        <td height="8" colspan="3"></td>
      </tr>
      <tr> 
        <td align="center"><font size="-1">公司名称： 
            <input type="text" name="companyname" style="BORDER-RIGHT: #ffffff 1px groove; BORDER-TOP: #ffffff 1px groove; BORDER-LEFT: #ffffff 1px groove; COLOR: #333333; BORDER-BOTTOM: #ffffff 1px groove; HEIGHT: 18px; BACKGROUND-COLOR: #ffffff"; size="10" maxlength="50">
        </font></td>
      </tr>
      <tr> 
        <td align="center"><font size="-1">密　码： &nbsp;
            <input type="password" name="companypw" size="10" maxlength="16"style="BORDER-RIGHT: #ffffff 1px groove; BORDER-TOP: #ffffff 1px groove; BORDER-LEFT: #ffffff 1px groove; COLOR: #333333; BORDER-BOTTOM: #ffffff 1px groove; HEIGHT: 18px; BACKGROUND-COLOR: #ffffff"; >
        </font></td>
      </tr>
      <tr> 
        <td align="center" height="38"> 
          <font size="-1">
          <input name="imageField" type="image" src="../img/login_bt_login.gif" width="45" height="19" border="0" onFocus="this.blur()">
          &nbsp;&nbsp;<a href="reg_company.asp"><img src="../img/login_bt_zc.gif" width="45" height="19" border="0"></a> 
          </font>
		</td>
      </tr>
      </form>
      </table>
      <% else %>
      <table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
      <tr> 
        <td height="8" colspan="3"></td>
      </tr>
	  <%
	   	set rs=server.CreateObject("adodb.recordset")
		sql="select company_name, company_address, company_linkman, company_telphone from GSCOTT.company_info_table where company_name='"&session("company_name")&"'"
		rs.open sql,connstr
	  %>
	  <tr> 
        <td align="right" width="13"><font size="-1"><img src="../img/user_info_user.gif" width="13" height="13"></font></td>
        <td align="right" width="67"><font size="-1">公司名称：</font></td>
        <td width="100"><font size="-1"><%=rs("company_name")%></font></td>
      </tr>
      <tr> 
        <td width="13" align="right"><font size="-1"><img src="../img/user_info_add.gif" width="13" height="13"></font></td>
        <td width="67" align="right"><font size="-1">公司地址：</font></td>
        <td width="100"><font size="-1"><%=rs("company_address")%></font></td>
      </tr>
      <tr>
        <td width="13" align="right"><font size="-1"><img src="../img/user_info_email.gif" width="13" height="13"></font></td>
        <td width="67" align="right"><font size="-1">联系人：</font></td>
        <td width="100"><font size="-1"><%=rs("company_linkman")%></font></td>
      </tr>
      <tr> 
        <td width="13" align="right"><font size="-1"><img src="../img/user_info_tel.gif" width="13" height="13"></font></td>
        <td width="67" align="right"><font size="-1">联系电话：</font></td>
        <td width="100"><font size="-1"><%=rs("company_telphone")%></font></td>
      </tr>
      <tr> 
        <td height="8" colspan="3"></td>
      </tr>
      </table>
      <%
	    rs.close
	    set rs=nothing
		end if
      %>
  </div>
  </td>
  </tr>
</table>
</center>
</div>