Advant ORM

Maven Repository: advant-orm-1.0.jar
Wiki: User Guide 1.0
Documentation: Javadocs 1.0
License: Apache 2.0

Getting Started

This is the simplest ORM (Object Relational Mapping) to work with all popular databases (RDBMS)

• Mysql
• Postgres
• SQLite
• H2
• HSQLDB
• Derby
• Oracle
• DB2

Prerequisites

You must comply with these requirements before implement Advant ORM in your application:

• JVM >= 7
• JDBC dependencies correctly configured in your project
• Database correctly installed and accessible with your credentials

Example with Mysql

Create a db schema if you haven't yet

CREATE DATABASE advantorm;

Create table with ID (AUTO_INCREMENT) and VERSION columns

CREATE TABLE person
(
  id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  version BIGINT DEFAULT NULL,
  name varchar(255) NOT NULL,
);

Create Table class extending io.advant.orm.AbstractTable with @Table and @Column annotations

@Table(name = "person")
public class PersonTable extends AbstractTable {
    @Column(name = "name")
    private String name;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
}

Create Entity class extending PersonTable and implementing io.advant.orm.Entity

public class PersonEntity extends Personable implements Entity {}

Create DAO interface extending io.advant.orm.DAO with generics

public interface PersonDAO<T> extends DAO<T> {}

Create DAO implementation class extending io.advant.orm.AbstractDAO and generics configured with entity class

public class PersonDAOImpl extends AbstractDAO<PersonEntity> implements PersonDAO<PersonEntity> {}

Configure advantorm.properties file with entities, database credentials and parameters

db.type=mysql
db.host=localhost
db.port=3306
db.database=advantorm
db.user=root
db.password=
entity.1=com.example.entity.PersonEntity

Now you can select() insert() update() and delete() from Person table

public static void main() throws ConnectionException, OrmException {
    // Load DB instance from advantorm.properties
    DB db = DBFactory.getInstance();
    
    // Initialize DAO with DBConnection
    PersonDAO<PersonEntity> dao = new PersonDAOImpl(db.getConnection());
    
    //Create your entity and set values
    PersonEntity entity = new PersonEntity();
    entity.setName("Marco");
    
    // test DAO functionality
    dao.insert(entity);
    dao.find(1L);
    entity.setName("Marco2");
    dao.update(entity);
    dao.delete(entity);
    
    // Disconnect
    DB.getInstance().disconnect();
}

You can also use io.advant.orm.GenericDAO by using entity on fly without create DAOs for each entity

Insight

if you want to increase your Advant ORM knowledge follow this link