`
@DatabaseTable(tableName = "users")
public class User {
}
`
`
@DatabaseField(columnName = "id", dataType = DataType.INTEGER, defaultValue = "0", canBeNull = false)
private int id;
`
`
@DatabaseField(columnName = "id", dataType = DataType.INTEGER, defaultValue = "0", canBeNull = false)
@PrimaryKey
private int id;
`
`
@DatabaseField(columnName = "user_id", dataType = DataType.INTEGER, defaultValue = "0", canBeNull = false)
@ForeignField(foreignFieldName = "id", foreignDataType = DataType.INTEGER, foreignColumnName = "id", foreignTableClass = User.class)
private int userId;
`
`
User user = new User();
user.setName("John");
user.setAge(25);
user.insert();
`
`
List<User> userList = new Select().from(User.class).queryForAll();
`
`
User user = new Select().from(User.class).where("name = ?", "John").executeSingle();
user.setAge(30);
user.update();
`
`
User user = new Select().from(User.class).where("name = ?", "John").executeSingle();
user.delete();
`
`
DatabaseConfiguration configuration = new DatabaseConfiguration(context, "myDatabase.db", 1);
`
`
DatabaseHelper helper = new DatabaseHelper(context, configuration);
`
`
DBToolsImpl dbTools = new DBToolsImpl(helper);
`