<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.5</version>
</dependency>
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(generatedId = true)
private int id;
@DatabaseField(canBeNull = false)
private String name;
public User() {
}
public User(String name) {
this.name = name;
}
}
ConnectionSource connectionSource = new JdbcConnectionSource("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
User user = new User("John");
userDao.create(user);
List<User> users = userDao.queryForAll();
user.setName("Jane");
userDao.update(user);
userDao.delete(user);
connectionSource.close();
