📄 linesearchrlt.jsp
字号:
<%@ include file="conndb.jsp"%>
<html>
<head>
<title>旅游线路查询结果</title>
<link href="style.css" rel="stylesheet">
</head>
<body>
<form name="form1" method="POST">
<%
String lname=(request.getParameter("name")).trim();
String area=(request.getParameter("area")).trim();
String days=(request.getParameter("days")).trim();
String searchcnd=""; //综合查询条件
//判断线路名称和地域名称是否为空
if((lname.compareTo("")!=0)&& (area.compareTo("")!=0))
{ searchcnd = "l.LineName Like '%"+lname+"%' And a.AreaName Like '%"+area+"%'";}
else if((lname.compareTo("")!=0)&& (area.compareTo("")==0))
{ searchcnd = "l.LineName Like '%"+lname+"%'";}
else if((lname.compareTo("")==0 ) && (area.compareTo("")!=0))
{ searchcnd = "a.AreaName Like '%"+area+"%'";}
else if((lname.compareTo("")==0 ) && (area.compareTo("")==0 ))
{ //searchcnd =null;
}
//判断线路名称、地域名称和行程天数是否为空
if((days.compareTo("")!=0) && (searchcnd.compareTo("")!=0))
{ searchcnd = searchcnd+" And l.Days="+days;}
else if((days.compareTo("")==0) && (searchcnd.compareTo("")!=0))
{
//searchcnd =searchcnd;
}
else if((days.compareTo("")!=0) && (searchcnd.compareTo("")==0))
{ searchcnd = " l.Days="+days;}
//通过上述条件得出综合查询条件
String sql;
if((searchcnd.trim()).compareTo("")==0)
{
sql = "Select l.*,a.TypeId,a.AreaName From Line l,Area a Where l.AreaId=a.AreaId Order By l.LineId Desc";
}
else
{
sql = "Select l.*,a.TypeId,a.AreaName From Line l,Area a Where l.AreaId=a.AreaId And "+getGBString(searchcnd)+" Order By l.LineId Desc";
}
ResultSet rs=stmt.executeQuery(sql);
%>
<p align=center><font color="#000080"><b><font color="#990000" style="font-size: 12pt">旅游线路查询结果</font></b></font></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolorlight="#FFE8DD" bordercolordark="#FFFFFF">
<tr>
<td width="20%" align="center" bgcolor="#FFE8DD"><strong>地域</strong></td>
<td width="40%" align="center" bgcolor="#FFE8DD"><strong>线路名称</strong></td>
<td width="10%" align="center" bgcolor="#FFE8DD"><strong>行程天数</strong></td>
<td width="30%" align="center" bgcolor="#FFE8DD"><strong>适合人群</strong></td>
</tr>
<%
boolean tag=false;
while(rs.next())
{
tag=true;
%>
<tr>
<td align="center"><%if(rs.getBoolean("TypeId"))
{out.println(" 本市");}
else
{ out.println("外埠");}%>
--<%=rs.getString("AreaName")%></td>
<td><a href="lineview.jsp?lid=<%=rs.getInt("LineId")%>" target="_blank">
<%=rs.getString("LineName")%></a></td>
<td align="center"><%=rs.getInt("Days")%></td>
<td align="center"><%=rs.getString("People")%></td>
</tr>
<%
//rs.close();
}
%>
</table>
<%
if(!tag)
{
out.println("<br> </br>");
out.println("<br> </br>");
out.println("<br> </br>");
out.println("<p align='center'><font color='#000080'>Sorry,这里没有找到符合你要求的路线！！！</font></p>");
}
%>
<p align="center"><a href="javascript:window.close();">[ 关 闭 ]</a></p>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -