@DatabaseTable(tableName = "student")
public class Student {
@DatabaseField(id = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "age")
private int age;
}
ConnectionSource connectionSource = new JdbcConnectionSource("jdbc:mysql://localhost:3306/testdb", "username", "password");
TableUtils.createTable(connectionSource, Student.class);
Dao<Student, Integer> studentDao = DaoManager.createDao(connectionSource, Student.class);
Student student = new Student();
student.setId(1);
student.setName("John Doe");
student.setAge(20);
studentDao.create(student);
List<Student> students = studentDao.queryForAll();
for (Student s : students) {
System.out.println(s.getName() + " - " + s.getAge());
}
connectionSource.close();
