package test.data.com.sqlite;

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.Toast;

public class MainActivity extends AppCompatActivity {

    Button Insert, Exit, Display;
    EditText e1,e2;
    String nam, coll;
    SQLiteDatabase db;

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

        Insert = (Button) findViewById(R.id.ins);
        Exit= (Button) findViewById(R.id.ext);
        Display= (Button) findViewById(R.id.dis);

        e1 = (EditText) findViewById(R.id.e1);
        e2 = (EditText) findViewById(R.id.e2);

        db = openOrCreateDatabase("Mydb",MODE_PRIVATE,null);
        db.execSQL("CREATE TABLE IF NOT EXISTS student(name VARCHAR,college VARCHAR);");

        Insert.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                nam = e1.getText().toString();
                coll = e2.getText().toString();
                db.execSQL("INSERT INTO student VALUES('"+nam+"','"+coll+"');");
                Toast.makeText(getApplicationContext(),"Row Inserted",Toast.LENGTH_SHORT).show();

            }
        });

        Exit.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                System.exit(0);
            }
        });

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

    }
}