public class MainActivity extends AppCompatActivity {

SQLiteDatabase db;
ArrayList<String> arrayList;
ArrayAdapter<String>  arrayAdapter;
Spinner   spinner;
Cursor c;
Button button1;
Button button;
EditText editText;
String xx;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    arrayList = new ArrayList<>();
    spinner = (Spinner)findViewById(R.id.spinner);
    button1 = (Button)findViewById(R.id.button);
    button = (Button)findViewById(R.id.button2);
    editText = (EditText)findViewById(R.id.editText);

    try {

        db= openOrCreateDatabase("yemen07",MODE_PRIVATE,null);
        db.execSQL("create table IF NOT EXISTS mytable(Name texr)");
        db.execSQL("insert into mytable (Name) values ('772309685')");
        db.execSQL("insert into mytable (Name) values ('736382843')");
        db.execSQL("insert into mytable (Name) values ('777308879')");
        c = db.rawQuery("select * from mytable ",null);
        while (c.moveToNext()){
            arrayList.add(c.getString(0));
        }

        arrayAdapter = new ArrayAdapter<String>(this,R.layout.support_simple_spinner_dropdown_item,arrayList);
        spinner.setAdapter(arrayAdapter);
        spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long l) {
                 xx = (String)spinner.getItemAtPosition(position);

            }

            @Override
            public void onNothingSelected(AdapterView<?> adapterView) {

            }
        });


    }catch (Exception ex){
        Toast.makeText(getApplicationContext(),ex.getMessage(),Toast.LENGTH_LONG).show();
    }

   button.setOnClickListener(new View.OnClickListener() {
       @Override
       public void onClick(View view) {
           db.execSQL(" delete from mytable where Name='"+xx+"'");
           Toast.makeText(getApplicationContext(),"deleted",Toast.LENGTH_LONG).show();
           dele_num(xx);
       }
   });
    button1.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {
            db.execSQL("insert into mytable (Name)values('"+editText.getText().toString()+"')");
            Toast.makeText(getApplicationContext(),"done inserted",Toast.LENGTH_LONG).show();

        }
    });






}

public void dele_num(String xx){
    ArrayAdapter<String> vv;

    vv = new ArrayAdapter<>(getApplicationContext(),R.layout.support_simple_spinner_dropdown_item);
   deleteDatabase(xx);
    vv.add(xx);



}

public void show_me(){
    ArrayList<String> mm = new ArrayList<>();

    Cursor c = db.rawQuery("slect * from mytable",null);
    while (c.moveToNext()){
        mm.add(c.getString(0));
    }

    ArrayAdapter<String> vv;

            vv = new ArrayAdapter<>(getApplicationContext(),R.layout.support_simple_spinner_dropdown_item,mm);

    spinner.setAdapter(vv);


}

public void  add_me(String my_num){


    }
}

db.execSQL("insert into mytable (Name) values ('772309685')");
    db.execSQL("insert into mytable (Name) values ('736382843')");
    db.execSQL("insert into mytable (Name) values ('777308879')");