compile group: 'com.j256.ormlite', name: 'ormlite-core', version: 'x.x.x'
@DatabaseTable(tableName = "users")
public class User {
@DatabaseField(id = true)
private int id;
@DatabaseField
private String name;
public User() {
// Empty constructor needed by ORMLite
}
// Getters and Setters
}
String databaseUrl = "jdbc:mysql://localhost:3306/mydatabase";
String username = "myusername";
String password = "mypassword";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl, username, password);
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
User user = new User();
user.setId(1);
user.setName("John Doe");
userDao.create(user);
List<User> users = userDao.queryForAll();
