java 轻量级 orm_java有哪些简洁的ORM框架？

1)简单SQL 不需要写代码。

2)通过Java 运算符重载实现了复杂SQL只需要定义一个模型

@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 orders;

}你就可以

Member.countAll();

Member.count("id > ?", 1);

Member.queryByPrimaryKey(1);

Member.queryFirst("id = ?", 1);

Member.query("id > ?", 1);

Member.queryAll();

Member.queryAll(Member.HAS_MANY_ORDERS);

Member.queryByPrimary(1, Member.HAS_MANY_ORDERS);

Member.queryByName("demo", Member.HAS_MANY_ORDERS);

Page page = Page.create(0, 10);

PagedList members = Member.pagedQueryAll(page, Member.HAS_MANY_ORDERS);复杂SQL 处理

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);

生成的SQL 如下：

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`

基于Oracle JMH性能测试(虽然领先的差距不大，但多次运行持续领先)：