package com.rough.problem.problem9;

import android.graphics.Color;
import android.graphics.PorterDuff;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.EditText;

public class MainActivity extends AppCompatActivity {
    EditText Select;
    DatabaseHelper myDB;


    @Override

    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        myDB = new DatabaseHelper(this);

      Select = (EditText) findViewById(R.id.SelectStatement);


     //   Select.getBackground().setColorFilter(Color.YELLOW, PorterDuff.Mode.SRC_ATOP);

    }



    public boolean onCreateOptionMenu (Menu menu){
        getMenuInflater().inflate(R.menu.menu_main,menu);
        return true;
    }


    public boolean onOptionsItemSelected(MenuItem item){
        int id = item.getItemId();
        return true;
    }
}

package com.rough.problem.problem9;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;



public class DatabaseHelper extends SQLiteOpenHelper {
 public static final String DATABASE_NAME = "SPdb.db";
 public static final String TABLE_NAME = "s";
 public static final String COL_1 = "sno";
 public static final String COL_2 = "sname";
 public static final String COL_3 = "city";


    public static final String TABLENAME = "p";
    public static final String COL1 = "pno";
    public static final String COL2 = "pname";
    public static final String COL3 = "cost";
    public static final String COL4 = "city";

    public static final String TableNAME = "sp";
    public static final String COLUMN1 = "sno";
    public static final String COLUMN2 = "pno";
    public static final String COLUMN3 = "qty";




    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
        SQLiteDatabase db = this.getWritableDatabase();

    }


    @Override
    public void onCreate(SQLiteDatabase db) {
        String query = "Create Table IF NOT EXISTS " + TABLE_NAME + "(" +
                COL_1 + "TEXT PRIMARY KEY COLLATE NOCASE," +
                COL_2 + "TEXT NOT NULL COLLATE NOCASE," +
                COL_3 + "TEXT NOT NULL COLLATE NOCASE" +
                ");";
        db.execSQL(query);

        String query1 = "Create Table IF NOT EXISTS " + TABLENAME + "(" +
                COL1 + "TEXT NOT NULL COLLATE NOCASE," +
                COL2 + "TEXT NOT NULL COLLATE NOCASE," +
                COL3 + "REAL NOT NULL ," +
                COL4 + "TEXT NOT NULL COLLATE NOCASE" +
                ");";
        db.execSQL(query1);

        String query2 = "Create Table IF NOT EXISTS " + TableNAME + "(" +
                COLUMN1 + "TEXT NOT NULL REFERENCES s(sno) COLLATE NOCASE," +
                COLUMN2 + "TEXT NOT NULL COLLATE NOCASE," +
                COLUMN3 + "INTEGER NOT NULL " +
                ");";
        db.execSQL(query2);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
        onCreate(db);
    }

    /*public void insertData(String sno, String sname, String city){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        ContentValues values = new ContentValues();
        values.put(COL_1, "S01");
        values.put(COL_2 , "Smith");
        values.put(COL_3 , "London");
        db.insert(TABLE_NAME, null, values);

    } */
}