Fecha del Tema: 2012-06-17 01:21:04

Para actualizar la base de datos en android vasta con modificar la versión
de nuestra base de datos.
private static final int DATABASE_VERSION = 12;
Este seria el código:
<?// no va
package org.me.deportes;
import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.*;
import android.util.Log;
import java.io.Serializable;
/**
 *
 * @author julio265
 */
public class BDDe implements Serializable {
    private static final String TAG = "NotesDbAdapter";
    private DatabaseHelper mDbHelper;
    private SQLiteDatabase mDb;
    private static final String DATABASE_NAME = "MisDeportes";
    private static final int DATABASE_VERSION = 12;
    private final Context mCtx;
    private static class DatabaseHelper extends SQLiteOpenHelper {
        DatabaseHelper(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }
        @Override
        public void onCreate(SQLiteDatabase db) {   
db.execSQL(Deporte.deporte_CREATE);
        }
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int
newVersion) {
Log.w(TAG, "Upgrading database from version " + oldVersion + " to "+
newVersion + ", which will destroy all old data");
//aqui actualizamos
          db.execSQL(Deporte.deporte_UPGRADE);
            onCreate(db);
        }
    }
    public BDDe(Context ctx) {
        this.mCtx = ctx;
    }
    public BDDe open() throws SQLException {
        mDbHelper = new DatabaseHelper(mCtx);
        mDb = mDbHelper.getWritableDatabase();
        return this;
    }
    public void close() {
        mDbHelper.close();
    }

    public SQLiteDatabase getmDb() {
        return mDb;
    }
    public void setmDb(SQLiteDatabase mDb) {
        this.mDb = mDb;
    }
}
?>//no va