/**
 * Created by Natan on 23.10.2016..
 */
import java.io.IOException;
import java.sql.*;
import java.util.ArrayList;

/**
 * Created by Natan on 23.10.2016..
 */
public class Practice
{
    static String mysql = "jdbc:mysql://localhost:3306/travel?autoReconnect=true&useSSL=false";
    static String username = "root";
    static String password = "student";
    Connection conn;
    boolean var;

    public Practice(String mysql, String username, String password)
    {
        this.mysql = mysql;
        this.username = username;
        this.password = password;
    }

    public boolean connect()
    {
        boolean var = false;
        try
        {
            conn = DriverManager.getConnection(mysql, username, password);
            if(conn == null)
            {
                var = false;
            }
            else
            {
                var = true;
            }
        }
        catch(SQLException sqle)
        {
            System.out.println("fdssdf");
        }
        return var;
    }

    public boolean close()
    {
        boolean var = false;
        try
        {
            conn.close();
            if(conn.isClosed())
            {
                System.out.println("Connection closed");
                var = true;
            }
            else
            {
                System.out.println("Connection not closed");
                var = false;
            }
        }
        catch(SQLException sqle)
        {

        }
        return var;
    }

    public ArrayList<Student> getData(String sql)
    {
        ArrayList<Student> list = null;
        int passengerid = 0;
        String fname = null;
        String lname = null;
        try
        {
            Statement statement = conn.createStatement();
            ResultSet rs = statement.executeQuery(sql);

            while(rs.next())
            {
                passengerid = rs.getInt(1);
                fname = rs.getString(2);
                lname = rs.getString(3);
            }

            System.out.println("PassengerID " + passengerid + "\n");
            System.out.println("PassengerID " + fname + "\n");
            System.out.println("PassengerID " + lname + "\n");
        }
        catch(SQLException sqle)
        {

        }
        return list;
    }

    public static void main(String[] args)
    {
        Practice obj = new Practice(mysql, username, password);
        obj.connect();
        System.out.println("Connected");
        obj.close();
    }
}