package com.example.iborland.mysqlll;

import android.os.AsyncTask;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MainActivity extends AppCompatActivity {

    public final String TAG = "LOGGING: ";

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

    MyTask mt;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        mt = new MyTask();
        mt.execute();
        /*DBHelper db = new DBHelper(this, DBHelper.DATABASE_NAME, null, DBHelper.DATABASE_VERSION);
        SQLiteDatabase sdb;
        sdb = db.getReadableDatabase();
        Cursor cursor = ds.query("users", new String[] {"id",
                       "Name", "Password"},
                null, null,
                null, null, null) ;
        if(cursor.getCount() < 1){
            Log.e(TAG, "")
        }*/
    }

    class MyTask extends AsyncTask<Void, Void, Void> {

        @Override
        protected Void doInBackground(Void... params) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
                connection = DriverManager.getConnection("jdbc:mysql://db4free.net:3306/projectz", "iborland",
                        "22599226a");
                statement = connection.createStatement();
                String query = "select * from users";
                rs = statement.executeQuery(query);
                while (rs.next()) {
                    int id = rs.getInt("id");
                    String name = rs.getString("Name");
                    String password = rs.getString("Password");
                    String out = "Пользователь ID: " + id + " || ";
                    out += "Имя: " + name + " || ";
                    out += "Пароль: " + password;
                    Log.e(TAG, out);
                    break;
                }
            } catch (Exception e) {
                Log.e(TAG, "Ошибка загрузки базы: ", e);
                e.printStackTrace();
            }
            return null;
        }
    }
}