userinfo.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" bgcolor="E4E2FE" align="center"><font size="-1" color="#0000FF">客户-Zone</font></td>
</tr>
<tr> 
  <td> 
  <div align=center> 
      <% if session("user_name")="" then %>
      <table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
      <form name="userlogin" method="post" action="check_user_login.asp">
      <tr> 
        <td height="8"></td>
      </tr>
      <tr> 
        <td align="center"><font size="-1">用户名： 
            <input type="text" name="userid" 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="10">
        </font></td>
      </tr>
      <tr> 
        <td align="center"><font size="-1">密　码： 
            <input type="password" name="userpw" 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_customer.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>
	  <%
	    dim rs,sql
		set rs=server.CreateObject("adodb.recordset")
		sql="select user_id, user_address, user_email, user_telphone from GSCOTT.user_info_table where user_id='"&session("user_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("user_id")%></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("user_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">E-MAIL：</font></td>
        <td width="100"><font size="-1"><%=rs("user_email")%></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("user_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>