java - 安卓sqlite问题

Question

我阅读了一些教程和一本书中的 sqlite 部分，并应用了它，效果很好。现在我把它弄乱了，试图理解它，但现在它每次都会强制关闭，我不知道为什么。我已经一遍又一遍地检查我的代码，但也许我找不到问题，因为我对 sqlite/数据库总体来说是新手。任何帮助将不胜感激:

public class Events extends Activity {

private TextView tv;
private DataHelper dh;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    tv = new TextView(this);
    dh = new DataHelper(this);
    dh.deleteAll();
    //dh.addEvent("James");
    //Cursor c = dh.getEvent();
    //startManagingCursor(c);
    //tv.setText(dh.showEvent(c));
    setContentView(tv);
}

}

public class EventsData extends SQLiteOpenHelper {

private static final String DATABASE_NAME = "events.db";
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_CREATE = "CREATE TABLE" + TABLE_NAME + "(" + TITLE + " TEXT)";
private static final String DATABASE_UPGRADE = "DROP TABLE IF EXISTS " + TABLE_NAME;

public EventsData(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    db.execSQL(DATABASE_CREATE);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub
    db.execSQL(DATABASE_UPGRADE);
    onCreate(db);
}

}

public class DataHelper {

private Context context;
private SQLiteDatabase db;
private EventsData eventsData;

public DataHelper(Context context) {
    this.context = context;
    eventsData = new EventsData(this.context);
}

public void addEvent(String name) {
    db = eventsData.getWritableDatabase();
    ContentValues cv = new ContentValues();
    cv.put(TITLE, name);
    db.insertOrThrow(TABLE_NAME, null, cv);
}

}

注释掉 addEvent() 将使应用程序正常运行，但一旦我取消注释，它就会强制关闭。

Answer 1

快速拍摄:CREATE TABLE 之后没有空格。