Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to use ORM". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Introduction to ObjectvieSQL

ObjectiveSQL is a Java ORM framework, which is not only the application of Active Record pattern in Java, but also provides an almost perfect solution for complex SQL programming, which makes the organic combination of Java code and SQL statements and changes the traditional SQL programming model (the programming model based on string concatenation).

The ObjectiveSQL project is divided into two parts: one is that the runtime Maven relies on objective-sql or objsql-springboot, which mainly implements the basic ORM features and SQL programming model, and the other is the IntelliJ IDEA plug-in, which is compatible with Java operator overloading and dynamic code hints.

The main solution of ObjectiveSQL is:

Dynamic code generation: based on domain model (Domain Model), simple SQL programming code is automatically generated, which makes application development only focus on its own business characteristics and improve development efficiency.

Programmable SQL: abstract control primitives, predicates, functions and procedural logic in SQL into advanced types in Java, which are integrated with Java, making SQL a truly procedural and logical programming language that can be encapsulated, reused and unit tested.

Expression syntax consistency: Java syntax is equivalent to SQL syntax, including mathematical calculations, function calls, comparisons and logical evaluation expressions. Java expressions can be directly converted into SQL expressions.

ObjectiveSQL characteristics

With a comment, Class has the full functionality of SQL programming

Simple relational queries (has_one,has_many and belongs_to) and paging queries

Write SQL expressions (arithmetic,comparison and logical) using Java syntax

Why choose ObjectiveSQL?

If your project focuses on data analysis based on relational databases, as well as many arithmetic expressions in SQL statements. ObjectiveSQL will help you write expressions easily and safely using Java syntax.

If you don't want to write Java code for database access and various configuration files, ObjectiveSQL's dynamic code generation will help you access the database without coding

Performance demonstration

Examples of ObjectiveSQL usage

Complex SQL programming

As you can see, the Java operator can be converted to the SQL operator, which means that you can write SQL using Java syntax. In Java, you can do SQL dynamic programming, logic, and so on.

Simple SQL programming with Zero coding

Persistence (Persistence)

Count and query (Counting and Quering)

Association query (Relation Quering)

Paged query (Paged Quering)

This is the end of "how to use ORM". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.