dependencies {
implementation 'androidx.sqlite:sqlite:VERSION'
}
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
public class DatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "MyDatabase.db";
private static final int DATABASE_VERSION = 1;
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String createTableQuery = "CREATE TABLE IF NOT EXISTS MyTable (id INTEGER PRIMARY KEY, name TEXT)";
db.execSQL(createTableQuery);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String updateTableQuery = "DROP TABLE IF EXISTS MyTable";
db.execSQL(updateTableQuery);
onCreate(db);
}
}
DatabaseHelper databaseHelper = new DatabaseHelper(context.getApplicationContext());
SQLiteDatabase database = databaseHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", "John");
database.insert("MyTable", null, values);
String[] projection = {"id", "name"};
Cursor cursor = database.query("MyTable", projection, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
int id = cursor.getInt(cursor.getColumnIndex("id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
} while (cursor.moveToNext());
}
cursor.close();
