@Table(name = "users")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
@Column(name = "name", canBeNull = false)
private String name;
@Column(name = "email")
private String email;
// Getters and setters
}
public class Main {
public static void main(String[] args) throws SQLException {
String databaseUrl = "jdbc:h2:mem:test";
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);
TableUtils.createTableIfNotExists(connectionSource, User.class);
User user = new User();
user.setName("John");
user.setEmail("john@example.com");
Dao<User, Integer> userDao = DaoManager.createDao(connectionSource, User.class);
userDao.create(user);
List<User> users = userDao.queryForAll();
for (User u : users) {
System.out.println(u.getName() + " - " + u.getEmail());
}
connectionSource.close();
}
}
