Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package sample;
- import java.sql.*;
- import java.util.Vector;
- import model.*;
- import java.util.ResourceBundle;
- import java.net.URL;
- import javafx.fxml.FXML;
- import javafx.scene.control.TextField;
- import javafx.scene.control.cell.PropertyValueFactory;
- import javafx.fxml.Initializable;
- import javafx.scene.control.*;
- import javafx.collections.FXCollections;
- import javafx.collections.ObservableList;
- public class Controller implements Initializable {
- static Vector<StringBuffer> CityVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> AirportVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> FlightVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> PlaneVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> VoyageVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> CarrierVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> ScheduleVec= new Vector<StringBuffer>(1);
- static Vector<StringBuffer> PassengerVec= new Vector<StringBuffer>(1);
- static Vector<Integer> Cityy= new Vector<Integer>(1);
- static Vector<Integer> Countryy= new Vector<Integer>(1);
- static Vector<Integer> AirportNamee= new Vector<Integer>(1);
- static Vector<Integer> Cityidd= new Vector<Integer>(1);
- static Vector<Integer> FlightIDD= new Vector<Integer>(1);
- static Vector<Integer> FlightDatee= new Vector<Integer>(1);
- static Vector<Integer> Voyageidd= new Vector<Integer>(1);
- static Vector<Integer> PlaneIDD= new Vector<Integer>(1);
- static Vector<Integer> PlaneNamee= new Vector<Integer>(1);
- static Vector<Integer> PlaneCapacityy= new Vector<Integer>(1);
- static Vector<Integer> DepartureTimee= new Vector<Integer>(1);
- static Vector<Integer> Capacityy= new Vector<Integer>(1);
- static Vector<Integer> Pricee= new Vector<Integer>(1);
- static Vector<Integer> Flightidd= new Vector<Integer>(1);
- static Vector<Integer> ScheduleIDD= new Vector<Integer>(1);
- static Vector<Integer> DepartureFlightt= new Vector<Integer>(1);
- static Vector<Integer> ArrivalFlightt= new Vector<Integer>(1);
- static Vector<Integer> Class11= new Vector<Integer>(1);
- static Vector<Integer> IdPassengerr= new Vector<Integer>(1);
- static Vector<Integer> Namee= new Vector<Integer>(1);
- static Vector<Integer> Surnamee= new Vector<Integer>(1);
- static Vector<Integer> Emaill= new Vector<Integer>(1);
- static Vector<Integer> Phonee= new Vector<Integer>(1);
- static StringBuffer AirportStringBuffer=null ;
- static StringBuffer CityStringBuffer=null ;
- static StringBuffer FlightStringBuffer=null ;
- static StringBuffer PlaneStringBuffer=null ;
- static StringBuffer VoyageStringBuffer=null ;
- static StringBuffer CarrierStringBuffer=null ;
- static StringBuffer ScheduleStringBuffer=null ;
- static StringBuffer PassengerStringBuffer=null ;
- public Button Add, Add1, Add2, Add3, Add4, Add5, Add6, Add7;
- public TableView<City> a;
- public TableView<Airport> s;
- public TableView<Flight> f;
- public TableView<Plane> p;
- public TableView<Voyage> v;
- public TableView<Carrier> c;
- public TableView<Schedule> sch;
- public TableView<Passenger> pa;
- public TextField CityID, CityName, Country;
- public TextField AirportID, AirportName, Cityid;
- public TextField FlightID, FlightDate, VoyageId, PlaneID;
- public TextField Planeid, PlaneName, PlaneCapacity;
- public TextField VoyageID, StartAirportID, EndAirportID, DepartureTime;
- public TextField CarrierID, Capacity, Price, Flightid;
- public TextField ScheduleID, DepartureFlight, ArrivalFlight, Class1;
- public TextField IdPassenger, Name, Surname, Email, Phone;
- static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
- static final String DB_URL = "jdbc:mysql://mysql.agh.edu.pl:3306/gaszlar1";
- static final String USER = "gaszlar1";
- static final String PASS = "G5C9WwjovojKkH0T";
- public TableColumn<City, String> colCityID;
- public TableColumn<City, String> colCityName;
- public TableColumn<City, String> colCountry;
- public TableColumn<Airport, String> colAirportID;
- public TableColumn<Airport, String> colAirportName;
- public TableColumn<Airport, String> colCityid;
- public TableColumn<Flight, String> colFlightID;
- public TableColumn<Flight, String> colFlightDate;
- public TableColumn<Flight, String> colVoyageid;
- public TableColumn<Flight, String> colPlaneID;
- public TableColumn<Plane, String> colPlaneid;
- public TableColumn<Plane, String> colPlaneName;
- public TableColumn<Plane, String> colPlaneCapacity;
- public TableColumn<Voyage, String> colVoyageID;
- public TableColumn<Voyage, String> colStartAirportID;
- public TableColumn<Voyage, String> colEndAirportID;
- public TableColumn<Voyage, String> colDepartureTime;
- public TableColumn<Carrier, String> colCarrierID;
- public TableColumn<Carrier, String> colCapacity;
- public TableColumn<Carrier, String> colPrice;
- public TableColumn<Carrier, String> colFlightid;
- public TableColumn<Schedule, String> colScheduleID;
- public TableColumn<Schedule, String> colDepartureFlight;
- public TableColumn<Schedule, String> colArrivalFlight;
- public TableColumn<Schedule, String> colClass11;
- public TableColumn<Passenger, String> colIdPassenger;
- public TableColumn<Passenger, String> colName;
- public TableColumn<Passenger, String> colSurname;
- public TableColumn<Passenger, String> colEmail;
- public TableColumn<Passenger, String> colPhone;
- @FXML
- public void Add()
- {
- City city = new City (CityID.getText(),CityName.getText(),Country.getText());
- a.getItems().add(city);
- String getText1=CityID.getText();
- String getText2=CityName.getText();
- String getText3=Country.getText();
- CityID.clear();
- CityName.clear();
- Country.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`City` (`CityID`, `CityName`, `Country`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add1()
- {
- Airport airport = new Airport (AirportID.getText(),AirportName.getText(),Cityid.getText());
- s.getItems().add(airport);
- String getText1=AirportID.getText();
- String getText2=AirportName.getText();
- String getText3=Cityid.getText();
- AirportID.clear();
- AirportName.clear();
- Cityid.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Airport` (`AirportID`, `AirportName`, `CityID`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add2()
- {
- Flight flight = new Flight (FlightID.getText(),FlightDate.getText(),VoyageId.getText(),PlaneID.getText());
- f.getItems().add(flight);
- String getText1=FlightID.getText();
- String getText2=FlightDate.getText();
- String getText3=VoyageId.getText();
- String getText4=PlaneID.getText();
- FlightID.clear();
- FlightDate.clear();
- VoyageId.clear();
- PlaneID.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Flight` (`FlightID`, `FlightDate`, `VoyageID`, `PlaneID`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"','"+getText4+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add3()
- {
- Plane plane = new Plane (Planeid.getText(),PlaneName.getText(),PlaneCapacity.getText());
- p.getItems().add(plane);
- String getText1=PlaneID.getText();
- String getText2=PlaneName.getText();
- String getText3=PlaneCapacity.getText();
- PlaneID.clear();
- PlaneName.clear();
- PlaneCapacity.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Plane` (`PlaneID`, `PlaneName`, `PlaneCapacity`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add4()
- {
- Voyage voyage = new Voyage (VoyageID.getText(), StartAirportID.getText(), EndAirportID.getText(), DepartureTime.getText());
- v.getItems().add(voyage);
- String getText1=VoyageID.getText();
- String getText2=StartAirportID.getText();
- String getText3=EndAirportID.getText();
- String getText4=DepartureTime.getText();
- VoyageID.clear();
- StartAirportID.clear();
- EndAirportID.clear();
- DepartureTime.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Voyage` (`VoyageID`, `StartAirportID`, `EndAirportID`, `DepartureTime`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"', '"+getText4+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add5()
- {
- Carrier carrier = new Carrier (CarrierID.getText(), Capacity.getText(), Price.getText(), Flightid.getText());
- c.getItems().add(carrier);
- String getText1=CarrierID.getText();
- String getText2=Capacity.getText();
- String getText3=Price.getText();
- String getText4=Flightid.getText();
- CarrierID.clear();
- Capacity.clear();
- Price.clear();
- Flightid.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Carrier` (`CarrierID`, `Capacity`, `Price`, `Flightid`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"', '"+getText4+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add6()
- {
- Schedule schedule = new Schedule (ScheduleID.getText(), DepartureFlight.getText(), ArrivalFlight.getText(), Class1.getText());
- sch.getItems().add(schedule);
- String getText1=ScheduleID.getText();
- String getText2=DepartureFlight.getText();
- String getText3=ArrivalFlight.getText();
- String getText4=Class1.getText();
- ScheduleID.clear();
- DepartureFlight.clear();
- ArrivalFlight.clear();
- Class1.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Schedule` (`ScheduleID`, `DepartureFlight`, `ArrivalFlight`, `Class`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"', '"+getText4+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- @FXML
- public void Add7()
- {
- Passenger passenger = new Passenger (IdPassenger.getText(), Name.getText(), Surname.getText(), Email.getText(),Phone.getText());
- pa.getItems().add(passenger);
- String getText1=IdPassenger.getText();
- String getText2=Name.getText();
- String getText3=Surname.getText();
- String getText4=Email.getText();
- String getText4a=Phone.getText();
- IdPassenger.clear();
- Name.clear();
- Surname.clear();
- Email.clear();
- Phone.clear();
- Connection conn = null;
- Statement stmt = null;
- PreparedStatement stmt1 = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- stmt.executeUpdate("INSERT INTO `gaszlar1`.`Passenger` (`IdPassenger`, `Name`, `Surname`, `Email`, `Phone`) VALUES ('"+getText1+"', '"+getText2+"', '"+getText3+"', '"+getText4+"', '"+getText4a+"');");
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- }
- public static Vector<StringBuffer> GetCity() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM City");
- while(rs.next()) {
- String getString1=rs.getString("CityID");
- String getString2=rs.getString("CityName");
- Integer Int1=getString2.length();
- Controller.Cityy.addElement(Int1);
- String getString3=rs.getString("Country");
- Integer Int2=getString3.length();
- Controller.Countryy.addElement(Int2);
- Controller.AirportStringBuffer=new StringBuffer(getString1+getString2+getString3);
- Controller.CityVec.addElement(AirportStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.CityVec;
- }
- public static Vector<StringBuffer> GetAirport() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Airport");
- while(rs.next()) {
- String getString1=rs.getString("AirportID");
- String getString2=rs.getString("AirportName");
- Integer Int1=getString2.length();
- Controller.AirportNamee.addElement(Int1);
- String getString3=rs.getString("Cityid");
- Integer Int2=getString3.length();
- Controller.Cityidd.addElement(Int2);
- Controller.AirportStringBuffer=new StringBuffer(getString1+getString2+getString3);
- Controller.AirportVec.addElement(AirportStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.AirportVec;
- }
- public static Vector<StringBuffer> GetFlight() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Flight");
- while(rs.next()) {
- String getString1=rs.getString("FlightID");
- Integer Int1=getString1.length();
- Controller.FlightIDD.addElement(Int1);
- String getString2=rs.getString("FlightDate");
- Integer Int2=getString2.length();
- Controller.FlightDatee.addElement(Int2);
- String getString3=rs.getString("VoyageId");
- Integer Int3=getString3.length();
- Controller.Voyageidd.addElement(Int3);
- String getString4=rs.getString("PlaneID");
- Integer Int4=getString4.length();
- Controller.PlaneIDD.addElement(Int4);
- Controller.FlightStringBuffer=new StringBuffer(getString1+getString2+getString3+getString4);
- Controller.FlightVec.addElement(FlightStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.FlightVec;
- }
- public static Vector<StringBuffer> GetPlane() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Plane");
- while(rs.next()) {
- String getString1=rs.getString("Planeid");
- String getString2=rs.getString("PlaneName");
- Integer Int2=getString2.length();
- Controller.PlaneNamee.addElement(Int2);
- String getString3=rs.getString("PlaneCapacity");
- Integer Int3=getString3.length();
- Controller.PlaneCapacityy.addElement(Int3);
- Controller.PlaneStringBuffer=new StringBuffer(getString1+getString2+getString3);
- Controller.PlaneVec.addElement(PlaneStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.PlaneVec;
- }
- public static Vector<StringBuffer> GetVoyage() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Voyage");
- while(rs.next()) {
- String getString1=rs.getString("VoyageID");
- String getString2=rs.getString("StartAirportID");
- String getString3=rs.getString("EndAirportID");
- String getString4=rs.getString("DepartureTime");
- Integer Int1=getString4.length();
- Controller.DepartureTimee.addElement(Int1);
- Controller.VoyageStringBuffer=new StringBuffer(getString1+getString2+getString3+getString4);
- Controller.VoyageVec.addElement(VoyageStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.VoyageVec;
- }
- public static Vector<StringBuffer> GetCarrier() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Carrier");
- while(rs.next()) {
- String getString1=rs.getString("CarrierID");
- String getString2=rs.getString("Capacity");
- Integer Int1=getString2.length();
- Controller.Capacityy.addElement(Int1);
- String getString3=rs.getString("Price");
- Integer Int2=getString3.length();
- Controller.Pricee.addElement(Int2);
- String getString4=rs.getString("Flightid");
- Integer Int3=getString4.length();
- Controller.Flightidd.addElement(Int3);
- Controller.CarrierStringBuffer=new StringBuffer(getString1+getString2+getString3+getString4);
- Controller.CarrierVec.addElement(CarrierStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.CarrierVec;
- }
- public static Vector<StringBuffer> GetSchedule() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Schedule");
- while(rs.next()) {
- String getString1=rs.getString("ScheduleID");
- Integer Int1=getString1.length();
- Controller.ScheduleIDD.addElement(Int1);
- String getString2=rs.getString("DepartureFlight");
- Integer Int2=getString2.length();
- Controller.DepartureFlightt.addElement(Int2);
- String getString3=rs.getString("ArrivalFlight");
- Integer Int3=getString3.length();
- Controller.ArrivalFlightt.addElement(Int3);
- String getString4=rs.getString("Class");
- Integer Int4=getString4.length();
- Controller.Class11.addElement(Int4);
- Controller.ScheduleStringBuffer=new StringBuffer(getString1+getString2+getString3+getString4);
- Controller.ScheduleVec.addElement(ScheduleStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.ScheduleVec;
- }
- public static Vector<StringBuffer> GetPassenger() {
- Connection conn = null;
- Statement stmt = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Passenger");
- while(rs.next()) {
- String getString1=rs.getString("IdPassenger");
- Integer Int1=getString1.length();
- Controller.IdPassengerr.addElement(Int1);
- String getString2=rs.getString("Name");
- Integer Int2=getString2.length();
- Controller.Namee.addElement(Int2);
- String getString3=rs.getString("Surname");
- Integer Int3=getString3.length();
- Controller.Surnamee.addElement(Int3);
- String getString4=rs.getString("Email");
- Integer Int4=getString4.length();
- Controller.Emaill.addElement(Int4);
- String abcd5=rs.getString("Phone");
- Integer Int4x=getString4.length();
- Controller.Phonee.addElement(Int4x);
- Controller.PassengerStringBuffer=new StringBuffer(getString1+getString2+getString3+getString4+abcd5);
- Controller.PassengerVec.addElement(PassengerStringBuffer);
- }
- rs.close();
- stmt.close();
- }catch(Exception e){
- e.printStackTrace();
- }
- return Controller.PassengerVec;
- }
- @Override
- public void initialize(URL url, ResourceBundle rb)
- { ObservableList<City> city = FXCollections.observableArrayList();
- colCityID.setCellValueFactory(new PropertyValueFactory<>("CityID"));
- colCityName.setCellValueFactory(new PropertyValueFactory<>("CityName"));
- colCountry.setCellValueFactory(new PropertyValueFactory<>("Country"));
- a.setItems(city);
- ObservableList<Airport> airport = FXCollections.observableArrayList();
- colAirportID.setCellValueFactory(new PropertyValueFactory<>("AirportID"));
- colAirportName.setCellValueFactory(new PropertyValueFactory<>("AirportName"));
- colCityid.setCellValueFactory(new PropertyValueFactory<>("Cityid"));
- s.setItems(airport);
- ObservableList<Flight> flight = FXCollections.observableArrayList();
- colFlightID.setCellValueFactory(new PropertyValueFactory<Flight, String>("FlightID"));
- colFlightDate.setCellValueFactory(new PropertyValueFactory<Flight, String>("FlightDate"));
- colVoyageid.setCellValueFactory(new PropertyValueFactory<Flight, String>("VoyageId"));
- colPlaneID.setCellValueFactory(new PropertyValueFactory<Flight, String>("PlaneID"));
- f.setItems(flight);
- ObservableList<Plane> plane = FXCollections.observableArrayList();
- colPlaneid.setCellValueFactory(new PropertyValueFactory<Plane, String>("Planeid"));
- colPlaneName.setCellValueFactory(new PropertyValueFactory<Plane, String>("PlaneName"));
- colPlaneCapacity.setCellValueFactory(new PropertyValueFactory<Plane, String>("PlaneCapacity"));
- p.setItems(plane);
- ObservableList<Voyage> voyage = FXCollections.observableArrayList();
- colVoyageID.setCellValueFactory(new PropertyValueFactory<Voyage, String>("VoyageID"));
- colStartAirportID.setCellValueFactory(new PropertyValueFactory<Voyage, String>("StartAirportID"));
- colEndAirportID.setCellValueFactory(new PropertyValueFactory<Voyage, String>("EndAirportID"));
- colDepartureTime.setCellValueFactory(new PropertyValueFactory<Voyage, String>("DepartureTime"));
- v.setItems(voyage);
- ObservableList<Carrier> carrier = FXCollections.observableArrayList();
- colCarrierID.setCellValueFactory(new PropertyValueFactory<Carrier, String>("CarrierID"));
- colCapacity.setCellValueFactory(new PropertyValueFactory<Carrier, String>("Capacity"));
- colPrice.setCellValueFactory(new PropertyValueFactory<Carrier, String>("Price"));
- colFlightid.setCellValueFactory(new PropertyValueFactory<Carrier, String>("Flightid"));
- c.setItems(carrier);
- ObservableList<Schedule> schedule = FXCollections.observableArrayList();
- colScheduleID.setCellValueFactory(new PropertyValueFactory<Schedule, String>("ScheduleID"));
- colDepartureFlight.setCellValueFactory(new PropertyValueFactory<Schedule, String>("DepartureFlight"));
- colArrivalFlight.setCellValueFactory(new PropertyValueFactory<Schedule, String>("ArrivalFlight"));
- colClass11.setCellValueFactory(new PropertyValueFactory<Schedule, String>("Class1"));
- sch.setItems(schedule);
- ObservableList<Passenger> passenger = FXCollections.observableArrayList();
- colIdPassenger.setCellValueFactory(new PropertyValueFactory<Passenger, String>("IdPassenger"));
- colName.setCellValueFactory(new PropertyValueFactory<Passenger, String>("Name"));
- colSurname.setCellValueFactory(new PropertyValueFactory<Passenger, String>("Surname"));
- colEmail.setCellValueFactory(new PropertyValueFactory<Passenger, String>("Email"));
- colPhone.setCellValueFactory(new PropertyValueFactory<Passenger, String>("Phone"));
- pa.setItems(passenger);
- Controller.GetCity();
- for(int i=0; i<(Controller.CityVec.size());i++)
- {
- String strVec= CityVec.get(i).toString();
- String strvec1=strVec.substring(0, 3);
- Integer getText1= Controller.Cityy.get(i);
- String strvec2=strVec.substring(3, 3+getText1);
- Integer getText2= Controller.Countryy.get(i);
- String strvec3=strVec.substring(3+getText1,3+ getText1 + getText2);
- city.add(new City(strvec1,strvec2,strvec3));
- }
- Controller.GetAirport();
- for(int i=0; i<(Controller.AirportVec.size());i++)
- {
- String strVec= AirportVec.get(i).toString();
- String strvec1=strVec.substring(0, 3);
- Integer getText1= Controller.AirportNamee.get(i);
- String strvec2=strVec.substring(3, 3+getText1);
- Integer getText2= Controller.Cityidd.get(i);
- String strvec3=strVec.substring(3+getText1, 3+getText1 + getText2);
- airport.add(new Airport(strvec1,strvec2,strvec3));
- }
- Controller.GetFlight();
- for(int i=0; i<(Controller.FlightVec.size());i++)
- {
- String strVec= FlightVec.get(i).toString();
- Integer getText1= Controller.FlightIDD.get(i);
- String strvec1=strVec.substring(0, getText1);
- Integer getText2= Controller.FlightDatee.get(i);
- String strvec2=strVec.substring(getText1, getText1+getText2);
- Integer getText3= Controller.Voyageidd.get(i);
- String strvec3=strVec.substring(getText1+getText2, getText1 + getText2+ getText3);
- Integer getText4= Controller.PlaneIDD.get(i);
- String strvec4=strVec.substring(getText1+getText2+getText3,getText1+ getText2 + getText3+ getText4);
- flight.add(new Flight(strvec1,strvec2,strvec3,strvec4));
- }
- Controller.GetPlane();
- for(int i=0; i<(Controller.PlaneVec.size());i++)
- {
- String strVec= PlaneVec.get(i).toString();
- String strvec1=strVec.substring(0, 5);
- Integer getText2= Controller.PlaneNamee.get(i);
- String strvec2=strVec.substring(5, 5+getText2);
- Integer getText3= Controller.PlaneCapacityy.get(i);
- String strvec3=strVec.substring(5+getText2, 5 + getText2+ getText3);
- plane.add(new Plane(strvec1,strvec2,strvec3));
- }
- Controller.GetVoyage();
- for(int i=0; i<(Controller.VoyageVec.size());i++)
- {
- String strVec= VoyageVec.get(i).toString();
- String strvec1=strVec.substring(0, 7);
- String strvec2=strVec.substring(7, 10);
- String strvec3=strVec.substring(10, 13);
- Integer IntText1= Controller.DepartureTimee.get(i);
- String strvec4=strVec.substring(13, 13+IntText1);
- voyage.add(new Voyage(strvec1,strvec2,strvec3,strvec4));
- }
- Controller.GetCarrier();
- for(int i=0; i<(Controller.CarrierVec.size());i++)
- {
- String strVec= CarrierVec.get(i).toString();
- String strvec1=strVec.substring(0, 7);
- Integer IntText1= Controller.Capacityy.get(i);
- String strvec2=strVec.substring(7, 7+IntText1);
- Integer getText2= Controller.Pricee.get(i);
- String strvec3=strVec.substring(7+IntText1, 7+IntText1+getText2);
- Integer getText3= Controller.Flightidd.get(i);
- String strvec4=strVec.substring(7+IntText1+getText2, 7+IntText1+getText2+getText3);
- carrier.add(new Carrier(strvec1,strvec2,strvec3,strvec4));
- }
- Controller.GetSchedule();
- for(int i=0; i<(Controller.ScheduleVec.size());i++)
- {
- String strVec= ScheduleVec.get(i).toString();
- Integer IntText= Controller.ScheduleIDD.get(i);
- String strvec1=strVec.substring(0, IntText);
- Integer getText1= Controller.DepartureFlightt.get(i);
- String strvec2=strVec.substring(IntText, IntText+getText1);
- Integer getText2= Controller.ArrivalFlightt.get(i);
- String strvec3=strVec.substring(IntText+getText1, IntText+getText1+getText2);
- Integer getText3= Controller.Class11.get(i);
- String strvec4=strVec.substring(IntText+getText1+getText2, IntText+getText1+getText2+getText3);
- schedule.add(new Schedule(strvec1,strvec2,strvec3,strvec4));
- }
- Controller.GetPassenger();
- for(int i=0; i<(Controller.PassengerVec.size());i++)
- {
- String strVec= PassengerVec.get(i).toString();
- Integer IntText= Controller.IdPassengerr.get(i);
- String strvec1=strVec.substring(0, IntText);
- Integer getText1= Controller.Namee.get(i);
- String strvec2=strVec.substring(IntText, IntText+getText1);
- Integer getText2= Controller.Surnamee.get(i);
- String strvec3=strVec.substring(IntText+getText1, IntText+getText1+getText2);
- Integer getText3= Controller.Emaill.get(i);
- String strvec4=strVec.substring(IntText+getText1+getText2, IntText+getText1+getText2+getText3);
- String strvec5=strVec.substring(IntText+getText1+getText2+getText3);
- passenger.add(new Passenger(strvec1,strvec2,strvec3,strvec4,strvec5));
- }}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement