@Table(name = "student")
public class Student {
@DatabaseField(columnName = "id", generatedId = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
}
String databaseUrl = "jdbc:mysql://localhost:3306/example";
String databaseUsername = "root";
String databasePassword = "password";
ConnectionFactory connectionFactory = new JdbcPooledConnectionSource(databaseUrl, databaseUsername, databasePassword);
TableUtils.createTable(connectionFactory, Student.class);
Student student = new Student("John");
Dao<Student, Integer> studentDao = DaoManager.createDao(connectionFactory, Student.class);
studentDao.create(student);
List<Student> students = studentDao.queryForAll();
student.setName("David");
studentDao.update(student);
studentDao.delete(student);
