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

📄 ywyzl_zldy_1.asp

📁 asp+Access开发的客户资源管理系统,用户名:admin,密码:
💻 ASP
字号:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="other/customer.css">


</head>

<%
'与数据库建立连接
id=request.querystring("id")
id1=clng(id)
set conn=server.createobject("adodb.connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};pwd=webcool_2000;dbq=" & Server.MapPath("../database/customer.mdb")
set rs=conn.execute("select * from worker where id="&id1)
%>
<body bgcolor="#999999" text="#000000">
<table width="620" border="0" height="877" align="center">
  <tr>
    <td>
      <table width="98%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#000000" class="big">
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">姓  名</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("name")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center"> 
              <p class="big_b">简  写</p>
            </div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("search")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">性  别</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("sex")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center">民  族</div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("nation")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" valign="top">&nbsp; 
            <div align="center"> 
              <p class="big_b">出生年月</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("birthday")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center">性  质</div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("gongneng")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">身份证号码</p>
            </div>
          </td>
          <td colspan="3" height="36" class="big"><%=rs("card")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">文化程度</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("degree")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center"> 
              <p>专  业</p>
            </div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("special")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">毕业院校</p>
            </div>
          </td>
          <td colspan="3" height="36" class="big"><%=rs("school")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">现任职位</p>
            </div>
          </td>
          <td colspan="3" height="36" class="big"><%=rs("funcion")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">手  机</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("mobile")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center"> 
              <p>联系电话</p>
            </div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("telephone")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="36" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">传  呼</p>
            </div>
          </td>
          <td width="25%" height="36" class="big"><%=rs("call")%></td>
          <td width="25%" height="36" class="big_b"> 
            <div align="center">邮  编</div>
          </td>
          <td width="23%" height="36" class="big"><%=rs("post")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="40" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">邮件地址</p>
            </div>
          </td>
          <td colspan="3" height="40" class="big"><%=rs("email")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="40" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">OICQ</p>
            </div>
          </td>
          <td colspan="3" height="40" class="big"><%=rs("oicq")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="37" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">网   址</p>
            </div>
          </td>
          <td colspan="3" height="37" class="big"><%=rs("http")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="43" align="center" valign="middle"> 
            <div align="center"> 
              <p class="big_b">家庭地址</p>
            </div>
          </td>
          <td colspan="3" height="43" class="big"><%=rs("address")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="27%" height="321"> 
            <div align="center"> 
              <p class="big_b">个人简介</p>
            </div>
          </td>
          <td colspan="3" height="321" class="big" valign="top"><%=rs("introduce")%></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>
  <script language="JavaScript">
<!-- Begin
if (window.print) {
document.write('<center><form><input type=button name=print style="border-width:1px;  border-style:solid;" value="打印" '
+ 'onClick="javascript:window.print()"></form></center>');
}
// End -->
</script>
 
<%set conn=nothing%>

<html></html>

⌨️ 快捷键说明

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