jooq

jOOQ，是一个ORM框架，利用其生成的Java代码和流畅的API，可以快速构建有类型约束的安全的SQL语句 。

• 官网
  http://www.jooq.org/

https://www.cnblogs.com/g177w/p/15588116.html
https://blog.csdn.net/weixin_43604021/article/details/125803181

Maven

<dependency>
    <groupId>org.jooq</groupId>
    <artifactId>jooq</artifactId>
    <version>3.18.6</version>
</dependency>

中文手册

https://jooq.diamondfsd.com/learn/section-1-how-to-start.html
英文说明
http://www.jooq.org/learn/

sql生成器

http://www.jooq.org/doc/3.18/manual/getting-started/use-cases/jooq-as-a-sql-builder-without-codegeneration/

• where生成器
  http://www.jooq.org/doc/3.18/manual/sql-building/dynamic-sql/

• 条件判断
  https://blog.csdn.net/a917058965/article/details/79820465

• insertr插入器
  https://jooq.diamondfsd.com/learn/section-2-base-curd#Insert

http://www.jooq.org/doc/3.18/manual/sql-building/sql-statements/insert-statement/insert-returning/
https://www.jooq.org/doc/3.18/manual/sql-building/dsl-context/custom-settings/settings-return-default-on-store/
类插入
https://www.jooq.org/doc/latest/manual/sql-execution/crud-with-updatablerecords/simple-crud/

• 获取插入的id
  https://github.com/jOOQ/jOOQ/issues/14772

解包语法参考

https://github.com/jOOQ/jOOQ/issues/14569