📄 jyzl_zldy_1.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 jiaoyi 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">
<tr bgcolor="#FFFFFF">
<td width="27%" height="48" class="big_b">
<div align="center">公司名称:</div>
</td>
<td width="25%" height="48" class="big"><%=rs("guester")%></td>
<td width="25%" height="48" class="big_b">
<div align="center">联 系 人:</div>
</td>
<td width="23%" height="48" class="big"><%=rs("linkman")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="27%" height="39" class="big_b">
<div align="center">交易项目:</div>
</td>
<td height="39" class="big"> <%=rs("program")%></td>
<td align="center" height="39" class="big_b">交易金额:</td>
<td height="39" class="big"><%=rs("money_1")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="27%" height="36" class="big_b">
<div align="center">编 号:</div>
</td>
<td width="25%" height="36" class="big"><%=rs("hetongbh")%></td>
<td width="25%" height="36" class="big_b">
<div align="center">业 务 员:</div>
</td>
<td width="23%" height="36" class="big"><%=rs("worker")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="27%" height="40" class="big_b">
<div align="center">签约时间:</div>
</td>
<td colspan="3" height="40" class="big"><%=rs("timer")%></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="672" class="big_b">
<div align="center"></div>
<div align="center"></div>
<div align="center">交易详情:</div>
</td>
<td colspan="3" height="672" class="big" valign="top"><%=rs("hetongnr")%></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 + -