android 数据只读,android-SQLiteException：无法将只读数据库从版...

在数据库的第一个版本中,我有三行.扩展SQLiteOpenHelper的类中包含以下方法.

@Override

public void onCreate(SQLiteDatabase database) {

database.execSQL("CREATE TABLE " + DATABASENAME + " (name TEXT, latitude REAL, longitude REAL);");

}

现在,我将版本号从1更改为2,并添加了新行：

@Override

public void onCreate(SQLiteDatabase database) {

database.execSQL("CREATE TABLE " + DATABASENAME + " (name TEXT, latitude REAL, longitude REAL, country TEXT);");

}

我不在乎旧数据库是否丢失,因此我在升级时使用它：

@Override

public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {

db.delete(DATABASENAME, null, null);

onCreate(db);

}

现在,当我调用方法getReadableDatabase()时,应用程序崩溃,并出现logcat错误

Caused by: android.database.sqlite.SQLiteException: Can’t upgrade

read-only database from version 1 to 2:

/data/data/com.myapp.app/databases/mydb

我该如何预防？

编辑

全班：

public class StationsOpenHelper extends SQLiteOpenHelper {

private static final String DATABASENAME = "stations";

private static final int DATABASEVERSION = 2;

public StationsOpenHelper(Context context) {

super(context, DATABASENAME, null, DATABASEVERSION);

}

@Override

public void onCreate(SQLiteDatabase database) {

database.execSQL("CREATE TABLE " + DATABASENAME + " (name TEXT, latitude REAL, longitude REAL, country TEXT);");

}

@Override

public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {

db.delete(DATABASENAME, null, null);

onCreate(db);

}

public ArrayList getStations() {

Logger.log("Trying to read stations from database");

ArrayList result = new ArrayList();

SQLiteDatabase database = getReadableDatabase();

Cursor cursor = database.rawQuery("SELECT * FROM " + DATABASENAME, null);

String name, country;

double lat, lon;

Station s;

cursor.moveToFirst();

while (!cursor.isAfterLast()) {

s = new Station();

name = cursor.getString(0);

lat = cursor.getDouble(1);

lon = cursor.getDouble(2);

country = cursor.getString(3);

s.setName(name);

s.setLatitude(lat);

s.setLongitude(lon);

s.setCountry(country);

result.add(s);

cursor.moveToNext();

}

cursor.close();

database.close();

if (result.isEmpty()) {

Logger.log("Reading stations from database failed");

result = null;

} else {

Logger.log("Reading stations from database succeeded");

}

return result;

}

public void storeStations(ArrayList stations) {

Logger.log("Storing stations in database");

ContentValues values = new ContentValues();

SQLiteDatabase db = getWritableDatabase();

db.delete(DATABASENAME, null, null);

for (int i = 0; i < stations.size(); i++) {

values.put("name", stations.get(i).getName());

values.put("latitude", stations.get(i).getLatitude());

values.put("longitude", stations.get(i).getLongitude());

values.put("country", stations.get(i).getCountry());

db.insert(DATABASENAME, null, values);

}

db.close();

Logger.log("Storing stations in database succeeded");

}

}