flightservskeleton.txt

机票预订系统 方便大家使用哈！！！ 请多多支持 给我宝贵的意见

    /**
     * FlightServSkeleton.java
     *
     * This file was auto-generated from WSDL
     * by the Apache Axis2 version: 1.2 Apr 27, 2007 (04:35:37 IST)
     */
    package de.axisflights2.booking.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Timestamp;
import java.sql.*;
import java.util.*;


import de.axisflights2.booking.types.*;
    /**
     *  FlightServSkeleton java skeleton for the axisService
     */
    public class FlightServSkeleton implements FlightServSkeletonInterface{
        
         
        /**
         * Auto generated method signature
         
         
                                     * @param getFlightsRequest0
         */
        

                 public de.axisflights2.booking.types.GetFlightsResponse GetFlights
                  (
                  de.axisflights2.booking.types.GetFlightsRequest getFlightsRequest0
                  )
            throws InvalidDateFaultException{
                //Todo fill this with the necessary business logic
                     GetFlightsResponse getRP=new GetFlightsResponse();
                     ArrayOfFlights arrayF = new ArrayOfFlights();
                	 String arrivedate=getFlightsRequest0.getArrivalDate(); 
                	 String departuredate=getFlightsRequest0.getDepartureDate();
                	 String toairport=getFlightsRequest0.getToAirport();
                	 String fromairport=getFlightsRequest0.getFromAirport();

                	 JDBCconnection conn =new JDBCconnection();
                	 Connection cn=conn.conn();
                	 
                	try{
                		Statement s=cn.createStatement();
                		ResultSet rs=s.executeQuery("SELECT flightID,flightNumber,fromAirport,toAirport,departureDateTime,arriveDateTime,fareBasis FROM flight WHERE fromAirport LIKE"+fromairport+" AND toAirport LIKE"+toairport+" AND departureDateTime LIKE "+departuredate+"AND arriveDateTime LIKE "+arrivedate+"");
                		while(rs.next())
                		{
                			Flight flight=new Flight();
                			flight.setFlightID(rs.getInt(1));
                			flight.setFlightNumber(rs.getString(2));
                			flight.setFromAirport(rs.getString(3));
                			flight.setToAirport(rs.getString(4));
                		
                			flight.setDepartureDateTime(rs.getString(5));
                			flight.setArrivalDateTime(rs.getString(6));
                			flight.setFareBasis(rs.getString(7));
                			
                			arrayF.addFlight(flight);
                			
                			s.close();
                    		cn.close();
                		}
                		
                	}
                	catch(Exception e){}
                    getRP.setGetFlightsResponse(arrayF);
                	return getRP;
                	
                //throw new  java.lang.UnsupportedOperationException("Please implement " + this.getClass().getName() + "#GetFlights");
        }
     
         
        /**
         * Auto generated method signature
         
         
                                     * @param setPassengerDetailsRequest2
         */
        

                 public de.axisflights2.booking.types.SetPassengerDetailsResponse SetPassengerDetails
                  (
                  de.axisflights2.booking.types.SetPassengerDetailsRequest setPassengerDetailsRequest2
                  )
            throws AlreadyInDBFaultException{
                //Todo fill this with the necessary business logic
                	 SetPassengerDetailsResponse setPD =new SetPassengerDetailsResponse();
                	 String name =setPassengerDetailsRequest2.getName();
                	 String surname =setPassengerDetailsRequest2.getSurname();
                	 String cityadd =setPassengerDetailsRequest2.getCityAddress();
                	 String countryadd = setPassengerDetailsRequest2.getCountryAddress();
                	 String streetadd = setPassengerDetailsRequest2.getStreetAddress();
                	 String zipadd = setPassengerDetailsRequest2.getZipAddress();
                	 JDBCconnection conn =new JDBCconnection();
                	 Connection cn=conn.conn();
                	 int passengerID;
                	 try{
                 		Statement s=cn.createStatement();
                 		Statement s1=cn.createStatement();
                 		s.executeUpdate("INSERT INTO passenger(Name,Surname,StreetAddress,CityAddress,ZipAddress,CountryAddress)"+"VALUES"+"("+name+surname+streetadd+cityadd+zipadd+countryadd	+")");
      
                 		ResultSet rs=s1.executeQuery("SELECT MAX passengerID FROM passenger" );
                 	    passengerID =rs.getInt(1);
                	 
                 		s.close();
                 		s1.close();
                 		rs.close();
                 		cn.close();
                 		setPD.setPassengerID(passengerID);
                 	}
                 	catch(Exception e){}
                 	
                 	return setPD;
                //throw new  java.lang.UnsupportedOperationException("Please implement " + this.getClass().getName() + "#SetPassengerDetails");
        }
     
         
        /**
         * Auto generated method signature
         
         
                                     * @param makeBookingRequest4
         */
        

                 public de.axisflights2.booking.types.MakeBookingResponse MakeBooking
                  (
                  de.axisflights2.booking.types.MakeBookingRequest makeBookingRequest4
                  )
            throws InvalidIdFaultException{
                //Todo fill this with the necessary business logic
                	 MakeBookingResponse makeBR=new MakeBookingResponse();
                	 int AgencyID=makeBookingRequest4.getAgencyID();
                	 int BookingClassID=makeBookingRequest4.getBookingClassID();
                	 int FlightID=makeBookingRequest4.getFlightID();
                	 int passengerID=makeBookingRequest4.getPassengerID();
                	 int BookingID;
                	 JDBCconnection conn =new JDBCconnection();
                	 Connection cn=conn.conn();
                	 
                	try{
                		Statement s=cn.createStatement();
                		Statement s1=cn.createStatement();
                		s.executeUpdate("INSERT INTO booking (flightID,bookingClassId,passengerId,agencyID)"+"VALUES"+"("+FlightID+BookingClassID+passengerID+AgencyID+")");
                		ResultSet rs=s1.executeQuery("SELECT MAX bookingId FROM booking" );
                 	    BookingID =rs.getInt(1);
                	    s.close();
                	    s1.close();
                	    rs.close();
                    	cn.close();
                    	makeBR.setBookingID(BookingID);
                		}
                		
                	
                	catch(Exception e){}
                    
                	return makeBR;
                	 
                	 
                //throw new  java.lang.UnsupportedOperationException("Please implement " + this.getClass().getName() + "#MakeBooking");
        }
     
         
        /**
         * Auto generated method signature
         
         
                                     * @param cancelBookingRequest6
         */
        

                 public de.axisflights2.booking.types.CancelBookingResponse CancelBooking
                  (
                  de.axisflights2.booking.types.CancelBookingRequest cancelBookingRequest6
                  )
            throws InvalidIdFaultException{
                //Todo fill this with the necessary business logic
                	 CancelBookingResponse cancelBR=new CancelBookingResponse();
                	 
                	 int bookingid=cancelBookingRequest6.getBookingID();
                	 int bid;
                	 
                	 
                	 JDBCconnection conn =new JDBCconnection();
                	 Connection cn=conn.conn();
                	 
                	try{
                		Statement s=cn.createStatement();
                		Statement s1=cn.createStatement();
                		Statement s2=cn.createStatement();
                		ResultSet rs=s.executeQuery("SELECT flightID,bookingId From booking WHERE bookingId LIKE"+bookingid+"");
                	    
                	    int flightid=rs.getInt(1); 
                	    bid =rs.getInt(2);
                	    ResultSet rs1 = s1.executeQuery("SELECT departureDateTime From flight WHERE flightID="+flightid+"");
                	    Timestamp departuretime = rs1.getTimestamp(1);
                	    
                	    GregorianCalendar thisday = new GregorianCalendar(); 
                	    GregorianCalendar departureTM = new GregorianCalendar(departuretime.getYear(),departuretime.getMonth(),departuretime.getDay());
                	    thisday.add(GregorianCalendar.DATE, 14);
                        if(thisday.before(departureTM))
                        { 
                        	s2.executeUpdate("DELETE ALL FROM booking WHERE bookingId="+bid+"");
                            cancelBR.setBookingID(bid);	
                            s2.close();}
                        else
                        {cancelBR.setBookingID(0);
                        s2.close();
                        }
                        
                	    s.close();
                        s1.close();
                        
                	    rs.close();
                	    rs1.close();
                    	cn.close();
                       
                   
                		}
                		
                	
                	catch(Exception e){}

                	return cancelBR;
                	 
                	 
                	 
                //throw new  java.lang.UnsupportedOperationException("Please implement " + this.getClass().getName() + "#CancelBooking");
        }
     
         
        /**
         * Auto generated method signature
         
         
                                     * @param checkAvailabilityRequest8
         */
        

                 public de.axisflights2.booking.types.CheckAvailabilityResponse CheckAvailability
                  (
                  de.axisflights2.booking.types.CheckAvailabilityRequest checkAvailabilityRequest8
                  )
                 //Todo fill this with the necessary business logic
                 {
                 CheckAvailabilityResponse checkAR=new CheckAvailabilityResponse();
                 
                 int flightid=checkAvailabilityRequest8.getFlightID();
                 int bookingclassid=checkAvailabilityRequest8.getBookingClassID();
                 int numOfS;
                 JDBCconnection conn =new JDBCconnection();
            	 Connection cn=conn.conn();
            	 
            	try{
            		Statement s=cn.createStatement();
            		ResultSet rs=s.executeQuery("SELECT flightId,bookingClassId,numberOfSeats From availability WHERE flightId ="+flightid+" AND bookingClassId = "+bookingclassid);
            	    numOfS=rs.getInt(3);
            	    de.axisflights2.booking.types.Availability availability =new de.axisflights2.booking.types.Availability();
            	    availability.setNumberOfSeats(numOfS);
            	    availability.setBookingClassID(rs.getInt(2));
            	    availability.setFlightID(rs.getInt(1));
            	    if(numOfS>0)
            	    {checkAR.setCheckAvailabilityResponse(availability);
            	    s.close();
            	    }
            	    else
            	    {checkAR.setCheckAvailabilityResponse(null); 
            	    s.close();
            	    }
            	 
            			
            	    
                	cn.close();
            		}
            		
            	
            	catch(Exception e){}
                
            	return checkAR;
                 
       
                //throw new  java.lang.UnsupportedOperationException("Please implement " + this.getClass().getName() + "#CheckAvailability");
        }
     
    }