/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.

 */
package SkyParser;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import de.ailis.pherialize.*;

public class SkyParser {

  public static void main (String[] argv) throws ClassNotFoundException, SQLException
  {
         Connection connect = null;
         Statement statement = null;
         PreparedStatement preparedStatement = null;
         ResultSet resultSet = null;

      Class.forName("com.mysql.jdbc.Driver");
      // пареметры подключения к базе данных
      // host
      String host = "huy";
      String db = "huy";
      String user = "huy";
      String password = "pizda";

      connect = DriverManager.getConnection("jdbc:mysql://"+host+"/"+db+"?user="+user+"&password="+password);

      statement = connect.createStatement();

      // Запрос и результат запроса
      resultSet = statement.executeQuery("SELECT id, firstname, lastname, dateofbirth, identity, id_number, cardholder "
              + "FROM flight_reservation "
              + "WHERE id>=2539377 and firstname<>'' ");
      while (resultSet.next()) {
          //Обрабатываем полученые данные в цикле.
        try {
          MixedArray fname_list, lname_list, bdate_list, doc_list, docnum_list;
          String fname1, fname2, fname3, fname4, fname5, fname6, lname1, lname2, lname3, lname4, lname5, lname6;
          String bdate1, bdate2, bdate3, bdate4, bdate5, bdate6;
          String doc1, doc2, doc3, doc4, doc5, doc6;
          String docnum1, docnum2, docnum3, docnum4, docnum5, docnum6;

          int lname_s, bdate_s, doc_s, docnum_s, i;

          String id = resultSet.getString("id");
          String fname = resultSet.getString("firstname");
          String lname = resultSet.getString("lastname");
//          String cc_name = resultSet.getString("cc_name");
          String cardholder = resultSet.getString("cardholder");
          String bdate = resultSet.getString("dateofbirth");
          //if (resultSet.)
          String doc = resultSet.getString("identity");
          String docnum = resultSet.getString("id_number");
//          String cc_num = resultSet.getString("cc_num");
//          String cc_exp = resultSet.getString("cc_exp");
//          String cc_cvv = resultSet.getString("cc_cvv");
          //String cc_num = resultSet.getString("cc_num");

          //Charset UTF-8;

          fname_list = Pherialize.unserialize(fname).toArray();
          lname_list = Pherialize.unserialize(lname).toArray();
          bdate_list = Pherialize.unserialize(bdate).toArray();
          doc_list = Pherialize.unserialize(doc).toArray();
          docnum_list = Pherialize.unserialize(docnum).toArray();

          //Получаем размер массива имён пассажиров
          //fname_list будет сновным массивом

          int fname_s = fname_list.size();

          //Выводим циклом необходимые нам данные в зависимости от размера массива fname_list
          for (i = 1; i <= fname_s; i++)
                      {
                            String fname_t = fname_list.getString(i);
                            String lname_t = lname_list.getString(i);
                            String bdate_t = bdate_list.getString(i);
                            String doc_t = doc_list.getString(i);
                            String docnum_t = docnum_list.getString(i);

                            System.out.println(""+id+" "+fname_t+" "+lname_t+" "+cardholder+" "+bdate_t+" "+doc_t+" "+docnum_t+"");
                      }



          //System.out.println(""+fname1+" "+lname1+" "+bdate1+" "+doc1+":"+docnum1+"");
        }catch(Exception e){
            System.out.print(e.getStackTrace().toString());
        }
        }
    }

}