Followed the official android documentations but still could not use SQLite in app

Posted by user366539 on Stack Overflow See other posts from Stack Overflow or by user366539
Published on 2010-06-14T17:09:18Z Indexed on 2010/06/14 17:12 UTC
Read the original article Hit count: 170

Filed under:
|
|

My DBHelper class

public class DBHelper extends SQLiteOpenHelper {

public DBHelper(Context context) { super(context,"SIMPLE_DB",null,1); }

@Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE SIMPLE_TABLE ( " + "ID INTEGER PRIMARY KEY " + "DESC TEXT);"); }

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

} }

Activity class

public class SimpleDatabase extends Activity 
{
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);
    DBHelper dbHelper = new DBHelper(this);
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    db.execSQL("INSERT INTO SIMPLE_TABLE VALUES (NULL, 'test');");

Cursor cursor = db.rawQuery("SELECT * FROM SIMPLE_TABLE", null); TextView text = (TextView)findViewById(R.id.textbox); text.setText(cursor.getString(0)); } }

I figure it crashed (application has stopped unexpectedly!) at SQLiteDatabase db = ... because if I commented the code out from there to the end then it worked fine. But I have no idea whatsoever why it does that. Any help would be appreciated.

© Stack Overflow or respective owner

Related posts about android

Related posts about sqlite