ObjectiveSql

ObjectiveSQL是一个基于ActiveRecord模式的Java ORM框架，它鼓励快速开发和清洁，最少的代码，以及约定优于配置。

主要特点

• 通过一个注释，您的Class就拥有 SQL 编程的全功能
• 易于关系（ has_one ， has_many和belongs_to ）查询和分页查询
• 使用 Java 语法编写 SQL 表达式（ arithmetic 、 comparison和logical ）

为什么选择 ObjectiveSQL

• 如果您的项目侧重于基于关系数据库的数据分析，并且SQL语句中存在大量算术表达式。 ObjectiveSQL将帮助您使用Java语法方便、安全地编写表达式
• 如果你不想编写数据库访问和各种配置文件的Java代码，ObjectiveSQL的动态代码生成将帮助你无需编码即可访问数据库

性能（Oracle JMH）

安装

IntelliJ IDEA 插件安装

Preferences/Settings -> Plugins -> Search with "ObjectiveSql" in market -> Install

Maven 依赖项

 <!-- In standalone -->
< dependency >
    < groupId >com.github.braisdom</ groupId >
    < artifactId >objective-sql</ artifactId >
    < version >1.4.6</ version >
</ dependency >

 <!-- In Spring Boot -->
< dependency >
  < groupId >com.github.braisdom</ groupId >
  < artifactId >objsql-springboot</ artifactId >
  < version >1.3.4</ version >
</ dependency >

更多配置参考pom.xml

示例

ObjectiveSQL 在下面提供了各种数据库的完整示例，您可以直接使用 IntelliJ IDEA 将其作为独立项目打开。事实上，它们不仅仅是示例，也是 ObjectiveSQL 在各种数据库中的单元测试。

如果你想不配置运行，可以尝试：SQLite

其他：MySQL、Oracle、MS SQL Server、PostgreSQL、Spring Boot

简单的 SQL 编程，无需编码

您只需定义一个带有注释的 JavaBean

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

坚持

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

计数与查询

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

分页查询

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

关系查询

 Member . queryAll ( Member . HAS_MANY_ORDERS );
Member . queryByPrimary ( 1 , Member . HAS_MANY_ORDERS );
Member . queryByName ( "demo" , 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 );

 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 `

参考文档

• 英语
• 中文(中文)