<%@ page contentType="text/html;charset=GBK"%> <%@ page import="com.oaking.common.tools.Utils"%> <%@ page import="com.oaking.common.db.ExecuteBean" %> <%@ page import="com.oaking.common.db.ResultBean" %> <% request.setCharacterEncoding("GBK"); String strSQL = ""; String flightno_foc = ""; String flightdate = ""; String flightno = ""; String departure_city = ""; String arrival_city = ""; String mobile = ""; String content = ""; String command = ""; ResultBean rb = new ResultBean(); boolean isShowSearch = true; boolean isShowCustom = false; //日期和航班号 flightdate = request.getParameter("flightdate"); flightno = request.getParameter("flightno"); if ( flightdate==null ) flightdate = Utils.now("YYYY-MM-DD"); if ( flightno==null ){ flightno = "ZH"; }else{ flightno = flightno.toUpperCase(); } command = request.getParameter("command"); if ( command==null || command.equals("") ) { isShowSearch = true; isShowCustom = false; }else if ( command.equals("search") ) { isShowSearch = false; isShowCustom = true; //查询FOC航班 strSQL = "SELECT CONCAT('ZH',FIRST_FLIGHT_NO), CONCAT('ZH',SECOND_FLIGHT_NO) FROM T4031@BFOC1 WHERE "; strSQL += "CONCAT('ZH',ETERM_FLIGHT_NO) = '" + flightno + "'"; ExecuteBean eb = new ExecuteBean(strSQL,"szfoc"); rb = eb.executeSelectAll(); if ( rb.getRowsCount()>0 ) { flightno_foc = "'" + rb.getResult(0,0) + "','" + rb.getResult(0,1) + "'"; }else{ flightno_foc = "'" + flightno + "'"; } //查询出发和目的城市 strSQL = "SELECT A.DEPARTURE_AIRPORT,B.CITY_CH_NAME,A.ARRIVAL_AIRPORT,C.CITY_CH_NAME "; strSQL += "FROM T2001 A, T7001 B, T7001 C "; strSQL += "WHERE A.FLIGHT_DATE = TO_DATE('" + flightdate + "','YYYY-MM-DD') AND "; strSQL += "A.FLIGHT_NO IN (" + flightno_foc + ") AND "; strSQL += "A.DEPARTURE_AIRPORT = B.AIRPORT_4CODE AND A.ARRIVAL_AIRPORT = C.AIRPORT_4CODE ORDER BY A.HTD"; eb = new ExecuteBean(strSQL,"szfoc"); rb = eb.executeSelectAll(); if ( rb.getRowsCount() < 1 ) { response.sendRedirect("dynaFlight.jsp"); } } else if ( command.equals("custom") ) { isShowSearch = true; isShowCustom = false; departure_city = request.getParameter("departure_city"); arrival_city = request.getParameter("arrival_city"); mobile = request.getParameter("mobile"); content = "HBDT " + flightdate.substring(0,4) + flightdate.substring(5,7) + flightdate.substring(8,10) + " "; content += flightno.toUpperCase() + " "; content += departure_city + "至" + arrival_city; //提交定制信息 strSQL = "INSERT INTO SM_RECEIVED (SRID, DESTADDR, ORGADDR, CONTENT, RECEIVETIME, DEALFLAG) "; strSQL += "VALUES ( seq_srid.nextval, '106988895080', '" + mobile + "','" + content + "', sysdate, 0)"; // out.println("!!!!!!!!!!!!!!!!!!!!!!"); if ( mobile!=null && !mobile.equals("") ) { // out.println(strSQL); ExecuteBean eb = new ExecuteBean(strSQL,"sendmessage"); eb.executeInsert(); } } %> 深圳航空有限责任公司-Shenzhen AirLines <%@include file="/include/top.jsp"%> <% } %>


鲲鹏通--航班动态信息定制
    当您的亲朋好友在旅途中时，如果您希望了解该航班的动态信息，您可以使用该服务进行预订，系统将在您预订的当天向您发送该航班的动态信息。
    回复示例：
    您好，2007/01/01，ZH9801深圳至北京的航班计划起飞时间12:40，计划到达时间15:40。（此条短信在您定制后即时发送）其他信息根据该航班动态情况向您发送。
    说明：
    （1） 您预订的航班日期需在三日以内（如2007年01月01日可以预订的航班为1－3日内）；
    （2） 由于航班的正常性会受天气、机场流量等多方面影响，存在很多不确定性因素，因此该项服务仅作为您的参考信息，如需详细了解请致电95080或当地机场查询。
<% if ( isShowCustom ) { %>
航班日期：
航班号：
 > <% if ( isShowSearch ) { %><% } %>
出 发 地：
到 达 地：
  
手机号码：
    



<%@include file="/include/bottom.jsp"%>