@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(columnName = "id", generatedId = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
}
String databaseUrl = "jdbc:sqlite:/path/to/database.db";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
User user = new User();
user.setName("Alice");
userDao.create(user);
QueryBuilder<User, Integer> qb = userDao.queryBuilder();
qb.where().eq("name", "Alice").and().gt("id", 10);
List<User> userList = qb.query();
@DatabaseTable(tableName = "users")
public class User {
// ...
@ForeignCollectionField(eager = true, orderColumnName = "age")
private ForeignCollection<Address> addresses;
// ...
}
