package com.example.othones;

import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.database.Cursor;
import android.widget.EditText;
import android.widget.TextView;


public class MainActivity extends AppCompatActivity {

    Button btn;
    Button btn1;
    Button btn5;
    Intent intent;
    TextView myTextView ;
    EditText myedittext;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        myTextView = (TextView) findViewById(R.id.textView);
        btn = (Button)findViewById(R.id.button);
        btn5 = (Button)findViewById(R.id.button5);

        myedittext= (EditText) findViewById(R.id.editText3);

        btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                intent = new Intent(MainActivity.this, Main2Activity.class);
                startActivity(intent);
                finish();


            }
        });


      btn1 = (Button) findViewById(R.id.button3);


        btn1.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {


                finish();


                System.exit(0);

            }
        });


        //ΔΗΜΙΟΥΡΓΙΑ ΒΑΣΗΣ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        final SQLiteDatabase mydatabase = openOrCreateDatabase("mydatabasedb",MODE_PRIVATE,null);
        //ΔΗΜΙΟΥΡΓΙΑ ΠΙΝΑΚΑ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        mydatabase.execSQL("CREATE TABLE IF NOT EXISTS mytbl(ID INTEGER PRIMARY KEY   AUTOINCREMENT, USERNAME TEXT NOT NULL, SCORE TEXT NOT NULL);");




        btn5.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                //ΑΝΑΖΗΤΗΣΗ ΔΕΔΟΜΕΝΩΝ
                Cursor c = mydatabase.rawQuery("SELECT * FROM mytbl WHERE USERNAME='"+myedittext.getText().toString()+"';", null);

                if (c.moveToFirst()) {
                    myTextView.setText(c.getString(2));
                }
                else { myTextView.setText("ΤΟ ΕΠΙΘΕΤΟ ΔΕΝ ΥΠΑΡΧΕΙ");}

                c.close();


            }
        });







    }
}