package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import org.json.JSONArray;

public class CON {

    public static void main(String[] argv) {

        System.out.println("-------- PostgreSQL "
                + "JDBC Connection Testing ------------");

        try {

            Class.forName("org.postgresql.Driver");

        } catch (ClassNotFoundException e) {

            System.out.println("Where is your PostgreSQL JDBC Driver? "
                    + "Include in your library path!");
            e.printStackTrace();
            return;

        }

        System.out.println("PostgreSQL JDBC Driver Registered!");

        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        try {

            connection = DriverManager.getConnection(
                    "jdbc:postgresql://192.168.60.120/sandbox_timetable", "sandbox",
                    "sandbox");

            Statement select = connection.createStatement();
            resultSet = select.executeQuery("SELECT * FROM trains");
              while (resultSet.next())
              {
                  String id = resultSet.getString("id");
                  String number = resultSet.getString("number");
                  String carrier = resultSet.getString("carrier");
                  Integer category = resultSet.getInt("category");
                  String name = resultSet.getString("name");

                 JSONArray arrayObj = new JSONArray();

              }

        } catch (SQLException e) {

            System.out.println("Connection Failed! Check output console");
            e.printStackTrace();
            return;

        }

        if (connection != null) {
            System.out.println("You made it, take control your database now!");
        } else {
            System.out.println("Failed to make connection!");
        }
    }

}