📄 view.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
ResultSet rs=null;
ResultSet rs1=null;
ResultSet rs2=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1=""; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL; //要执行的sql语句
String strSQL1; //要执行的sql语句
String strSQL2; //要执行的sql语句
String cityFlg=request.getParameter("cityFlg");
String jingdianName1=request.getParameter("jingdianName");
String jingdianjianjie1=request.getParameter("jingdianjianjie");
if(jingdianName1!=null){
jingdianName1=new String(jingdianName1.getBytes("8859_1"));
jingdianjianjie1=new String(jingdianjianjie1.getBytes("8859_1"));
}
String hotelName=null;
String fuwujibie=null;
int i=0;
int id=0;
String optionC=null;
String optionJ=null;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
if(cityFlg!=null){
strSQL="select * from airline_jingdianxinxi where cityFlg="+cityFlg;//遍历数据，所有主题的信息
strSQL1="select * from airline_hotelxinxi where cityFlg="+cityFlg;//遍历数据，所有主题的信息
strSQL2="select * from airline_cityxinxi where ID="+cityFlg;
rs2=db.executeQuery(strSQL2);
if(rs2!=null){
rs2.next();
optionC=rs2.getString(2);
}
}
else{
strSQL="select * from airline_jingdianxinxi";//遍历数据，所有主题的信息
strSQL1="select * from airline_hotelxinxi";//遍历数据，所有主题的信息
strSQL2="select * from airline_cityxinxi";
rs2=db.executeQuery(strSQL2);
while(rs2.next())
{
optionC=optionC+"<option value='"+rs2.getInt(1)+"'>"+rs2.getString(2)+"</option>";
}
}
rs1=db.executeQuery(strSQL1);
rs=db.executeQuery(strSQL);
if(rs!=null)
{
while(rs.next())
{
String jingdianName=rs.getString(2);
String jingdianjianjie=rs.getString(3);
optionJ=optionJ+"<option value='"+jingdianjianjie+","+jingdianName+"'>"+jingdianName+"</option>";
}
}
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<LINK HREF="../../../css/style.css" REL="stylesheet" TYPE="text/css">
<TITLE>酒店旅游度假预定</TITLE>
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="">
<input type="hidden" value="" name="jingdianName">
<input type="hidden" value="" name="jingdianjianjie">
<TABLE WIDTH="620" BORDER="0" CELLSPACING="2" CELLPADDING="0">
<TR>
<TD COLSPAN="4" CLASS="TITLE2">选择城市及景点</TD>
</TR>
<TR>
<TD COLSPAN="4"> </TD>
</TR>
<TR>
<TD COLSPAN="4" CLASS="TEXT">城市：
<%
if(cityFlg==null){
%>
<SELECT NAME="cityFlg" onchange="fChangeSales();">
<option vlaue="">请选择城市</option>
<%=optionC%>
</SELECT>
景点：
<SELECT NAME="jingdian" onchange="fChangeSales1(this.selectedIndex);" disabled>
<option vlaue="">请选择景点</option>
<%=optionJ%>
</SELECT>
<%
}
else if(cityFlg!=null){
%>
<%=optionC%>
<input type="hidden" value="<%=cityFlg%>" name="cityFlg">
景点：
<SELECT NAME="jingdian" onchange="fChangeSales1(this.selectedIndex);">
<option vlaue="">请选择景点</option>
<%=optionJ%>
</SELECT>
<%
}
%>
</TD>
</TR>
<TR>
<TD COLSPAN="4" CLASS="TEXT"> </TD>
</TR>
<TR>
<TD WIDTH="583" COLSPAN="4" CLASS="TEXT"><%=jingdianName1%>风光简介：<BR>
<%=jingdianjianjie1%>
<BR>
</TD>
</TR>
<TR>
<TD COLSPAN="4" CLASS="TEXT"> </TD>
</TR>
<TR CLASS="HD3">
<TD WIDTH="44">序号</TD>
<TD WIDTH="264">酒店</TD>
<TD WIDTH="137">服务级别</TD>
<TD WIDTH="116"> </TD>
</TR>
<% if(rs1!=null){
while(rs1.next()){
i++;
id=rs1.getInt(1);
hotelName=rs1.getString(3);
fuwujibie=rs1.getString(4);
%>
<TR CLASS="ODDTR">
<TD><%=i%></TD>
<TD><A HREF="hoteldetail.jsp"><%=hotelName%></A></TD>
<TD><%=fuwujibie%></TD>
<TD><A HREF="order.jsp?id=<%=id%>" TARGET="mainFrame"><IMG SRC="../../../image/hotelorder.gif" ALT="我要预定" WIDTH="72" HEIGHT="27" BORDER="0"></A></TD>
</TR>
<%
}
}
%>
<TR>
<TD COLSPAN="4"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="4"><CENTER CLASS="TEXT">
共有N条数据 第 N 页 ／共 N 页 首页 前页 后页 末页
</CENTER></TD>
</TR>
</TABLE>
<%
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
</FORM>
</BODY>
</HTML>
<script language="JavaScript">
<!--
function fChangeSales(){
var frm = document.form1;
frm.action="view.jsp";
frm.submit();
}
function fChangeSales1(strIndex){
var frm = document.form1;
var jingdianjianjie = "";
var jingdianName = "";
jingdianjianjie = frm.jingdian.options[strIndex].value.split(",")[0];
jingdianName = frm.jingdian.options[strIndex].value.split(",")[1];
frm.jingdianjianjie.value = jingdianjianjie;
frm.jingdianName.value = jingdianName;
frm.action="view.jsp";
frm.submit();
}
-->
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -