spinner data from sqlite

I'm trying to fill spinner item from sqlite table

i have no idea how to do it , i tried to follow other example but i think its different than mine

what is the easiest way to do it and how can i set onclicklistener for each item

Thanks in advance

MainActivity + sqliteopenhelper

 DB db;
Button addmed,addpl;
TextView PPLNAMERES;
Spinner spinner;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
  PPLNAMERES = (TextView)findViewById(R.id.PPLNAMEGETNAME);
    db = new DB(this);

    listView();

    Spinner spinCountry;
    String spinValue = db.getMainData().toString();
    spinCountry= (Spinner) findViewById(R.id.spinCountry);
    ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
            android.R.layout.simple_spinner_item,spinValue.);
    adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    spinCountry.setAdapter(adapter);

    spinCountry.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
        @Override
        public void onItemSelected(AdapterView<?> arg0, View arg1, int position, long id) {
        }

        @Override
        public void onNothingSelected(AdapterView<?> arg0) {
        }
    });
}



public class DB extends SQLiteOpenHelper {

public final static String DBNAME="MEDCINEDB.db";
public final static String Table_name="MEDCINETable";
public final static String Table_name2="PPLTABLE";
public final static String col1="MEDCINEID";
public final static String col2="MEDCINENAME";
public final static String col3="MEDCINEPURPOSE";
public final static String col4="NOTAPLET";
public final static String col1T2="ID";
public final static String col2T2="NAMEPPL";
public final static String col3T2="AGEPPL";
public final static int DBVersion =2;


public DB(Context context) {
    super(context, DBNAME, null, DBVersion);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE " + Table_name + "(MEDCINEID INTEGER PRIMARY KEY AUTOINCREMENT,MEDCINENAME TEXT,MEDCINEPURPOSE TEXT,NOTAPLET INTEGER)");
    db.execSQL("CREATE TABLE " + Table_name2 + "(ID INTEGER PRIMARY KEY AUTOINCREMENT,NAMEPPL TEXT,AGEPPL INTEGER)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP IF EXISTS"+Table_name);
    db.execSQL("DROP IF EXISTS"+Table_name2);
    onCreate(db);

}
public boolean inserData(String name,String purpose,String notaplet){
    SQLiteDatabase db= this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(col2,name);
    contentValues.put(col3, purpose);
    contentValues.put(col4, notaplet);

    long Result = db.insert(Table_name,null ,contentValues);
    if(Result == -1){
        return false;
    }
    else {
        return true;
    }
}

public boolean insertTb2Data(String Name, String Age){
    SQLiteDatabase db = getWritableDatabase();
    ContentValues PPLcontentValues = new ContentValues();
    PPLcontentValues.put(col2T2,Name);
    PPLcontentValues.put(col3T2,Age);
    Long Result = db.insert(Table_name2,null,PPLcontentValues);
    if(Result == -1){
        return false;
    }
    else
        return true;
}

 public Cursor getMainData(){
SQLiteDatabase db = this.getWritableDatabase();
Cursor result = db.rawQuery("select NAMEPPL from "+Table_name2,null);
return result;}}