?? do_order.jsp
字號:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="search" class="com.db.Common" scope="page"/>
<jsp:useBean id="order" class="com.db.Ticket" scope="page"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>訂票</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/mm_lodging1.css" type="text/css">
</head>
<body>
<%
request.setCharacterEncoding("gb2312");
if(session.getAttribute("isLogin")==null)
{
%>
<jsp:forward page="../login/login.html"/>
<%
}
String username=session.getAttribute("user").toString();
String train_serial=request.getParameter("train_serial");
String from_station=request.getParameter("from_station");
String to_station=request.getParameter("to_station");
String ticket_num=request.getParameter("ticket_num");
String ticket_type=request.getParameter("ticket_type");
String type="";
if(ticket_type.equals("hard_seat"))
type="硬座";
else if(ticket_type.equals("soft_seat"))
type="軟座";
else if(ticket_type.equals("hard_recumbency"))
type="硬臥";
else
type="軟臥";
int num=Integer.parseInt(ticket_num);
String[] stations;
int stations_num=0;
int start_point=0; //計費開始的點
int to_point=0; //計費停止的點
float simple_price=0;
boolean fst_could=false;
boolean second_could=false;
boolean final_could=false;
ResultSet rs_station=search.getResultSetBySql("select * from "+train_serial+"_stations_inf");
ResultSet rs_serial=search.getResultSetBySql("select * from traininf where train_serial='"+train_serial+"'");
ResultSet rs_price=search.getResultSetBySql("select * from "+train_serial+"_"+ticket_type+"_price");
if(order.getCouldOrder(train_serial,type,num)){
if(rs_serial.next())
{
stations_num=rs_serial.getInt(5);
stations=new String[stations_num];
if(rs_station.next())
{
for(int i=1;i<=stations_num;i++)
{
stations[i-1]=rs_station.getString(i+1);
}
}
for(int i=0;i<stations_num;i++)
{
start_point=start_point+1;
if(from_station.equals(stations[i]))
{
fst_could=true;
break;
}
}
for(int i=0;i<stations_num;i++)
{
to_point=to_point+1;
if(to_station.equals(stations[i]))
{
second_could=true;
break;
}
}
if(fst_could&&second_could)
{
final_could=true;
}
}
if(rs_price!=null&&rs_price.next())
{
for(int i=start_point;i<=to_point-start_point;i++)
{
simple_price=simple_price+rs_price.getFloat(i+1);
}
}
float sum_price=simple_price*num;
if(final_could&&((to_point-start_point)>0))
{
order.AddOrder(username,train_serial,from_station,to_station,type,simple_price,sum_price,num);
order.updateTicketNum(type,num,train_serial);
out.println("您訂購了"+num+"張從"+from_station+"到"+to_station+"的車票，您一共需要支付"+sum_price+"元");
out.println("<p>");
out.println("<a href='../user/index.jsp'>返回首頁</a>");
}
else
{
out.println("您的輸入站點和您選擇的列車路線不一致，請您重新輸入");
out.println("<p>");
out.println("<a href='../user/index.jsp'>返回首頁</a>");
}
}
else
{
out.println("系統中已經沒有足夠的票");
out.println("<p>");
out.println("<a href='../user/index.jsp'>選擇別的路線</a>");
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -