后台代码之买票和查找核实航班的代码

最新推荐文章于 2024-07-17 09:10:45 发布

转载最新推荐文章于 2024-07-17 09:10:45 发布 · 132 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zzzzw/p/4818929.html

本文详细介绍了如何通过后台接口实现机票购买及航线查找功能，包括头等舱、商务舱、经济舱和特惠舱的购票流程，以及根据出发地、目的地和日期查找适合的航线，提供票价和座位信息。

//后台买票
    public List<String[]> buy(Integer lid,String radio1) {
    List<String[]> result=new ArrayList<String[]>();
    if(radio1.toString().equals("头等舱"))
    {
        String sql="SELECT b.`name`,a.linename,\r\n" + 
        " a.startplace,a.endplace,a.planedate,a.starttime,a.endtime " + 
        ",a.id,d.planetype,d.tdcprice"+
        " from line a,aircompany b,plane d\r\n" + 
        " where a.id=? AND b.id=a.pid AND d.lname=a.linename;"; 
        Query q=gs().createSQLQuery(sql);
        q.setParameter(0, lid);
        result=q.list();
    }
    else if(radio1.toString().equals("商务舱"))
    {
        String sql="SELECT b.`name`,a.linename,\r\n" + 
        " a.startplace,a.endplace,a.planedate,a.starttime,a.endtime " + 
        ",a.id,d.planetype,d.swcprice"+
        " from line a,aircompany b,plane d\r\n" + 
        " where a.id=? AND b.id=a.pid AND d.lname=a.linename;";
        Query q=gs().createSQLQuery(sql);
        q.setParameter(0, lid);
        result=q.list();
    }
    else if(radio1.toString().equals("经济舱"))
    {
        String sql="SELECT b.`name`,a.linename,\r\n" + 
        " a.startplace,a.endplace,a.planedate,a.starttime,a.endtime " + 
        ",a.id,d.planetype,d.jjcprice"+
        " from line a,aircompany b,plane d\r\n" + 
        " where a.id=? AND b.id=a.pid AND d.lname=a.linename;";
        Query q=gs().createSQLQuery(sql);
        q.setParameter(0, lid);
        result=q.list();
    }
    else if(radio1.toString().equals("特惠舱"))
    {
        String sql="SELECT b.`name`,a.linename,\r\n" + 
        " a.startplace,a.endplace,a.planedate,a.starttime,a.endtime " + 
        ",a.id,d.planetype,d.thcprice"+
        " from line a,aircompany b,plane d\r\n" + 
        " where a.id=? AND b.id=a.pid AND d.lname=a.linename;";
            Query q=gs().createSQLQuery(sql);
        q.setParameter(0, lid);
        result=q.list();
    }
    
    
    return result;
    
    }

    //查找适合的航线
    public List<String[]> searchLine(String sfz,String ddz,String cfrq){
    List<String[]> result =new ArrayList();
    List list=new ArrayList();
    String sql=" SELECT b.`name`,a.linename,a.startplace,a.starttime,a.endplace,a.endtime ,\r\n" + 
            "d.tdcprice,c.tdcnum,d.swcprice,c.swcnum,d.jjcprice,c.jjcnum,d.thcprice,c.thcnum,\r\n" + 
            "d.planetype,a.id,b.logourl,d.tdcnum as tdcnum1,d.swcnum as swcnum1,d.jjcnum as jjcnum1,d.thcnum as thcnum1,"+
            "c.id as cid ,c.planedate as cplanedate from line a,aircompany b ,seatnum c,plane d\r\n" + 
            " WHERE a.pid=b.id and a.startcity=?\r\n" + 
            " AND a.endcity=? AND a.planedate=? AND c.lname=a.linename"+
            " AND d.lname=a.linename ";            
    Query q=gs().createSQLQuery(sql);
    q.setParameter(0, sfz);
    q.setParameter(1, ddz);
    q.setParameter(2, cfrq);
    result=q.list();
    return result;    
    }