📄 orderconfirm.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="tangbohu";  //连接数据库的用户名
    String pass1="";  //连接数据库的口令
    String strSQL1;  //要执行的sql语句
	String strSQL2;  //要执行的sql语句
	String id=request.getParameter("id");

	int dingdanhao=0;
	String userTruename=null;
	String userZhengjianhao=null;
	int qifeigang1;
	int mudigang1;
	String chufaDate=null;
	int goupiaoNum=0;
	String userTel=null;
	String hangbanhao=null;
	String address=null;
	String fuyan=null;
	String chuliFlg=null;

	String qifeigang=null;
	String mudigang=null;
	String chufaTime=null;

	int i=0;

    if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{
        strSQL1="select * from airline_dingPiao with(READCOMMITTED)";//判断是否有用户存在
		strSQL1=strSQL1+" where id="+id;
        rs=db.executeQuery(strSQL1);
		rs.next();

		 dingdanhao=rs.getInt(2);
		 userTruename=rs.getString(3);
		 userZhengjianhao=rs.getString(4);
		 qifeigang1=rs.getInt(5);
		 mudigang1=rs.getInt(6);
		 chufaDate=rs.getString(7);
		 goupiaoNum=rs.getInt(8);
		 userTel=rs.getString(9);
		 hangbanhao=rs.getString(10);
		 address=rs.getString(11);
		 fuyan=rs.getString(12);
		 chuliFlg=rs.getString(13);
		 chufaTime=chufaDate.substring(0,10);
		 chufaDate=chufaDate.substring(11,19);
		 
		 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;
			}


	}
	catch(SQLException e2){
		 out.println("数据库异常！");
		 out.println(e2.toString());
	}
	finally{
		try{
			if(rs!=null) rs.close();
		}
		catch(Exception e){}
	}
   
	
%>
<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="ticketlist.jsp">
    <TABLE  WIDTH="780" ALIGN="CENTER" BORDER="0" CELLSPACING="2" CELLPADDING="0">
        <TR>
            <TD COLSPAN="4" CLASS="TITLE2">订票</TD>
        </TR>
        <TR>
            <TD COLSPAN="4">&nbsp;</TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">订单号：</TD>
            <TD CLASS="TEXT"><%=dingdanhao%></TD>
            <TD CLASS="RIGHT">是否完成：</TD>
            <TD CLASS="TEXT"><%=chuliFlg%></TD>
        </TR>
        <TR>
            <TD WIDTH="179" CLASS="RIGHT">真实姓名：</TD>
            <TD WIDTH="207" CLASS="TEXT"><%=userTruename%></TD>
            <TD WIDTH="109" CLASS="RIGHT"></TD>
            <TD WIDTH="275" CLASS="TEXT"></TD>
        </TR>
        <TR>
            <TD HEIGHT="13" CLASS="RIGHT">证件号码：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=userZhengjianhao%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 出发城市：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=qifeigang%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT">到达城市：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=mudigang%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 出发日期：</TD>
            <TD CLASS="TEXT"><%=chufaTime%></TD>
            <TD CLASS="RIGHT">时间：</TD>
            <TD CLASS="TEXT"><%=chufaDate%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 购票张数：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=goupiaoNum%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 联系电话：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=userTel%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 航班号：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=hangbanhao%></TD>
        </TR>
        <TR>
            <TD CLASS="RIGHT"> 送票地址：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=address%></TD>
        </TR>
        <TR>
            <TD HEIGHT="72" CLASS="RIGHT"> 订票附言：</TD>
            <TD COLSPAN="3" CLASS="TEXT"><%=fuyan%></TD>
        </TR>
        <TR>
            <TD COLSPAN="4" ALIGN="RIGHT"><HR COLOR="#999999" SIZE="1"></TD>
        </TR>
        <TR>
            <TD COLSPAN="4" ALIGN="CENTER">
				<INPUT TYPE="button" NAME="submit" onclick="history.back();" VALUE="确定">
			</TD>
        </TR>
    </TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

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