implementation 'org.dbtools:dbtools-android:1.9.0'
public class MyDatabase extends DBSQLiteOpenHelper {
private static final String DATABASE_NAME = "mydatabase.db";
private static final int DATABASE_VERSION = 1;
public MyDatabase(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase database) {
String createTableSql = "CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY, name TEXT)";
database.execSQL(createTableSql);
}
@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
}
}
MyDatabase database = new MyDatabase(context);
ContentValues values = new ContentValues();
database.insert("mytable", values);
Cursor cursor = database.query("mytable", null, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
String name = cursor.getString(cursor.getColumnIndex("name"));
Log.d("DBTools", "Name: " + name);
} while (cursor.moveToNext());
}
ContentValues updatedValues = new ContentValues();
database.update("mytable", updatedValues, "id = ?", new String[] { "1" });
database.delete("mytable", "id = ?", new String[] { "1" });
database.close();
