📄 airquery.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;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1=""; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL; //要执行的sql语句
int id;
String hangbanhao=null;
String hanggongcompany=null;
String qifeigang=null;
String mudigang=null;
int qifeigang1=0;
int mudigang1=0;
String startTime=null;
String endTime=null;
float price=0;
String zhekou=null;
String qifei=request.getParameter("qifeigang");
String mudi=request.getParameter("mudigang");
int i=0;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
if(qifei!=null){
strSQL="select * from airline_hangbanxinxi where qifeigang="+qifei+" and mudigang="+mudi;//遍历数据，所有主题的信息
}
else{
strSQL="select * from airline_hangbanxinxi";
}
rs=db.executeQuery(strSQL);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>航班查询</TITLE>
<LINK HREF="../../../css/style.css" REL="stylesheet" TYPE="text/css">
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="">
<TABLE WIDTH="620" CLASS="TABLE1">
<TR>
<TD CLASS="TITLE2" COLSPAN="5">航班查询</TD>
</TR>
<TR>
<TD COLSPAN="5"> </TD>
</TR>
<TR>
<TD CLASS="RIGHT" COLSPAN="5"> </TD>
</TR>
<TR>
<TD CLASS="RIGHT" COLSPAN="5"><A HREF="order.jsp" TARGET="mainFrame"><IMG SRC="../../../image/ticketorder.gif" ALT="我要订票" WIDTH="88" HEIGHT="28" BORDER="0"></A> <A HREF="return.jsp" TARGET="mainFrame"><IMG SRC="../../../image/ticketreturn.gif" ALT="我要退票" WIDTH="88" HEIGHT="28" BORDER="0"></A></TD>
</TR>
<TR BGCOLOR="#FF9933" CLASS="HD1">
<TD WIDTH="76">序号</TD>
<TD WIDTH="79">航班</TD>
<TD WIDTH="231">起飞港</TD>
<TD WIDTH="134" COLSPAN="2">目的港</TD>
</TR>
<%
while(rs.next()){
i++;
id=rs.getInt(1);
hangbanhao=rs.getString(2);
qifeigang1=rs.getInt(4);
mudigang1=rs.getInt(5);
switch(qifeigang1)
{
case 2:
qifeigang="大连";
break;
case 3:
qifeigang="内蒙古";
break;
case 4:
qifeigang="北京";
break;
}
switch(mudigang1)
{
case 2:
mudigang="大连";
break;
case 3:
mudigang="内蒙古";
break;
case 4:
mudigang="北京";
break;
}
%>
<TR BGCOLOR="#FFFFFF" CLASS="ODDTR">
<TD><%=i%></TD>
<TD><A HREF="airdetail.jsp?id=<%=id%>" TARGET="mainFrame"><%=hangbanhao%></A></TD>
<TD><%=qifeigang%></TD>
<TD COLSPAN="2"><%=mudigang%></TD>
</TR>
<%
}
%>
<TR ALIGN="RIGHT">
<TD COLSPAN="5" CLASS="RIGHT">
<A HREF="order.jsp" TARGET="mainFrame"><IMG SRC="../../../image/ticketorder.gif" ALT="我要订票" WIDTH="88" HEIGHT="28" BORDER="0"></A>
<A HREF="return.jsp" TARGET="mainFrame"><IMG SRC="../../../image/ticketreturn.gif" ALT="我要退票" WIDTH="88" HEIGHT="28" BORDER="0"></A>
</TD>
</TR>
<TR ALIGN="LEFT">
<TD COLSPAN="5"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR ALIGN="CENTER">
<TD COLSPAN="5" CLASS="TEXT">共 N 条数据 第 页 ／共 页 首页 前页 后页 末页</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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -