📄 do_order.jsp

📁 一个在线售票系统
💻 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 + -