groovy
dependencies {
implementation 'org.dbtools:dbtools-android:12.0.0'
}
import org.dbtools.android.domain.database.DatabaseWrapper;
import org.dbtools.android.domain.database.AndroidDatabase;
public class MainActivity extends AppCompatActivity {
private DatabaseWrapper database;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
initDatabase();
executeDatabaseOperations();
}
private void initDatabase() {
AndroidDatabase androidDatabase = new AndroidDatabase("myDatabase.db", getApplicationContext());
database = androidDatabase.openDatabase();
}
private void executeDatabaseOperations() {
database.createTable("users")
.addColumn("_id", "INTEGER", "PRIMARY KEY", "AUTOINCREMENT")
.addColumn("name", "TEXT")
.addColumn("email", "TEXT")
.execute();
database.insert("users")
.column("name", "John")
.column("email", "john@example.com")
.execute();
Cursor cursor = database.query("users")
.execute();
if (cursor != null) {
while (cursor.moveToNext()) {
String name = cursor.getString(cursor.getColumnIndex("name"));
String email = cursor.getString(cursor.getColumnIndex("email"));
Log.i("User", "Name: " + name + ", Email: " + email);
}
cursor.close();
}
}
@Override
protected void onDestroy() {
super.onDestroy();
database.close();
}
}
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
