项目结构:
JooqConfig.xml全文
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <configuration> <jdbc> <driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://11.23.98.90/tableName</url> <user>root</user> <password>P@ssw0rd</password> </jdbc> <generator> <!-- 代码生成器 --> <name>org.jooq.util.JavaGenerator</name> <database> <!--下面这两行是为view也生成代码的关键--> <!--force generating id'sfor everything in public schema, that has an 'id' field--> <syntheticPrimaryKeys>public\..*\.id</syntheticPrimaryKeys> <!--name for fake primary key--> <overridePrimaryKeys>override_primmary_key</overridePrimaryKeys> <name>org.jooq.util.mysql.MySQLDatabase</name> <!--include和exclude用于控制为数据库中哪些表生成代码--> <includes>.*</includes> <!--<excludes></excludes>--> <!--数据库名称--> <inputSchema>suntree_cmp_test</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>cn.com.suntree.generator</packageName> <directory>src/main/java</directory> </target> </generator> </configuration>
dependencies中加入
<dependency> <groupId>org.jooq</groupId> <artifactId>jooq-meta</artifactId> </dependency> <dependency> <groupId>org.jooq</groupId> <artifactId>jooq-codegen</artifactId> </dependency>
plugins中加入
<plugin> <groupId>org.jooq</groupId> <artifactId>jooq-codegen-maven</artifactId> <version></version> <executions> <execution> <goals> <goal>generate</goal> </goals> </execution> </executions> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version></version> </dependency> </dependencies> <configuration> <configurationFile>src/main/resources/JooqConfig.xml</configurationFile> </configuration> </plugin>
需要注意的都在JoopConfig.xml中做了注释
最后运行maven的compile
将会自动生成一些代码
初步整合成功