jeudi 3 décembre 2015

Retrive string from SQLite in Android

I am developing simple app to retrieve a string from SQLite database and display it in TextView of my main activity. For that, I created method inside class which handles SQLite database, then inside main activity I called the method, but what it does is only to retrieve null.

Method inside my SQLite database handler class.

 @Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(
            "CREATE TABLE " + PERSON_TABLE_NAME +
                    "(" + PERSON_COLUMN_ID + " INTEGER PRIMARY KEY, " +
                    PERSON_COLUMN_NAME + " TEXT, " +
                    PERSON_COLUMN_GENDER + " TEXT, " +
                    PERSON_COLUMN_AGE + " INTEGER)"
    );

}......////////////   Some  Code...........






public String getAddress(int id) {
    // TODO Auto-generated method stub
    SQLiteDatabase db = this.getReadableDatabase();


    try {
        Cursor cursor =  db.rawQuery("SELECT * FROM " + PERSON_TABLE_NAME + " WHERE " +
                PERSON_COLUMN_ID + "=?", new String[]{Integer.toString(id)});

        if (cursor != null) {
            cursor.moveToFirst();
            return cursor.getString (cursor.getColumnIndex (PERSON_COLUMN_NAME));
        }
    }
    catch (Exception e) {

        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return "";
}

My main activity Where I call the method.

button = (Button) findViewById(R.id.addNew);
    button.setText(dbHelper.getAddress(8));

Aucun commentaire:

Enregistrer un commentaire