文件列表:

uroborosql-release-v0.x (0, 2023-06-05)
uroborosql-release-v0.x\LICENSE (1084, 2023-06-05)
uroborosql-release-v0.x\REPL (0, 2023-06-05)
uroborosql-release-v0.x\REPL\repl.properties (579, 2023-06-05)
uroborosql-release-v0.x\pom.xml (12769, 2023-06-05)
uroborosql-release-v0.x\settings (0, 2023-06-05)
uroborosql-release-v0.x\settings\.maven.settings.xml (1027, 2023-06-05)
uroborosql-release-v0.x\src (0, 2023-06-05)
uroborosql-release-v0.x\src\main (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql (0, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\AbstractAgent.java (37335, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\AbstractExtractionCondition.java (30884, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\AbstractResultSetWrapper.java (44922, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\AbstractSqlFluent.java (8548, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\ProcedureImpl.java (2813, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlAgent.java (23440, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlAgentFactory.java (9939, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlAgentFactoryImpl.java (10915, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlAgentImpl.java (56603, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlBatchImpl.java (4230, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlEntityDeleteImpl.java (1527, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlEntityQueryImpl.java (20764, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlEntityUpdateImpl.java (3004, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlQueryImpl.java (7934, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\SqlUpdateImpl.java (1789, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\UroboroSQL.java (13585, 2023-06-05)
uroborosql-release-v0.x\src\main\java\jp\co\future\uroborosql\client (0, 2023-06-05)
... ...

[](https://maven-badges.herokuapp.com/maven-central/jp.co.future/uroborosql) [](https://raw.githubusercontent.com/future-architect/uroborosql/master/LICENSE) [](https://www.javadoc.io/doc/jp.co.future/uroborosql) [](https://travis-ci.org/future-architect/uroborosql) [](https://coveralls.io/github/future-architect/uroborosql?branch=master) uroboroSQL ========== UroboroSQL is a simple SQL execution library that can utilize 2-way-SQL compatible with Java 8. UroboroSQL mainly adopts a SQL-centered design concept. The concept does not focus on Java to assemble SQL, but is based on an idea of making up for weaknesses of SQL with Java. From the knowhow acquired through our business, we have enhanced UroboroSQL with functions like partition value support, retrying, filtering customization, and so on. Also, for quality assurance purposes, it features a coverage analysis function available for 2-way-SQL. There is also REPL which dramatically increases SQL development productivity. [](https://asciinema.org/a/122312) for Japanese, see [README.ja.md](https://github.com/future-architect/uroborosql/blob/master/README.ja.md) ## Installation ### for Maven ```xml jp.co.future uroborosql 0.26.6 ognl ognl 3.1.23 ``` or ```xml jp.co.future uroborosql 0.26.6 org.springframework spring-expression 5.3.20 ``` ### for Gradle ```gradle compile group: 'jp.co.future', name: 'uroborosql', version: '0.26.6' compile group: 'ognl', name: 'ognl', version: '3.1.23' ``` or ```gradle compile group: 'jp.co.future', name: 'uroborosql', version: '0.26.6' compile group: 'org.springframework', name: 'spring-expression', version: '5.3.20' ``` ## Documentation [https://future-architect.github.io/uroborosql-doc/](https://future-architect.github.io/uroborosql-doc/) ## Requirement - Java 1.8 or later. ## Quick start ### 2Way-SQL ```sql /* department/select_department.sql */ SELECT /* _SQL_ID_ */ DEPT.DEPT_NO AS DEPT_NO , DEPT.DEPT_NAME AS DEPT_NAME FROM DEPARTMENT DEPT WHERE 1 = 1 /*IF SF.isNotEmpty(dept_no)*/ AND DEPT.DEPT_NO = /*dept_no*/1 /*END*/ /*IF SF.isNotEmpty(dept_name)*/ AND DEPT.DEPT_NAME = /*dept_name*/'sample' /*END*/ ``` ```sql /* department/insert_department.sql */ INSERT /* _SQL_ID_ */ INTO DEPARTMENT ( DEPT_NO , DEPT_NAME ) VALUES ( /*dept_no*/1 , /*dept_name*/'sample' ) ``` ```java SqlConfig config = UroboroSQL.builder("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "").build(); try (SqlAgent agent = config.agent()) { // SELECT List> departments = agent.query("department/select_department").param("dept_no", 1001).collect(); // INSERT int count = agent.update("department/insert_department") .param("dept_no", 1001) .param("dept_name", "sales") .count(); } ``` ### DAO Interface ```java SqlConfig config = UroboroSQL.builder("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "").build(); try (SqlAgent agent = config.agent()) { // select Department dept = agent.find(Department.class, 1001).orElse(null); // insert Department hrDept = new Department(); hrDept.setDeptNo(1002); hrDept.setDeptName("HR"); agent.insert(hrDept); // update hrDept.setDeptName("Human Resources"); agent.update(hrDept); // delete agent.delete(hrDept); } ``` ## Sample application - CLI - - Web application(with Spring Boot) - ## Automated code generation - uroboroSQL source generator - ## SQL Formatter We also prepare a SQL formatter useful for development. - CLI - - Sublime Text 3 Plugin - - IntelliJ IDEA Platform Plugin - - Eclipse Plugin - ## License Released under the [MIT License](https://github.com/future-architect/uroborosql/blob/master/LICENSE).

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：