ObjectiveSQL (A New Java ORM) 1.4.5 Has Been Released

Here's a quick snippet showing off the latest features of ObjectiveSQL, a Java ORM framework.

Braisdom Wong

Jan. 03, 21 · Java Zone · News

Like (4)

Save

8.14K Views

ObjectiveSQL is an ORM framework in Java based on the ActiveRecord pattern, which encourages rapid and clean development and clean, minimal coding, and convention over configuration.

GitHub: https://github.com/braisdom/ObjectiveSql

Features

With one annotation, your Class has fully featured capabilities of SQL programming
Easy relational queries (has_one, has_many, and belongs_to) and paged queries
Writing SQL expressions (arithmetic, comparison, and logical) using Java syntax

Why to choose

If your project focuses on data analysis based on relation database, and a lot of arithmetic expressions in SQL statement. ObjectiveSQL will help you write expressions conveniently and safely using Java syntax
If you don’t want to write Java codes of database access and various configuration files, ObjectiveSQL's dynamic code generation will help you access the database without coding

Performance

Complex SQL Programming

     Java 
   
x
 
Order.Table orderTable = Order.asTable();
Select select = new Select();
// In ObjectiveSQL, Java operator can be overloaded
select.project(sum(orderTable.amount) / sum(orderTable.quantity) * 100)
        .from(orderTable)
        .where(orderTable.quantity > 30 &&
            orderTable.salesAt.between("2020-10-10 00:00:00", "2020-10-30 23:59:59"))
        .groupBy(orderTable.productId);

As you can see, operators of Java can be converted into operators of SQL, it means that you can write SQL using Java syntax. In Java, SQL dynamic programming, logic, etc. is possible

     SQL 
   
xxxxxxxxxx
 
SELECT SUM(`T0`.`amount`) / SUM(`T0`.`quantity`) * 100
FROM `orders` AS `T0`
WHERE `T0`.`quantity` > 30 AND 
       `T0`.`sales_at` BETWEEN '2020-10-10 00:00:00' AND '2020-10-30 23:59:59')
GROUP BY `T0`.`product_id`

Simple SQL Programming Without Coding

     Java 
   
x
 
@DomainModel
public class Member {
    private String no;
    
    @Queryable
    private String name;
    private Integer gender;
    private String mobile;
    private String otherInfo;
    @Relation(relationType = RelationType.HAS_MANY)
    private List<Order> orders;
}

Persistence

     Java 
   
xxxxxxxxxx
 
Member.create(newMember);
Member.create(new Member[]{newMember1, newMember2, newMember3}, false);
Member.update(1L, newMember, true);
Member.update("name = 'Smith => Jackson'", "name = ?", "Alice");
Member.destroy(1L);
Member.destroy("name = ?", "Mary");

Counting and Querying

     Java 
   
xxxxxxxxxx
 
Member.countAll();
Member.count("id > ?", 1);
Member.queryByPrimaryKey(1);
Member.queryFirst("id = ?", 1);
Member.query("id > ?", 1);
Member.queryAll();

Relation Querying

     Java 
   
xxxxxxxxxx
 
Member.queryAll(Member.HAS_MANY_ORDERS);
Member.queryByPrimary(1, Member.HAS_MANY_ORDERS);
Member.queryByName("demo", Member.HAS_MANY_ORDERS);

Paged Querying

     Java 
   
xxxxxxxxxx
 
Page page = Page.create(0, 10);
PagedList<Member> members = Member.pagedQueryAll(page, Member.HAS_MANY_ORDERS);

Topics:

java, sql, objectivesql

Opinions expressed by DZone contributors are their own.

Comments