jooq mysql 自动生成

pom.xml 引入

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jooq</artifactId>
</dependency>


<plugin>
    <groupId>org.jooq</groupId>
    <artifactId>jooq-codegen-maven</artifactId>
    <version>${jooq.version}</version>
    <executions>
        <execution>
            <goals>
                <goal>generate</goal>
            </goals>
        </execution>
    </executions>
    <!--对应的数据库依赖-->
    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>
    </dependencies>
    <configuration>
        <!--配置文件的存放路径-->
        <configurationFile>src/main/resources/JooqConfig.xml</configurationFile>
    </configuration>
</plugin>

 

 

创建 JooqConfig.xml 文件

 

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <jdbc>
        <driver>com.mysql.cj.jdbc.Driver</driver>
        <url></url>
        <user></user>
        <password></password>
    </jdbc>
    <generator>
        <!-- 代码生成器 -->
     <!--   <name>org.jooq.meta.mysql.MySQLDatabase</name>-->
        <database>
            <!--强制为scheme1模式下所有的含有id域生成id-->

            <!--是否重写主键-->

            <name>org.jooq.meta.mysql.MySQLDatabase</name>

            <!--include和exclude用于控制为数据库中哪些表生成代码-->
            <includes>.*</includes>
            <excludes></excludes>

            <!--数据库名称-->
            <inputSchema></inputSchema>
        </database>

        <generate>
            <!--是否生成dao和pojo-->
           <!-- <daos>true</daos>-->
            <pojos>true</pojos>
            <!--是否把数据库时间类型映射到java 8时间类型-->
            <javaTimeTypes>true</javaTimeTypes>
            <!--<interfaces>true</interfaces>-->
            <!--是否在生成的代码中添加spring注释，比如@Repository-->
            <springAnnotations>false</springAnnotations>
        </generate>

        <target>
            <!--生成代码文件的包名及放置目录-->
            <packageName>com.baqi.test</packageName>
            <directory>src/main/java</directory>
        </target>
    </generator>
</configuration>

执行