package com.example.othones;

import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

import android.database.sqlite.SQLiteDatabase;
import android.widget.EditText;

import org.w3c.dom.Text;


public class Main2Activity extends AppCompatActivity {
    Button btn2;
    Button btn4;


    EditText myedittext1;
    EditText myedittext2;


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

        btn2 = (Button)findViewById(R.id.button2);
        btn4 = (Button)findViewById(R.id.button4);


        myedittext1= (EditText) findViewById(R.id.editText1);
        myedittext2= (EditText) findViewById(R.id.editText2);

        btn2.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent intent = new Intent(Main2Activity.this, MainActivity.class);
                startActivity(intent);
                finish();
            }
        });


        //ΔΗΜΙΟΥΡΓΙΑ ΒΑΣΗΣ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        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);");


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

              //  mydatabase.execSQL("INSERT INTO mytbl (USERNAME, SCORE) VALUES ( text1, text2 );");
                mydatabase.execSQL("INSERT INTO mytbl (USERNAME, SCORE) VALUES ('"+myedittext1.getText().toString()+"' , '"+myedittext2.getText().toString()+"'  );");

            }
        });




    }
}