<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>${ormlite.version}</version>
</dependency>
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
}
User user = new User();
user.setName("John");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
userDao.create(user);
QueryBuilder<User, Integer> queryBuilder = userDao.queryBuilder();
queryBuilder.where().eq("name", "John");
List<User> users = queryBuilder.query();