import org.ujorm.orm.*;
import org.ujorm.orm.annot.*;
import org.ujorm.orm.metaModel.*;
@Table(name = "users")
public class User extends TableWrapper {
@Column(pk = true)
private Long id;
@Column(length = 50)
private String name;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
private static OrmHandler createOrmHandler() {
OrmHandler handler = new OrmHandler();
handler.config().set(Database.class, "jdbc:mysql://localhost:3306/mydb");
handler.config().set(Database.class, "user", "root");
handler.config().set(Database.class, "password", "password");
handler.config().set(MetaDatabase.class, User.class);
return handler;
}
public static void main(String[] args) {
OrmHandler handler = createOrmHandler();
SqlSession session = handler.createSession();
User user = new User();
user.setId(1L);
user.setName("John Doe");
session.save(user);
User retrievedUser = session.load(User.class, 1L);
System.out.println(retrievedUser.getName());
retrievedUser.setName("Jane Smith");
session.update(retrievedUser);
session.delete(User.class, 1L);
session.commit();
session.close();
}