dependencies {
implementation 'org.dbtools.android:library:3.3.1'
}
@DatabaseTable("users")
public class User {
@DatabaseField(id = true)
private int id;
@DatabaseField(canBeNull = false)
private String name;
}
public class MainActivity extends AppCompatActivity {
private DatabaseManager databaseManager;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
databaseManager = new DatabaseManager(getApplicationContext());
databaseManager.openDatabase();
SQLiteDatabase db = databaseManager.getDatabase();
db.createTable(User.class);
User user = new User();
user.setId(1);
user.setName("John Doe");
db.insert(user);
List<User> users = db.findAll(User.class);
for (User u : users) {
Log.d("DBTools", "User: " + u.getName());
}
databaseManager.closeDatabase();
}
}
