package Reports;

import java.io.EOFException;
import java.io.File;
import java.io.FileInputStream;
import java.io.ObjectInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;

import Air.AirGourmetUtilities;
import Air.CFlightRecord;



//Nick was here

public class CReport
{
  //
  // data members
  //

  private final String DB_URL = "jdbc:mysql://localhost/se4453?useSSL=false";
  private final String DB_USER = "root";
  private final String DB_PASS = "123456";

[...]

         try
          {

            Connection dbCon = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);

            String sql = "SELECT * FROM FlightRecord;";

            Statement stmt = dbCon.createStatement();
            ResultSet res = stmt.executeQuery(sql);

            while (res.next())
            {
                tempFltRec = new CFlightRecord();

                tempFltRec.setPassengerID(res.getString(1));
                tempFltRec.setReservationID(res.getString(2));
                tempFltRec.setFlightNum(res.getString(3));
                tempFltRec.setFlightDate(res.getDate(4));