JOOQ 学习笔记一:代码自动生成

爱被打了一巴掌 2023-10-17 13:49 4阅读 0赞

第一步：下载mysql 和jooq 关联jar 文件（基于maven下载）。

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <parent>
        <groupId>com.zzg</groupId>
        <artifactId>jooq.demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
      </parent>
      <artifactId>jooq-one</artifactId>
      
      <dependencies>
    		<dependency>
    			<groupId>org.jooq</groupId>
    			<artifactId>jooq</artifactId>
    			<version>3.8.0</version>
    		</dependency>
    		<dependency>
    			<groupId>org.jooq</groupId>
    			<artifactId>jooq-meta</artifactId>
    			<version>3.8.0</version>
    		</dependency>
    		<dependency>
    			<groupId>org.jooq</groupId>
    			<artifactId>jooq-codegen</artifactId>
    			<version>3.8.0</version>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.38</version>
    		</dependency>
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid</artifactId>
    			<version>1.0.18</version>
    		</dependency>
    	</dependencies>
    	
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.apache.maven.plugins</groupId>
    				<artifactId>maven-compiler-plugin</artifactId>
    				<version>3.5.1</version>
    				<configuration>
    					<source>1.8</source>
    					<target>1.8</target>
    				</configuration>
    			</plugin>
    		</plugins>
    	</build>
    </project>

第二步：创建jooq\_lib文件夹，将相关的jar 文件移入该文件加下。

关联jar文件如下：1、jooq-3.8.0.jar

2、jooq-codegen-3.8.0.jar

3、jooq-meta-3.8.0.jar

4、mysql-connector-java-5.1.38.jar

第三步：在jooq\_lib 文件夹中，准备代码自动生成配置文件resource.xml.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.8.0.xsd">
    	
    	<jdbc>
    		<driver>com.mysql.jdbc.Driver</driver>
    		<url>jdbc:mysql://localhost:3306/admin</url>
    		<user>root</user>
    		<password>123456</password>
    	</jdbc>
    	<generator>
    		
    		<name>org.jooq.util.JavaGenerator</name>
    		<database>
    			
    			<name>org.jooq.util.mysql.MySQLDatabase</name>
    			
    			<inputSchema>admin</inputSchema>
    			
    			<includes>.*</includes>
    			
    			<excludes></excludes>
    		</database>
    		<target>
    			
    			<packageName>org.test.jooq.generated</packageName>
    			
    			<directory>src/main/java/</directory>
    		</target>
    	</generator>
    </configuration>

总体的代码生成器结构图如下：

![Center][]

第四步：执行自动生成代码指令

java -classpath jooq-3.8.0.jar;jooq-meta-3.8.0.jar;jooq-codegen-3.8.0.jar;mysql-connector-java-5.1.38.jar; org.jooq.util.GenerationTool /resource.xml

如下截图所示：

![Center 1][]

[Center]: https://img-blog.csdn.net/20170620022432900?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: https://img-blog.csdn.net/20170620022820391?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center