开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 其他行业 > 查看源码
main.asp
资源名称：lyxxgl.rar　[点击查看]
上传用户：hnxqingdao
上传日期：2013-05-22
资源大小：1283k
文件大小：7k
源码类别：

其他行业

开发平台：

ASP/ASPX

main.asp：源码内容
  1. <!--#include file="../wy_trip_inc/wy_trip_fun.inc"-->
  2. <html>
  3. <head>
  4. <title>PTrip Server 2005 For 数据库课程设计
  5. </title>
  6. <META http-equiv=Content-Type content="text/html; charset=gb2312">
  7. <link rel="stylesheet" type="text/css" href="../wy_trip_css/wy_trip.css">
  8. </head>
  9. <script language="javascript" src="../wy_trip_js/wy_trip_check.js"></script>
  10. <script language="javascript" src="../wy_trip_js/wy_trip_inputcheck.js"></script>
  11. <%  
  12.     '获得公司关于信息
  13. aboutus=sqlshow("select * from trip_infor","aboutus")
  14. strlen=len(aboutus)
  15. if(strlen>=420)then
  16.     strlen=420
  17. strend="... ..."
  18.     else
  19.     strend=""
  20. end if
  21. aboutus=left(aboutus,strlen)
  22. aboutus=aboutus&strend
  23. '获得旅游说明信息
  24. statement=sqlshow("select * from trip_infor","statement")
  25. strlen=len(statement)
  26. if(strlen>=260)then
  27.    strlen=260
  28.    strend="... ..."
  29. else
  30.    strend=""   
  31. end if
  32. statement=left(statement,strlen)
  33. statement=statement&strend
  35. set rst=server.CreateObject("adodb.recordset")
  36. sqlstr="select * from  trip_soloverseas order by id "
  38. rst.open sqlstr,conn,1,1
  39. dim solt(4)
  41.     for i=0 to 3 
  42. if not (rst.eof or rst.bof) then
  43.      solt(i)=rst("solname")
  44.  rst.movenext
  45. else
  46.     exit for  
  47. end if
  48.     next
  49. rst.close
  50. set rst=nothing
  53. ppath=pictitle("trip_infor")
  54.     'response.Write(ppath)
  56. set rst=server.CreateObject("adodb.recordset")
  57. sqlstr="select * from trip_infor"
  59. rst.open sqlstr,conn,1,1
  60. if not (rst.eof or rst.bof) then
  61.     solpname1="../wy_trip_images/"&rst("solpic1")
  62. solpname2="../wy_trip_images/"&rst("solpic2")
  63. solpname3="../wy_trip_images/"&rst("solpic3")
  64. solpname4="../wy_trip_images/"&rst("solpic4")
  65. end if
  66. rst.close
  67. set rst=nothing
  69. %>
  71. <body leftmargin="0" topmargin="0" link="#3357B3" vlink="#3357B3" alink="#3357B3" bgcolor="#e8eefc">
  73. <table width="726" height="552" cellpadding="0" cellspacing="0">
  74. <tr>
  75. <td width="56%" height="552" valign="top" class="Main">
  76. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/TopCol3.gif" WIDTH="247" HEIGHT="23"></p>
  77. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/HeaderAboutUs.gif" WIDTH="229" HEIGHT="26"></p>
  78. <p class="Indented1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=aboutus%></p>
  79. <p class="Indented1">
  80.   <table cellpadding="0" cellspacing="0">
  81. <tr height="1">
  82. <td><img src="<%=ppath%>" class="Bordered" WIDTH="103" HEIGHT="145"></td>
  83. <td><img src="_blank.gif" width="6" height="1"></td>
  84. <td>
  85. <table cellpadding="0" cellspacing="0" height="100%">
  86. <tr>
  87. <td>
  88. <p><%=statement%></p>
  89. </td>
  90. </tr>
  91. <tr height="100%">
  92. <td></td>
  93. </tr>
  94. <tr>
  95. <td>
  96. <table cellpadding="0" cellspacing="0">
  97. <tr>
  98. <td><a href="index.html"><img src="../wy_trip_images/Icon1.gif" border="0" WIDTH="30" HEIGHT="32"></a></td>
  99. <td><img src="_blank.gif" width="6" height="0"></td>
  100. <td valign="bottom"><img src="../wy_trip_images/Caption.gif" WIDTH="173" HEIGHT="17"></td>
  101. </tr>
  102. </table>
  103. </td>
  104. </tr>
  105. </table>
  106. </td>
  107. </tr>
  108.   </table>
  109. </p>
  110. <br>
  111. <p><img src="../wy_trip_images/HeaderOtherDestination.gif" WIDTH="229" HEIGHT="28"></p>
  112. <table cellpadding="0" cellspacing="0">
  113. <tr>
  114. <td><img src="_blank.gif" width="14" height="8"></td>
  115. <td><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(0)%>" target="main"><img src="<%=solpname1%>" class="Bordered" border="0" WIDTH="103" HEIGHT="82"></a><p align="center"><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(0)%>" target="main"><%=solt(0)%></a></p></td>
  116. <td><img src="_blank.gif" width="15" height="8"></td>
  117. <td><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(1)%>" target="main"><img src="<%=solpname2%>" class="Bordered" border="0" WIDTH="107" HEIGHT="82"></a><p align="center"><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(1)%>" target="main"><%=solt(1)%></a></p></td>
  118. <td><img src="_blank.gif" width="15" height="8"></td>
  119. <td><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(2)%>" target="main"><img src="<%=solpname3%>" class="Bordered" border="0" WIDTH="103" HEIGHT="82"></a><p align="center"><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(2)%>" target="main"><%=solt(2)%></a></p></td>
  120. <td><img src="_blank.gif" width="15" height="8"></td>
  121. <td><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(3)%>" target="main"><img src="<%=solpname4%>" class="Bordered" border="0" WIDTH="103" HEIGHT="82"></a><p align="center"><a href="../wy_trip_sol/wy_trip_sol.asp?solname=<%=solt(3)%>" target="main"><%=solt(3)%></a></p></td>
  122. </tr>
  123. </table>
  124. <br>
  125.   </td>
  126. <td width="1%" class="Main"><img src="_blank.gif" width="12" height="1"></td>
  127.   <td width="43%" valign="top">
  128. <p align="right"><img src="../wy_trip_images/HeaderNews.gif" WIDTH="169" HEIGHT="26"></p>
  129. <p><img src="_blank.gif" width="1" height="12"></p>
  130. <p class="Indented1">
  131.   <table width="226" cellpadding="0" cellspacing="0">
  132. <tr>
  133. <td width="80" valign="top"><a href="index.html"><img src="../wy_trip_images/Photo2.jpg" class="Bordered" border="0" WIDTH="78" HEIGHT="78"></a><br><br></td>
  134. <td width="12"><img src="_blank.gif" width="12" height="1"></td>
  135. <td width="162" valign="top">
  136. <p class="Title NoBreakBefore"><a href="../wy_trip_sol/wy_trip_solho.asp?soladdress=0" target="main">国内旅游解决方案</a></p>
  137.   <p class="Indented2"> 为您提供国内最新的旅游方案，其方案覆全国数十个省市。北起冰雪之国哈尔滨，南到祖国宝岛台湾，西起... ... <br>
  138.             <br>
  139.   </p>
  140.   </td>
  141. </tr>
  142. <tr>
  143.   <td valign="top"><a href="index.html"><img src="../wy_trip_images/Photo3.jpg" class="Bordered" border="0" width="78" height="78"></a></td>
  144.   <td><img src="_blank.gif" width="12" height="8"></td>
  145.   <td valign="top"><p class="Title NoBreakBefore"><a href="../wy_trip_sol/wy_trip_solho.asp?soladdress=1" target="main">国外旅游解决方案</a></p>
  146.       <p class="Indented2">为您提供当前国际最优的旅行方案.其方案覆盖全球十个国家,为您提过最便捷的签证,提供最优的服务... ... </p></td>
  147.     </tr>
  148. <tr>
  149. <td height="20" colspan="3" valign="top"><div align="right">
  150.   <div align="right"><br>
  152.       </div>
  153.     </tr>
  154.     </table>
  155. </p>
  156. <br>
  157. <p align="right"><img src="../wy_trip_images/HeaderNewsletter.gif" WIDTH="167" HEIGHT="25"></p>
  158. <p align="right">
  159.     </p>
  160.             <img src="_blank.gif" width="225" height="1">
  161.             <table width="100%"  border="0" cellspacing="0" cellpadding="0">
  162.               <tr>
  163.                 <th scope="col">&nbsp;</th>
  164.               </tr>
  165.               <tr>
  166.                 <td>&nbsp;</td>
  167.               </tr>
  168.               <tr>
  169.                 <td>&nbsp;</td>
  170.               </tr>
  171.               <tr>
  172.                 <td>&nbsp;</td>
  173.               </tr>
  174.               <tr>
  175.                 <td>&nbsp;</td>
  176.               </tr>
  177.             </table></td>
  178. </tr>
  179. </table>
  180. </body>
  181. </html>