<dependency>
<groupId>com.j256.ormlite</groupId>
<artifactId>ormlite-core</artifactId>
<version>5.6</version>
</dependency>
String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase";
String username = "username";
String password = "password";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(id = true)
private int id;
@DatabaseField
private String name;
}
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
User user = new User();
user.setId(1);
user.setName("John");
userDao.create(user);
User queryUser = userDao.queryForId(1);
queryUser.setName("Tom");
userDao.update(queryUser);
userDao.delete(queryUser);
connectionSource.close();
