Hello
I have a problem with my update method
This is my method
This is my full code
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