📄 airdetail.jsp

📁 毕业设计代码
💻 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;
	
	int i=0;
	if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{ 
		strSQL="select * from airline_hangbanxinxi";//遍历数据，所有主题的信息
        rs=db.executeQuery(strSQL);
%>
<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="780" ALIGN="CENTER" BORDER="0" CELLSPACING="2" CELLPADDING="0">
	<input type="hidden" value="" name="id">
	<input type="hidden" value="" name="hangbanhao">
	<input type="hidden" value="" name="hanggongcompany">
	<input type="hidden" value="" name="qifeigang">
	<input type="hidden" value="" name="mudigang">
	<input type="hidden" value="" name="startTime">
	<input type="hidden" value="" name="endTime">
	<input type="hidden" value="" name="price">
	<input type="hidden" value="" name="zhekou">
		<TR BGCOLOR="#FF9966">
			<TD COLSPAN="11" CLASS="TITLE2">航班详细信息</TD>
		</TR>
		<TR>
		    <TD COLSPAN="11" CLASS="RIGHT"><A HREF="newairline.jsp" TARGET="mainFrame">新增</A></TD>
	    </TR>
        <TR CLASS="HD1">
            <TD WIDTH="41" BGCOLOR="#ffdfb0">选择</TD>
            <TD WIDTH="43" BGCOLOR="#ffdfb0">航班号</TD>
            <TD WIDTH="83" BGCOLOR="#ffdfb0">航空公司</TD>
            <TD WIDTH="81" BGCOLOR="#ffdfb0">起飞港</TD>
            <TD WIDTH="61" BGCOLOR="#ffdfb0">目的港</TD>
            <TD WIDTH="80" BGCOLOR="#ffdfb0">起飞时间</TD>
            <TD WIDTH="57" BGCOLOR="#ffdfb0">到达时间</TD>
            <TD WIDTH="75" BGCOLOR="#ffdfb0">价格</TD>
            <TD WIDTH="90" BGCOLOR="#ffdfb0">会员折扣</TD>
            <TD WIDTH="86" BGCOLOR="#ffdfb0">&nbsp;</TD>
            <TD WIDTH="79" BGCOLOR="#ffdfb0">&nbsp;</TD>
        </TR>
<%
    while(rs.next()){
		i++;
		id=rs.getInt(1);
		hangbanhao=rs.getString(2);
		hanggongcompany=rs.getString(3);
		qifeigang1=rs.getInt(4);
		mudigang1=rs.getInt(5);
		startTime=rs.getString(6);
		startTime=startTime.substring(11,19);
		endTime=rs.getString(7);
		endTime=endTime.substring(11,19);
		price=rs.getFloat(8);
		zhekou=rs.getString(9);
		switch(qifeigang1)
		{
			case 0:
				qifeigang="大连";
				break;
			case 1:
				qifeigang="上海";
				break;
			case 2:
				qifeigang="北京";
				break;
		}
		switch(mudigang1)
		{
			case 0:
				mudigang="大连";
				break;
			case 1:
				mudigang="上海";
				break;
			case 2:
				mudigang="北京";
				break;
		}
		 
%>
        <TR CLASS="ODDTR">
            <TD><%=i%></TD>
            <TD><%=hangbanhao%></TD>
            <TD><%=hanggongcompany%></TD>
            <TD><%=qifeigang%></TD>
            <TD><%=mudigang%></TD>
            <TD><%=startTime%> </TD>
            <TD><%=endTime%> </TD>
            <TD><%=price%></TD>
            <TD><%=zhekou%></TD>
            <TD><A HREF="JavaScript:linkSyokomoku('editairline.jsp','<%=id%>','<%=hangbanhao%>','<%=hanggongcompany%>','<%=qifeigang1%>','<%=mudigang1%>','<%=startTime%>','<%=endTime%>','<%=price%>','<%=zhekou%>');" TARGET="mainFrame">修改</A></TD>
            <TD><A HREF="JavaScript:linkSyokomoku('deleteconfirm.jsp','<%=id%>','<%=hangbanhao%>','<%=hanggongcompany%>','<%=qifeigang1%>','<%=mudigang1%>','<%=startTime%>','<%=endTime%>','<%=price%>','<%=zhekou%>');" TARGET="mainFrame">删除</A></TD>
        </TR>
<%
}
%>
        <TR ALIGN="RIGHT">
            <TD COLSPAN="11">
				&nbsp;&nbsp;		        
			</TD>
        </TR>
		<TR>
		    <TD COLSPAN="11"><HR COLOR="#CCCCCC"></TD>
	    </TR>
        <TR ALIGN="RIGHT">
            <TD COLSPAN="11" CLASS="TEXT" ALIGN="CENTER">共有 N 条 数据 第 N 页／共 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>
<script language="javascript">
<!--
function linkSyokomoku(url,id,hangbanhao,hanggongcompany,qifeigang,mudigang,startTime,endTime,price,zhekou)
{
	var frm=document.form1;
	frm.id.value=id;
	frm.hangbanhao.value=hangbanhao;
	frm.hanggongcompany.value=hanggongcompany;
	frm.qifeigang.value=qifeigang;
	frm.mudigang.value=mudigang;
	frm.startTime.value=startTime;
	frm.endTime.value=endTime;
	frm.price.value=price;
	frm.zhekou.value=zhekou;

	frm.method = "post";
	frm.action = url;
	frm.target = "mainFrame";
	frm.submit();

}
-->
</script>
⌨️ 快捷键说明

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