@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField
private String name;
@DatabaseField
private int age;
}
String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, "username", "password");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
User user = new User("John", 25);
userDao.create(user);
List<User> userList = userDao.queryForAll();
for (User user : userList) {
System.out.println(user.getName() + " - " + user.getAge());
}
user.setAge(30);
userDao.update(user);
userDao.delete(user);
connectionSource.close();
