Jooq生成数据库访问代码

作者: rainmanhhh | 来源:发表于2018-08-08 17:45 被阅读0次

Jooq生成数据库访问代码
使用Jooq和flywayDB改善代码质量
jOOQ系列一：SpringBoot2.x整合jOOQ
技术架构文集-目录
ORM “杀器”之 JOOQ
jOOQ 3.10 代码生成参数配置
JOOQ重写生成java代码类
mybatis逆向工程搭建
自动生成Spring Boot + lombok + MySql
Django动态存储图片并可外网URL访问(MEDIA_URL

新建module（maven或gradle）
引入依赖
jdbc驱动：
例如mysql-connector-java
jooq依赖：
org.jooq:jooq-meta:$jooqVersion
org.jooq:jooq-codegen:$jooqVersion
如果是java9以上，还需要：
javax.xml:jaxb-api:2.1
javax.xml:jaxb-impl:2.1
javax.activation:javax.activation-api:1.2.0
gradle：新建JavaExec类型的task
build.gradle.kts
val jooqCodeGen by tasks.creating(JavaExec::class) {
classpath = sourceSets["main"].runtimeClasspath
main = "org.jooq.codegen.GenerationTool"
args = listOf("default.xml")
}

maven：使用exec插件
pom.xml

  <build>
    <plugins>
      <plugin>
        <groupId>org.codehaus.mojo</groupId>
        <artifactId>exec-maven-plugin</artifactId>
        <version>1.5.0</version>
        <executions>
          <execution>
            <goals><goal>java</goal></goals>
          </execution>
        </executions>
        <configuration>
          <mainClass>org.jooq.codegen.GenerationTool</mainClass>
          <arguments>
            <argument>default.xml</argument>
          </arguments>
          <cleanupDaemonThreads>false</cleanupDaemonThreads>
        </configuration>
      </plugin>
    </plugins>
  </build>

输入文件default.xml示例

<?xml version="1.0" encoding="UTF-8"?>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.11.0.xsd">
  <jdbc>
    <driver>com.mysql.jdbc.Driver</driver>
    <url>jdbc:mysql://localhost:3306</url>
    <user>root</user>
    <password>password</password>
  </jdbc>
  <generator>
    <name>org.jooq.codegen.JavaGenerator</name>
    <database>
      <name>org.jooq.meta.mysql.MySQLDatabase</name>
      <inputSchema>demo</inputSchema>
      <includes>
        table1
        |table2
      </includes>
      <excludes/>
    </database>
    <target>
      <packageName>my.demo.generated</packageName>
      <directory>src/main/java/</directory>
    </target>

    <strategy>
      <matchers>
        <tables>
          <table>
            <expression>^(.*)$</expression>
            <tableClass>
              <transform>PASCAL</transform>
              <expression>T_$1</expression>
            </tableClass>
            <recordClass>
              <transform>PASCAL</transform>
              <expression>R_$1</expression>
            </recordClass>
          </table>
        </tables>
      </matchers>
    </strategy>

    <generate>
      <pojos>true</pojos>
      <daos>true</daos>
      <springAnnotations>true</springAnnotations>
      <fluentSetters>true</fluentSetters>
      <javaTimeTypes>true</javaTimeTypes>
    </generate>
  </generator>
</configuration>