Help- how to export and import db on sdcard using this code?,Iam new to Android so i didntknow how to export and import using Reminderdatahelper class, Thanks InAdvance.
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class ReminderDataHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "reminderData.db";
private static final int DATABASE_VERSION = 1;
private static final String DB_TABLE_NAME = "reminders";
private static final String DB_COLUMN_ID = "_id";
private static final String DB_COLUMN_TYPE = "type";
private static final String DB_COLUMN_TITLE = "title";
private static final String DB_COLUMN_CONTENT = "content";
private static final String DB_COLUMN_TIME = "time";
private static final String DB_COLUMN_FREQUENCY = "frequency";
public ReminderDataHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + DB_TABLE_NAME + "(" +
DB_COLUMN_ID + " INTEGER PRIMARY KEY, " +
DB_COLUMN_TYPE + " TEXT, " +
DB_COLUMN_TITLE + " TEXT, " +
DB_COLUMN_CONTENT + " TEXT, " +
DB_COLUMN_FREQUENCY + " TEXT, " +
DB_COLUMN_TIME + " LONG)"
);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DB_TABLE_NAME);
onCreate(db);
}
}
Comments
Post a Comment