<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5</version>
</dependency>
implementation 'com.j256.ormlite:ormlite-core:5.5'
@DatabaseTable(tableName = "persons")
public class Person {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField
private String name;
@DatabaseField
private int age;
// Getters and Setters
}
String databaseUrl = "jdbc:sqlite:/path/to/database.db";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);
TableUtils.createTableIfNotExists(connectionSource, Person.class);
Dao<Person, Integer> personDao = DaoManager.createDao(connectionSource, Person.class);
Person person = new Person();
person.setName("John");
person.setAge(25);
personDao.create(person);
List<Person> persons = personDao.queryForAll();
for (Person person : persons) {
System.out.println(person.getName() + ", " + person.getAge());
}
Person person = personDao.queryForId(1);
person.setAge(30);
personDao.update(person);
Person person = personDao.queryForId(1);
personDao.delete(person);
