package com.javanigga.lovershaters.lovershaters;

import android.content.Context;
import android.content.DialogInterface;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.Toast;

import java.sql.Array;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import android.os.Handler;
import android.os.Message;


public class mainPage extends AppCompatActivity {

    Connection connection;//Connection variable
    Statement statement;//Statement variable
    ResultSet resultSet;//ResultSet variable
    ResultSetMetaData rsmeta;
    String url = "jdbc:mysql://SERVER NAME:3306/DATABASE NAME" + "?user=USER NAME" + "&password=USER PASSWORD"  + "&useUnicode=true&characterEncoding=UTF-8";//URL dtabase

    Context context = this;
    int columnsCounter = 1;
    int arrayCounter = 1;
    int rowsCounter = 1;
    int rowSize;
    Object[] array = new Object[500]; // THIS ARRAY OBJECT MUST BE GREATER THAN THE RECORD NUMBER OF YOUR TABLE


    public void dataBaseConection()
    {
        final Handler succesHandler = new Handler()
        {
            @Override
            public void handleMessage(Message msg) {
                try {
                    Toast.makeText(context, connection.getCatalog(), Toast.LENGTH_LONG).show();
                    for (int i = 0; i < rsmeta.getColumnCount() * rowSize; i++)
                    {
                        Toast.makeText(context, array[i].toString(), Toast.LENGTH_LONG).show();
                    }

                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        };

        final Handler exceptionHandler = new Handler()
        {
            @Override
            public void handleMessage(Message msg) {
                Toast.makeText(context, msg.toString(), Toast.LENGTH_LONG).show();
            }
        };

        final Runnable conectRun = new Runnable() {
            @Override
            public void run() {
                try
                {
                    Class.forName("com.mysql.jdbc.Driver");
                    connection = DriverManager.getConnection(url);
                    statement = connection.createStatement();
                    resultSet = statement.executeQuery("SELECT * FROM tablaentradas");

                    rsmeta = resultSet.getMetaData();


                    columnsCounter = 1;
                    arrayCounter = 1;
                    rowsCounter = 1;


                    resultSet.last();

                    rowSize = resultSet.getRow();

                    resultSet.first();




                    do {
                        while (columnsCounter <= rsmeta.getColumnCount())
                        {

                            array[arrayCounter - 1] = resultSet.getObject(columnsCounter);


                            columnsCounter++;
                            arrayCounter ++;
                        }

                        rowsCounter++;
                        resultSet.absolute(rowsCounter);
                        columnsCounter = 1;
                    }while (rowsCounter <= rowSize);

                    if (rowsCounter > rowSize)
                    {
                        succesHandler.sendEmptyMessage(0);
                    }

                }catch (Exception e)
                {
                    String exceptio = e.toString();
                    Message msg = Message.obtain();
                    msg.obj = exceptio;
                    exceptionHandler.sendMessage(msg);
                }
            }
        };

        Thread conectionThread = new Thread(conectRun);
        conectionThread.start();




    }




}