package com.example.xristos.e_lib;

import android.os.AsyncTask;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.TextView;
import android.widget.Toast;

import java.io.DataInputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.net.Socket;
import java.nio.charset.Charset;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;
import java.util.Random;

public class MainActivity extends AppCompatActivity {
    public static int id;   //to id pou tha stelnei stin vasi
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

  public void scan(View v){
      Random r = new Random();
      id= r.nextInt(15)+1;
      Toast.makeText(MainActivity.this,String.valueOf(id),Toast.LENGTH_LONG).show();
  }

  private class DBTask extends AsyncTask<Void, Void, List<String>> {
        private static final String url = "jdbc:mysql://vale_ip:porta/onomavasis";
        private static final String user = "vale_user";
        private static final String pass = "vale_pass";

        @Override
        protected List<String> doInBackground(Void... params) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection(url, user, pass);
                Statement st = con.createStatement();
                ResultSet rs = st.executeQuery("SELECT * FROM to_onoma_tou_table_sou WHERE ID="+id);
                while(rs.next()){
////////////edo mporeis na kaneis diafora me tin kathe grammi pou sou girnaei
//////////px gia na pareis tin timi mias stilis "kek" pou periexei string mporeis na kaneis String kek = rs.getString("kek");
/////////oti timi valeis stin metavliti "output" apo kato ego grapsei na sou emfanizetai sto text view
                    String output="";
                    TextView tv = (TextView)findViewById(R.id.tv);
                    runOnUiThread(new Runnable() {
                        @Override
                        public void run() {
                            final tv.setText(output);
                        }
                    });
                }
                st.close();
                con.close();
            }
            catch(Exception e) {
                e.printStackTrace();
            }
            return null;
        }
  }

}