Parsing Railway’s PNR Data (JSON Parsing)

 

Here I am using a Service from the following URL ,

http://pnrapi.appspot.com/<pnr-number>

for example ,

http://pnrapi.appspot.com/1416780219

This gives the data in the following format ,

{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'}],
'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735',
'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH',
'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}

you need to have the following jar files in the classpath ,

D:\fmw1114\Middleware\jdk160_21\bin\javaw.exe -client -classpath C:\JDeveloper\mywork\Application5\Project1\classes;D:\commons-httpclient-3.1\commons-io-2.0.1.jar;D:\commons-httpclient-3.1\json-lib-2.4-jdk15.jar;D:\commons-httpclient-3.1\commons-httpclient-3.1.jar;D:\commons-httpclient-3.1\commons-lang-2.6.jar;D:\commons-httpclient-3.1\commons-logging-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-adapters-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-api-1.1.1.jar;D:\commons-httpclient-3.1\commons-logging-tests.jar;D:\commons-httpclient-3.1\ezmorph-1.0.6.jar;D:\commons-httpclient-3.1\commons-collections-3.2.1.jar;D:\commons-httpclient-3.1\commons-beanutils-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-bean-collections-1.8.3.jar;D:\commons-httpclient-3.1\commons-beanutils-core-1.8.3.jar project1.ParsePNR

package project1;

import java.io.BufferedReader;
import java.io.InputStream;

import java.io.InputStreamReader;

import java.net.URL;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JSONSerializer;
import org.apache.commons.io.IOUtils;


public class ParsePNR {
    public ParsePNR() {
        super();
    }

    public static void main(String[] args) throws Exception {
         //   InputStream is =
          //          ParsingJSON.class.getResourceAsStream( "c:\\sample-json.txt");
            // String jsonTxt = IOUtils.toString( is );
/*
    String test = "\"status\" : \"OK\",\n" + 
    "\"data\" : { \n" + 
    "          \"train_name\" : \"ERNAKULAM EXP\",\n" + 
    "          \"train_number\" : \"*12677\",\n" + 
    "          \"from\" : \"SBC\",\n" + 
    "          \"to\" : \"CBE\",\n" + 
    "          \"alight\" : \"CBE\",\n" + 
    "          \"board\" : \"SBC\",\n" + 
    "          \"class\" : \"2S\",\n" + 
    "          \"travel_date\" : \"2- 6-2011\"\n" + 
    "          \"passenger\" : [ { \"seat_number\" : \"D8  , 31,GN\", \"status\" : \"CNF\" },\n" + 
    "                          { \"seat_number\" : \"D8  , 32,GN\", \"status\" : \"CNF\" } ]\n" + 
    "         }";

// Sample Data (1 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}


// Sample Data (2 passenger)
{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'},{'status': 'G3  , 46', 'seat_number': 'W/L   16,CK'}], 'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', 'train_number': '*12735', 'to': 'YPR', 'board': 'SC', 'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, 'class': '3A'}}

Replace the class with class1 as class is a reserved word in java.

  */
        String pnr="";
        if (args.length == 0 )
            pnr = "1416780219";
        else
            pnr = args[0];
                System.setProperty("http.proxyHost", "www-proxy.us.oracle.com");
        System.setProperty("http.proxyPort", "80");
        System.setProperty("http.nonProxyHosts","*.us.oracle.com|*.oraclecorp.com|*.idc.oracle.com|*.uk.oracle.com|localhost");

            URL url = new URL("http://pnrapi.appspot.com/"+pnr);
            // Read all the text returned by the server
            BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
            String str="";
            String line;
            while ((line = in.readLine()) != null) {
               // str is one line of text; readLine() strips the newline character(s)
              str= str.concat(line );
             //  System.out.println(line);
             System.out.println(str);
            }
            in.close();
      str=   str.replace("'class':","'class1':");
             /*String jsonTxt ="{'status': 'OK', 'data': {'passenger': [{'status': 'G3  , 45', 'seat_number': 'W/L   15,CK'},{'status': 'G3  , 46', 'seat_number': 'W/L   16,CK'}], " +
                "'from': 'SC', 'alight': 'YPR', 'pnr_number': '1416780219', " +
                "'train_number': '*12735', 'to': 'YPR', 'board': 'SC', " +
                "'train_name': 'YPR GARIB RATH', 'travel_date': {'date': '26-6-2011', 'timestamp': 1309046400}, " +
                "'class1': '3A'}}"; */
           String  jsonTxt = str;
            JSONObject json = (JSONObject) JSONSerializer.toJSON( jsonTxt );
            String status = json.getString( "status" );
            if (status.compareToIgnoreCase("INVALID") == 0) {
                
                System.out.println("Status is "+status);
                System.exit(0);
                
            }
            JSONObject data = json.getJSONObject("data");
            String train_name = data.getString("train_name");
            String train_number = data.getString("train_number");
            String class_d = data.getString("class1");
            String from = data.getString("from");
            String alight = data.getString("alight");
          
            
            JSONObject travel_date = data.getJSONObject("travel_date");
           String date = travel_date.getString("date");
          
            
            
            
            System.out.printf( "status: %s\n", status );
           
            System.out.printf( "Train number : %s  Tain Name : %s \n", train_number, train_name );
            System.out.printf( "From : %s To : %s Date Of Travel : %s Class : %s\n", from, alight , date , class_d   );
            
            JSONArray passenger = data.getJSONArray("passenger");
           int i1=0;
                for (Object o : passenger) {
                    i1++;
                    JSONObject passengerDetails = (JSONObject) o;
                    String status_p = passengerDetails.getString("status");
                    String seat_number = passengerDetails.getString("seat_number");
                   
                    System.out.printf( "Passenger : %d Current Status : %s  Previous Staus : %s\n", i1,  status_p, seat_number );
                  
                }

            
           
        }
}