SQLite Database issue in TextView
<p>I've been working on an app where the main <code>Activity</code> leads to <code>CalendarActivity</code>, which has a button leading to another <code>Activity</code> where the user creates an event. Once the event is created, the user is taken back to <code>CalendarActivity</code>, and a previously empty <code>TextView</code> displays the event. The code I've used seems like it should work, and is near verbatim from an online tutorial. I researched the comments of the video and the video maker's blog, and many others seem to say it works fine. I've check over and over, and I believe that its grammatically correct, etc, but I can not get it to load the event into the <code>TextView</code>. Any pointers even would help. I would ask you keep it near basic english, I am just getting into programming and am using this app as a learning experience.</p>

<p>Thanks!</p>

<p><code>CalendarActivity</code>:</p>

<pre><code>package com.bm.sn.sbeta;

import android.content.Intent;
import android.database.Cursor;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.CalendarView;
import android.widget.TextView;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;

public class CalendarActivity extends AppCompatActivity {

CalendarView calendar;
Button createEvent;
public static String createEventDate;
DatabaseHelper db;

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

    Cursor result = db.getAllData();
    if (result.getCount() == 0) {

        noEventToday();

    }else{

        TextView eventList = (TextView)findViewById(R.id.eventList);
        StringBuffer stringBuffer = new StringBuffer();

        while (result.moveToNext()) {

            stringBuffer.append("eventDat : "+result.getString(0)+"\n");
            stringBuffer.append("timeHour : "+result.getString(1)+"\n");
            stringBuffer.append("timeMinue : "+result.getString(2)+"\n");
            stringBuffer.append("event : "+result.getString(3)+"\n");
            stringBuffer.append("location : "+result.getString(4)+"\n");
            stringBuffer.append("crew : "+result.getString(5)+"\n\n");
            eventList.setText(stringBuffer);


        }
    }

    calendar = (CalendarView)findViewById(R.id.calendar);
    calendar.setOnDateChangeListener(new CalendarView.OnDateChangeListener(){
        @Override
        public void onSelectedDayChange(CalendarView view, int year, int month, int dayOfMonth){
            createEventDate = (month+"."+dayOfMonth+"."+year);
            createEvent.setText("Create Event for "+createEventDate);
            }
    });

    createEvent = (Button)findViewById(R.id.eventCreateButton);
    createEvent.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            Intent toEventCreateActivity = new Intent(CalendarActivity.this, EventCreateActivity.class);
            startActivity(toEventCreateActivity);
        }
    });
}

/*public void fillEventList (){

}

public void noEventToday(){
    TextView eventList = (TextView)findViewById(R.id.eventList);
    eventList.setText("Nothing scheduled for today.");
}*/
}
</code></pre>

<p><code>EventCreateActivity</code>:</p>

<pre><code>package com.bm.sn.sbeta;

import android.content.Intent;
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;
import android.widget.TimePicker;
import android.widget.Toast;

public class EventCreateActivity extends AppCompatActivity {

DatabaseHelper db;

String textViewText = CalendarActivity.createEventDate;

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

    db = new DatabaseHelper(this);

    final TextView titleTextView = (TextView)findViewById(R.id.titleTextView);
    titleTextView.setText("Create event for "+textViewText);

    final TimePicker timePicker = (TimePicker)findViewById(R.id.timePicker);

    final EditText entryEvent = (EditText)findViewById(R.id.entryEvent);
    final EditText entryLocation = (EditText)findViewById(R.id.entryLocation);
    final EditText entryCrew = (EditText)findViewById(R.id.entryCrew);

    Button createEventButton = (Button)findViewById(R.id.saveEvent);
    createEventButton.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {

            db.insertData(
                    titleTextView.toString(),
                    timePicker.getCurrentHour().toString(),
                    timePicker.getCurrentMinute().toString(),
                    entryEvent.getText().toString(),
                    entryLocation.getText().toString(),
                    entryCrew.getText().toString()
                    );

            Toast.makeText(EventCreateActivity.this, "I'll keep that in mind.", Toast.LENGTH_LONG).show();
            Intent toCalendarActivity = new Intent(EventCreateActivity.this, CalendarActivity.class);
            startActivity(toCalendarActivity);


        }
    });
}
}
</code></pre>

<p><code>DatabaseHelper</code>:</p>

<pre><code>package com.bm.sn.sbeta;

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

public class DatabaseHelper extends SQLiteOpenHelper{

public static final String DATABASE_NAME = "SavitaCalendar.db";
public static final String TABLE_NAME = "CalendarEvents";
public static final String col_0 = "ID";
public static final String col_1 = "eventDate" ;
public static final String col_2 = "timeHour";
public static final String col_3 = "timeMinute";
public static final String col_4 = "event";
public static final String col_5 = "location";
public static final String col_6 = "crew";


public DatabaseHelper(Context context) {
    super(context, DATABASE_NAME, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {

    db.execSQL("create table "+TABLE_NAME+ " (ID INTEGER PRIMARY KEY AUTOINCREMENT,EVENTDATE TEXT,TIMEHOUR TEXT,TIMEMINUTE TEXT, EVENT TEXT, LOCATION TEXT, CREW TEXT); ");

}

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

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

}



public void insertData (String eventDate, String timeHour, String timeMinute, String event, String location, String crew){

    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(col_1, eventDate);
    contentValues.put(col_2, timeHour);
    contentValues.put(col_3, timeMinute);
    contentValues.put(col_4, event);
    contentValues.put(col_5, location);
    contentValues.put(col_6, crew);

    db.insert(TABLE_NAME, null, contentValues);
    db.close();

}

public Cursor getAllData(){

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor result = db.rawQuery("select * from "+TABLE_NAME, null);
    return result;

}
}
</code></pre>