• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps Database update question

alphasil

Lurker
Hello

I have a problem with my update method

This is my method

public int updateLocal(String nome, String cat, String pais, String lat, String lon, Bitmap foto) {

ContentValues values = new ContentValues();
values.put(DbHelper.NOME, nome);
values.put(DbHelper.CAT, cat);
values.put(DbHelper.PAIS,pais);
values.put(DbHelper.LAT,lat);
values.put(DbHelper.LON,lon);
ByteArrayOutputStream baos = new ByteArrayOutputStream();
foto.compress(Bitmap.CompressFormat.PNG, 100, baos);
byte[] photo = baos.toByteArray();
values.put(DbHelper.FOTO, photo);

// updating row
return database.update(DbHelper.TABLE_NAME, values, DbHelper.ID + " = ?", new String[] { DbHelper.ID});
}


This is my full code

package com.basedados;

import java.io.ByteArrayOutputStream;
import java.util.ArrayList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;


public class DBAdapter {

private SQLiteDatabase database;
private final DbHelper dbHelper;
private String[] allColumns = { DbHelper.ID, DbHelper.NOME, DbHelper.DES};
private String[] allColumns1 = {DbHelper.ID, DbHelper.NOME, DbHelper.CAT, DbHelper.PAIS, DbHelper.LAT, DbHelper.LON, DbHelper.FOTO};

public DBAdapter(Context context) {
dbHelper = new DbHelper(context);
}

public void open() throws SQLException {
database = dbHelper.getWritableDatabase();
}

public void close() {
dbHelper.close();
}

//M
 
Back
Top Bottom