mercredi 26 août 2015

how to retrieve image from SQLite database

I am saving some data in SQLite data for android. I want to show or retrieve the image data. following is the code I am trying. please help me out:

---retrieving image but I cant do it public String getData() {

    // TODO Auto-generated method stub

    String[] columns = new String[] { KEY_ROWID, KEY_NAME, KEY_NUMBER };

    Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);

    String result = "";

    int iRow = c.getColumnIndex(KEY_ROWID);

    int iname = c.getColumnIndex(KEY_NAME);

    // int iphoto = c.getColumnIndex(KEY_PHOTO);

    int inumber = c.getColumnIndex(KEY_NUMBER);

    for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {

        result = result + c.getString(iRow) + " " + c.getString(iname) + " " + c.getString(inumber) + "\n";

    }

    return result;
}

----this method is saving data in SQLite database: public long create_Entry(ContactInfo objContact) {

    // TODO Auto-generated method stub

    ContentValues cv = new ContentValues();

    cv.put(KEY_NAME, objContact.getFname());

    cv.put(KEY_NUMBER, objContact.getPhoneNo());

    cv.put(KEY_PHOTO, Utility.getBytes(objContact.getBitmap()));

    return ourDatabase.insert(DATABASE_TABLE, null, cv);




}

Aucun commentaire:

Enregistrer un commentaire