📄 main.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 rt=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1=""; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL; //要执行的sql语句
String strSQL1; //要执行的sql语句
int id;
String cityName=null;
String option=null;
String option1=null;
int i=0;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL="select * from airline_cityxinxi";//遍历数据，所有主题的信息
strSQL1="select * from airline_yunhuoxinxi";//遍历数据，所有主题的信息
rs=db.executeQuery(strSQL);
rt=db.executeQuery(strSQL1);
while(rs.next())
{
option=option+"<option value='"+rs.getInt(1)+"'>"+rs.getString(2)+"</option>";
}
while(rt.next())
{
String luxian=rt.getString(2);
option1=option1+"<option value='"+luxian+"'>"+luxian+"</option>";
}
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
<!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" TYPE="text/css" REL="STYLESHEET">
</HEAD>
<BODY>
<TABLE WIDTH="620" align="center" CLASS="TABLE1">
<TR>
<TD COLSPAN=2 CLASS="TEXT">
<MARQUEE BEHAVIOR="SCROLL" DIRECTION="LEFT">
订票热线 0411-12345678 <BR>
运货热线 0411-87654321
</MARQUEE>
</TD>
</TR>
<FORM NAME="form1" METHOD="post" ACTION="">
<TBODY>
<TR BGCOLOR="#FFFFFF">
<TD HEIGHT="5" COLSPAN="2" ALIGN="CENTER" CLASS="TITLE1">航班查询</TD>
</TR>
<TR CLASS="TEXT">
<TD HEIGHT="0" COLSPAN="2"> 出发城市：
<SELECT NAME="qifeigang">
<%=option%>
</SELECT>
到达城市：
<SELECT NAME="mudigang">
<%=option%>
</SELECT>
</TD>
</TR>
<TR CLASS="TEXT">
<TD HEIGHT="0" CLASS="TEXT">
</TD>
<TD CLASS="RIGHT"><A HREF="JavaScript:linkSyokomoku1();" TARGET="mainFrame"><IMG SRC="../../image/search2.gif" ALT="查询" WIDTH="61" HEIGHT="28" BORDER="0"></A> </TD>
</TR>
<TR CLASS="TEXT">
<TD COLSPAN="2" CLASS="TEXT"><HR COLOR="#744757" SIZE="1"></TD>
</TR>
</TBODY>
</FORM>
<BR>
<BR>
<FORM NAME="form2" METHOD="post" ACTION="">
<TBODY>
<TR CLASS="TEXT">
<TD HEIGHT="10" COLSPAN="2" ALIGN="CENTER" bgColor=#6c6c6c CLASS="TITLE1">运价查询
</TD>
</TR>
<TR CLASS="TEXT">
<TD>路线：
<SELECT NAME="luxianming">
<%=option1%>
</SELECT>
</TD>
<TD CLASS="RIGHT"><A HREF="JavaScript:linkSyokomoku2();" TARGET="mainFrame"><IMG SRC="../../image/search2.gif" ALT="查询" WIDTH="61" HEIGHT="28" BORDER="0"></A> </TD>
</TR>
<TR CLASS="TEXT">
<TD COLSPAN =2><HR COLOR="#744757" SIZE="1" ></TD>
</TR>
</TBODY>
</FORM>
<BR>
<BR>
<FORM NAME="form3" METHOD="post" ACTION="">
<TBODY>
<TR CLASS="TEXT">
<TD HEIGHT="10" COLSPAN="2" ALIGN="CENTER" bgColor=#6c6c6c CLASS="TITLE1">旅游度假
</TD>
</TR>
<TR CLASS="TEXT">
<TD > 城市：
<SELECT NAME="cityFlg">
<%=option%>
</SELECT>
</TD>
<TD CLASS="RIGHT"><A HREF="JavaScript:linkSyokomoku3();" TARGET="mainFrame"><IMG SRC="../../image/search2.gif" ALT="查询" WIDTH="61" HEIGHT="28" BORDER="0"></A> </TD>
</TR>
<TR CLASS="TEXT">
<TD HEIGHT="15" COLSPAN =2><HR COLOR="#744757" SIZE="1" ></TD>
</TR>
</TBODY>
</FORM>
</TABLE>
</BODY>
</HTML>
<script language="javascript">
<!--
function linkSyokomoku1()
{
var frm=document.form1;
var frmmain=document.form1;
frm.method = "post";
frm.action = "order/airquery.jsp";
frm.target = "mainFrame";
frm.submit();
}
function linkSyokomoku2()
{
var frm=document.form2;
var frmmain=document.form2;
frm.method = "post";
frm.action = "freight/moneyquery.jsp";
frm.target = "mainFrame";
frm.submit();
}
function linkSyokomoku3()
{
var frm=document.form3;
var frmmain=document.form3;
frm.method = "post";
frm.action = "hotel/view.jsp";
frm.target = "mainFrame";
frm.submit();
}
-->
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -