import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class Student
{

    int passengerid;
    String fname;
    String lname;
    static String mysql = "jdbc:mysql://localhost:3306/travel?autoReconnect=true&useSSL=false";
    static String username = "root";
    static String password = "student";
    ArrayList<Student> list;

    public Student()
    {

    }

    public Student(int passengerid)
    {
        this.passengerid = passengerid;
    }

    public Student(int passengerid, String fname, String lname)
    {
        this.passengerid = passengerid;
        this.fname = fname;
        this.lname = lname;
    }

    public int getPassengerid()
    {
        return passengerid;
    }

    public String getFname()
    {
        return fname;
    }

    public String getLname()
    {
        return lname;
    }

    public void setPassengerid(int passengerid)
    {
        this.passengerid = passengerid;
    }

    public void setFname(String fname)
    {
        this.fname = fname;
    }

    public void setLname(String lname)
    {
        this.lname = lname;
    }

    public void insert()
    {

    }

    public void select()
    {
        Practice obj = new Practice(mysql, username, password);
        obj.connect();
        list.add(new Student(1, "Curtis", "Brown"));
        list = obj.getData("SELECT * FROM Passenger");
    }

    public void update()
    {

    }

    public void delete()
    {

    }

    public static void main(String[] args)
    {
        Student obj = new Student();
        obj.select();
    }
}