<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5.1</version>
</dependency>
implementation 'com.j256.ormlite:ormlite-core:5.5.1'
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(columnName = "id", generatedId = true)
private int id;
@DatabaseField(columnName = "name")
private String name;
@DatabaseField(columnName = "age")
private int age;
// getters, setters, and constructors
}
String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
DatabaseConnectionSource connectionSource = new JdbcPooledConnectionSource(databaseUrl, username, password);
connectionSource.initialize();
TableUtils.createTable(connectionSource, User.class);
User user = new User();
user.setName("John Doe");
user.setAge(25);
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
userDao.create(user);
List<User> users = userDao.queryForAll();
user.setAge(26);
userDao.update(user);
userDao.delete(user);
connectionSource.close();
