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

📄 khzl_zldy_com.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 company where id="&id1)
%>
<body bgcolor="#999999" text="#000000">
<table width="620" height="877" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
      <table width="100%" border="1" bordercolor="#000000" cellpadding="0" cellspacing="0">
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">公司简称:</td>
          <td width="28%" height="30" class="big"><%=rs("index")%></td>
          <td width="21%" height="30" align="center" class="big_b"> 索引码:</td>
          <td width="31%" height="30" class="big"><%=rs("search")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">公司电话:</td>
          <td width="28%" height="30" class="big"><%=rs("comtel")%></td>
          <td width="21%" height="30" align="center" class="big_b">公司传真:</td>
          <td width="31%" height="30" class="big"><%=rs("comfax")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">法人代表:</td>
          <td colspan="3" height="30" class="big"><%=rs("comman")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">邮件地址:</td>
          <td colspan="3" height="30" class="big"><%=rs("post")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">邮  编:</td>
          <td width="28%" height="30" class="big"><%=rs("post")%></td>
          <td width="21%" height="30" align="center" class="big_b">经营范围:</td>
          <td width="31%" height="30" class="big"><%=rs("fanwei")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">开户银行:</td>
          <td colspan="3" height="30" class="big"><%=rs("bank")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">银行帐号:</td>
          <td colspan="3" height="30" class="big"><%=rs("bankid")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">税  号:</td>
          <td colspan="3" height="30" class="big"><%=rs("tax")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="29" align="center" class="big_b">网  址:</td>
          <td colspan="3" height="29" class="big"><%=rs("http")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">公司地址:</td>
          <td colspan="3" height="30" class="big"><%=rs("address")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">乘车路线:</td>
          <td colspan="3" height="30" class="big"><%=rs("road")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">公司性质:</td>
          <td width="28%" height="30" class="big"><%=rs("state")%></td>
          <td width="21%" height="30" align="center" class="big_b">年销售额:</td>
          <td width="31%" height="30" class="big"><%=rs("xiaoshou")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="30" align="center" class="big_b">公司全称:</td>
          <td colspan="3" height="30" class="big"><%=rs("allname")%></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="20%" height="494" valign="top" align="center">
            <p>&nbsp;</p>
            <p class="big_b">备  注:</p>
          </td>
          <td colspan="3" height="494" class="big" valign="top"><%=rs("demo")%></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>

<%'=关闭数据库============================

conn.close'关闭数据库
set conn=nothing
%> 


<html></html>

⌨️ 快捷键说明

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