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>
执行