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

📄 main.asp

📁 旅游信息管理系统,带论文,可作为课程设计参考资料
💻 ASP
字号:
<!--#include file="../wy_trip_inc/wy_trip_fun.inc"-->
<html>
<head>
	<title>PTrip Server 2005 For 数据库课程设计
	</title>
	<META http-equiv=Content-Type content="text/html; charset=gb2312">
	<link rel="stylesheet" type="text/css" href="../wy_trip_css/wy_trip.css">
</head>
<script language="javascript" src="../wy_trip_js/wy_trip_check.js"></script>
<script language="javascript" src="../wy_trip_js/wy_trip_inputcheck.js"></script>
<%  
    '获得公司关于信息
	aboutus=sqlshow("select * from trip_infor","aboutus")
	strlen=len(aboutus)
	if(strlen>=420)then
	    strlen=420
		strend="... ..."
    else
	    strend=""		
	end if	
	aboutus=left(aboutus,strlen)
	aboutus=aboutus&strend
	'获得旅游说明信息
	statement=sqlshow("select * from trip_infor","statement")
	strlen=len(statement)
	if(strlen>=260)then
	   strlen=260
	   strend="... ..."
	else
	   strend=""   
	end if
	statement=left(statement,strlen)
	statement=statement&strend
	
	set rst=server.CreateObject("adodb.recordset")
	sqlstr="select * from  trip_soloverseas order by id "
	
	rst.open sqlstr,conn,1,1
	dim solt(4)

    for i=0 to 3 	
		if not (rst.eof or rst.bof) then
		     solt(i)=rst("solname")
			 rst.movenext
		else
		    exit for	 
		end if
    next		
	rst.close
	set rst=nothing
	
	
	ppath=pictitle("trip_infor")
    'response.Write(ppath)
	
	set rst=server.CreateObject("adodb.recordset")
	sqlstr="select * from trip_infor"
	
	rst.open sqlstr,conn,1,1
	if not (rst.eof or rst.bof) then
	    solpname1="../wy_trip_images/"&rst("solpic1")
		solpname2="../wy_trip_images/"&rst("solpic2")
		solpname3="../wy_trip_images/"&rst("solpic3")
		solpname4="../wy_trip_images/"&rst("solpic4")
	end if
	rst.close
	set rst=nothing
	
%>

<body leftmargin="0" topmargin="0" link="#3357B3" vlink="#3357B3" alink="#3357B3" bgcolor="#e8eefc">

<table width="726" height="552" cellpadding="0" cellspacing="0">
	<tr>
		<td width="56%" height="552" valign="top" class="Main">
			<p class="NoBreakBeforeAfter"><img src="../wy_trip_images/TopCol3.gif" WIDTH="247" HEIGHT="23"></p>
			<p class="NoBreakBeforeAfter"><img src="../wy_trip_images/HeaderAboutUs.gif" WIDTH="229" HEIGHT="26"></p>
			<p class="Indented1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=aboutus%></p>
			<p class="Indented1">
		  <table cellpadding="0" cellspacing="0">
					<tr height="1">
						<td><img src="<%=ppath%>" class="Bordered" WIDTH="103" HEIGHT="145"></td>
						<td><img src="_blank.gif" width="6" height="1"></td>
						<td>
							<table cellpadding="0" cellspacing="0" height="100%">
								<tr>
									<td>
										<p><%=statement%></p>
									</td>
								</tr>
								<tr height="100%">
									<td></td>
								</tr>
								<tr>
									<td>
										<table cellpadding="0" cellspacing="0">
											<tr>
												<td><a href="index.html"><img src="../wy_trip_images/Icon1.gif" border="0" WIDTH="30" HEIGHT="32"></a></td>
												<td><img src="_blank.gif" width="6" height="0"></td>
												<td valign="bottom"><img src="../wy_trip_images/Caption.gif" WIDTH="173" HEIGHT="17"></td>
											</tr>
										</table>										
									</td>
								</tr>
							</table>
						</td>
					</tr>
		  </table>
			</p>
			<br>	
			<p><img src="../wy_trip_images/HeaderOtherDestination.gif" WIDTH="229" HEIGHT="28"></p>
			<table cellpadding="0" cellspacing="0">
				<tr>
					<td><img src="_blank.gif" width="14" height="8"></td>
					<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>
					<td><img src="_blank.gif" width="15" height="8"></td>
					<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>
					<td><img src="_blank.gif" width="15" height="8"></td>
					<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>
					<td><img src="_blank.gif" width="15" height="8"></td>
					<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>
				</tr>
			</table>
			<br>
	  </td>
		<td width="1%" class="Main"><img src="_blank.gif" width="12" height="1"></td>
	  <td width="43%" valign="top">
			<p align="right"><img src="../wy_trip_images/HeaderNews.gif" WIDTH="169" HEIGHT="26"></p>
			<p><img src="_blank.gif" width="1" height="12"></p>
			<p class="Indented1">
		  <table width="226" cellpadding="0" cellspacing="0">
					<tr>
						<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>
						<td width="12"><img src="_blank.gif" width="12" height="1"></td>
						<td width="162" valign="top">
							<p class="Title NoBreakBefore"><a href="../wy_trip_sol/wy_trip_solho.asp?soladdress=0" target="main">国内旅游解决方案</a></p>
						  <p class="Indented2"> 为您提供国内最新的旅游方案,其方案覆全国数十个省市。北起冰雪之国哈尔滨,南到祖国宝岛台湾,西起... ... <br>
				            <br>
						  </p>
					  </td>						
					</tr>
					<tr>
					  <td valign="top"><a href="index.html"><img src="../wy_trip_images/Photo3.jpg" class="Bordered" border="0" width="78" height="78"></a></td>
					  <td><img src="_blank.gif" width="12" height="8"></td>
					  <td valign="top"><p class="Title NoBreakBefore"><a href="../wy_trip_sol/wy_trip_solho.asp?soladdress=1" target="main">国外旅游解决方案</a></p>
				      <p class="Indented2">为您提供当前国际最优的旅行方案.其方案覆盖全球十个国家,为您提过最便捷的签证,提供最优的服务... ... </p></td>
		    </tr>
					<tr>
						<td height="20" colspan="3" valign="top"><div align="right">
						  <div align="right"><br>
							
					      </div>
				    </tr>
	    </table>
			</p>
			<br>
			<p align="right"><img src="../wy_trip_images/HeaderNewsletter.gif" WIDTH="167" HEIGHT="25"></p>
			<p align="right">
		    </p>
            <img src="_blank.gif" width="225" height="1">
            <table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <th scope="col">&nbsp;</th>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td>&nbsp;</td>
              </tr>
            </table></td>
	</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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