package com.tei.kokkonis.mydatabase;

import android.database.Cursor;
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.widget.EditText;
import android.widget.TextView;


public class MainActivity extends AppCompatActivity {


    TextView mTextView ;

    EditText myedittext;
    
    Button btn;
    

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);


        mTextView = (TextView) findViewById(R.id.textView1);
        myedittext= (EditText) findViewById(R.id.editText);


        btn = (Button)findViewById(R.id.button);

        //ΔΗΜΙΟΥΡΓΙΑ ΒΑΣΗΣ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
       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, PHONE TEXT NOT NULL);");
        
        //ΕΙΣΑΓΩΓΗ ΔΕΔΟΜΕΝΩΝ
        mydatabase.execSQL("INSERT INTO mytbl    (USERNAME, PHONE) VALUES ( 'KOKKONIS', '2462061626' );");
        mydatabase.execSQL("INSERT INTO mytbl    (USERNAME, PHONE) VALUES ( 'KOKKONIS2', '2462061623' );");


        btn.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()) {
                    mTextView.setText(c.getString(2));
                }
                else { mTextView.setText("cant find");}

                c.close();

            }// onclick
        }); //gia ton listener





    }
}