package com.teigrevena.optikos.database;

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

public class Main2Activity extends AppCompatActivity {


    EditText myedittext1;
    EditText myedittext2;
    Button btn3;




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


        //ΔΗΜΙΟΥΡΓΙΑ ΒΑΣΗΣ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        final SQLiteDatabase mydatabase = openOrCreateDatabase("myonomadb",MODE_PRIVATE,null);


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

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

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


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

                mydatabase.execSQL("INSERT INTO mytbl (USERNAME, PHONE) VALUES ('"+myedittext1.getText().toString()+"' , '"+myedittext2.getText().toString()+"'  );");

            }
        });








    }
}