sms客户资料(全部).asp

GIS系统初期,目前孩子啊处于测试阶段,好奇的朋友可以看看.

<!--#include file="conn.asp"-->
<!--#include file="session.asp"-->
<%Response.Buffer = True 
response.ContentType ="Application/msword" %>
<div align="center">
	<table border="0" width="100%" id="table1" cellpadding="0" style="border-collapse: collapse">
		<tr>
			<td height="30">
			<p align="center">
			<font color="#3131CE">
			<span style="font-size: 11pt; font-weight: 700; letter-spacing: 6pt">
			SMS-GIS客户信息列表</span></font></td>
		</tr>
	</table>
</div>
<table width="100%" height="0" border="0" cellpadding="0" cellspacing="0" align=center>
  <tr>
    <td align="center" valign="top" bgcolor="#F9F9F9">
    <table width="100%" height="37" border="0" cellpadding="0" bgcolor="#666666" style="border-collapse: collapse">
      <tr align="center">
        <td width="56" height="30"><font color="#FFFFFF">
		<span style="font-size: 10pt">序号</span></font></td>
        <td width="102"><font color="#FFFFFF"><span style="font-size: 10pt">姓 名</span></font></td>
        <td width="132"><font color="#FFFFFF"><span style="font-size: 10pt">生 日</span></font></td>
        <td width="158"><font color="#FFFFFF"><span style="font-size: 10pt">移动电话</span></font></td>
        <td width="106"><font color="#FFFFFF"><span style="font-size: 10pt">公司电话</span></font></td>
        <td width="100"><font color="#FFFFFF"><span style="font-size: 10pt">传 真</span></font></td>
        <td width="180"><font color="#FFFFFF"><span style="font-size: 10pt">公司名称</span></font></td>
        <td width="136"><font color="#FFFFFF"><span style="font-size: 10pt">公司网页</span></font></td>
      </tr>
<%
set rs=server.createobject("adodb.recordset")
sql="SELECT * from address_book order by person_sn" 

rs.Open sql,conn,1,1
if rs.EOF or rs.BOF then
response.write ("没有记录！")
end if
do while not rs.EOF
%>
      <tr align="center">
        <td width="56" bgcolor="#FFFFFF" height="35"><span style="font-size: 9pt"><%=rs("person_sn")%></span></td>
        <td width="102" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("full_name")%></span></td>
        <td width="132" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("birthday")%></span></td>
        <td width="158" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("mobile_tel")%></span></td>
        <td width="106" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("business_tel")%></span></td>
        <td width="100" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("business_fax")%></span></td>
        <td width="180" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("company")%></span></td>
        <td width="136" bgcolor="#FFFFFF"><span style="font-size: 9pt"><%=rs("corp_web")%></span></td>
      </tr>
<%rs.movenext
			 loop
			 rs.close
			 set rs = nothing
			 %>
    </table>
	</td>
  </tr>
</table>