wy_trip_sol.asp
上传用户:hnxqingdao
上传日期:2013-05-22
资源大小:1283k
文件大小:3k
源码类别:

其他行业

开发平台:

ASP/ASPX

  1. <!--#include file="../wy_trip_inc/wy_trip_cnn.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. <link rel="stylesheet" type="text/css" href="../wy_trip_css/wy_trip_scolsub.css">
  9. </head>
  10. <%
  11. '获得解决方案类型
  12. solname=request.QueryString("solname")
  13. 'response.Write(solname)
  14. sqlstr1="select * from trip_soloverseas where solname='"&solname&"'"
  15. sqlstr2="select * from trip_soloverseasinfor where solname='"&solname&"'"
  16. set rst=server.CreateObject("adodb.recordset")
  17. rst.open sqlstr1,conn,1,1
  18. if not(rst.eof or rst.bof) then
  19.      soltitle=rst("solname")
  20.  solinfor1=rst("solinfor1")
  21.  solinfor2=rst("solinfor2")
  22.  solinfor3=rst("solinfor3")
  23.  solpic1="../wy_trip_images/"&rst("solpic1")
  24.  solpic2="../wy_trip_images/"&rst("solpic2")
  25.  solpic3="../wy_trip_images/"&rst("solpic3")
  26. end if
  27. rst.close
  28. rst.open sqlstr2,conn,1,1
  29. if not (rst.eof or rst.bof) then
  30.      soltime=rst("soltime")
  31. end if
  32. rst.close
  33. set rst=nothing
  34. %>
  35. <body leftmargin="0" topmargin="0"  bottommargin="0" rightmargin="0" link="#3357B3" vlink="#3357B3" alink="#3357B3" bgcolor="#e8eefc">
  36. <table width="734" height="100%" cellpadding="0" cellspacing="0">
  37. <tr>
  38. <td valign="top" class="Main">
  39. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/TopCol3.gif" WIDTH="247" HEIGHT="23"></p>
  40. <p class="NoBreakBeforeAfter"><img src="../wy_trip_images/HeaderOtherDestination.gif" width="229" height="28"></p>
  41. <p class="Indented1" align="center"><font size="6" color="#3357b3"><b><%=soltitle%> 游解决方案 </b></font><%=soltime%></p>
  42.     <table width="100%"  border="0" cellspacing="0"  cellpadding="0" bgcolor="#e8eefc">
  43.               <tr>
  44.                 <td width="27%" scope="col"><img src=<%=solpic1%> alt="pic"></img></td>
  45.                 <td colspan="4" scope="col"><%=solinfor1%></td>
  46.               </tr>
  47.               <tr>
  48.                 <td colspan="4"><%=solinfor2%></td>
  49.                 <td width="37%"><img src=<%=solpic2%> alt="pic"></img></td>
  50.               </tr>
  51.               <tr>
  52.                 <td><img src=<%=solpic3%> alt="pic"></td>
  53.                 <td colspan="4"><%=solinfor3%></td>
  54.               </tr>
  55.               <tr>
  56.                 <td>&nbsp;</td>
  57.                 <td colspan="4">&nbsp;</td>
  58.               </tr>
  59.               <tr>
  60.                 <td>&nbsp;</td>
  61.                 <td>&nbsp;</td>
  62.                 <td>&nbsp;</td>
  63.                 <td>&nbsp;</td>
  64.                 <td><div align="center"><a href="../wy_trip_main/main.asp" target="main"><font color="red"><b>返回首页</b></font></a></div></td>
  65.               </tr>
  66.             </table>
  67.       </td>
  68. </tr>
  69. </table>
  70. </body>
  71. </html>