@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField(canBeNull = false)
private String name;
@DatabaseField
private int age;
}
ConnectionSource connectionSource = new JdbcConnectionSource(jdbcUrl, username, password);
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
TableUtils.createTableIfNotExists(connectionSource, User.class);
User user = new User();
user.setName("John Doe");
user.setAge(25);
userDao.create(user);
List<User> users = userDao.queryForAll();
user.setAge(26);
userDao.update(user);
userDao.delete(user);
connectionSource.close();
