📄 order.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 id=request.getParameter("id");
int con;
Integer count=(Integer)application.getAttribute("count");
if(count==null) {
con=0;
}
else {
con=count.intValue();
}
con++;
application.setAttribute("count",new Integer(con));
int p_dan=0;
float p_danP=0;
int p_shuang=0;
float p_shuangP=0;
int p_tao=0;
float p_taoP=0;
int h_dan=0;
float h_danP=0;
int h_shuang=0;
float h_shuangP=0;
int h_tao=0;
float h_taoP=0;
int zongtong_tao=0;
float zongtong_taoP=0;
String optionC=null;
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL2="select * from airline_hotelxinxi where ID="+id;
rs=db.executeQuery(strSQL2);
rs.next();
p_dan=rs.getInt(5);
p_danP=rs.getFloat(6);
p_shuang=rs.getInt(7);
p_shuangP=rs.getFloat(8);
p_tao=rs.getInt(9);
p_taoP=rs.getFloat(10);
h_dan=rs.getInt(11);
h_danP=rs.getFloat(12);
h_shuang=rs.getInt(13);
h_shuangP=rs.getFloat(14);
h_tao=rs.getInt(15);
h_taoP=rs.getFloat(16);
zongtong_tao=rs.getInt(17);
zongtong_taoP=rs.getFloat(18);
System.out.print("dddddddddddd");
if(p_dan!=0){
optionC=optionC+"<option value='普单'>普通单人间"+p_danP+"元</option>";
}
if(p_shuang!=0){
optionC=optionC+"<option value='普双'>普通双人间"+p_danP+"元</option>";
}
if(p_tao!=0){
optionC=optionC+"<option value='普套'>普通套房"+p_danP+"元</option>";
}
if(h_dan!=0){
optionC=optionC+"<option value='豪单'>豪华单人间"+p_danP+"元</option>";
}
if(h_shuang!=0){
optionC=optionC+"<option value='豪双'>豪华双人间"+p_danP+"元</option>";
}
if(h_tao!=0){
optionC=optionC+"<option value='豪套'>豪华套房"+p_danP+"元</option>";
}
if(zongtong_tao!=0){
optionC=optionC+"<option value='总统套房'>总统套房"+p_danP+"元</option>";
}
}
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">
<STYLE TYPE="text/css">
<!--
.style1 {color: #FF0000}
-->
</STYLE>
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="orderconfirm.jsp">
<input type="hidden" value="<%=id%>" name="id">
<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">注意:带 <SPAN CLASS="style1">** </SPAN>部分必须填写，谢谢合作。</TD>
</TR>
<TR>
<TD CLASS="RIGHT">订单号：</TD>
<TD CLASS="TEXT"><INPUT NAME="dingdanhao" TYPE="hidden" SIZE="20" value="<%=con%>"><INPUT NAME="dingdanhao" TYPE="text" SIZE="20" value="<%=con%>" DISABLED></TD>
<TD CLASS="RIGHT"></TD>
<TD CLASS="TEXT"></TD>
</TR>
<TR>
<TD WIDTH="131" CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 真实姓名：</TD>
<TD COLSPAN="3"><INPUT NAME="userTruename" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">证件号码：</TD>
<TD COLSPAN="3"><INPUT NAME="userZhengjianhao" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">来自哪里：</TD>
<TD COLSPAN="3"><INPUT NAME="fromCity" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 性别：</TD>
<TD COLSPAN="3"><SELECT NAME="userSex">
<OPTION VALUE="0" SELECTED>男</OPTION>
<OPTION VALUE="1">女</OPTION>
</SELECT></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 联系电话：</TD>
<TD COLSPAN="3"><INPUT NAME="userTel" TYPE="text" SIZE="20"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"> <SPAN CLASS="style1">**</SPAN> 入住日期：</TD>
<TD COLSPAN="3"><INPUT NAME="ruzhuDate" TYPE="text" SIZE="20"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 离店日期： </TD>
<TD COLSPAN="3"><INPUT NAME="likaiDate" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 房间类型：</TD>
<TD WIDTH="168"><SELECT NAME="fangjianType">
<%=optionC%>
</SELECT></TD>
<TD WIDTH="128" CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN> 房间数：</TD>
<TD WIDTH="163"><INPUT NAME="fangjianNum" TYPE="text" SIZE="5"></TD>
</TR>
<TR>
<TD HEIGHT="55" CLASS="RIGHT"> 附言：</TD>
<TD COLSPAN="3"><TEXTAREA NAME="fuyan" COLS="50"></TEXTAREA></TD>
</TR>
<TR>
<TD COLSPAN="4"><HR COLOR="#999999" SIZE="1">
</TR>
<TR>
<TD COLSPAN="4" ALIGN="CENTER">
<INPUT TYPE="submit" NAME="Submit" VALUE="提交">
<INPUT TYPE="reset" NAME="Reset" VALUE="重填"></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -