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
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