spring boot整合jooq

Dear 丶 2022-03-22 05:07 220阅读 0赞

项目结构：  
![在这里插入图片描述][20190126092235484.png]  
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>
                
                
                <syntheticPrimaryKeys>public\..*\.id</syntheticPrimaryKeys>
                
                <overridePrimaryKeys>override_primmary_key</overridePrimaryKeys>
    
                <name>org.jooq.util.mysql.MySQLDatabase</name>
    
                
                <includes>.*</includes>
                
    
                
                <inputSchema>suntree_cmp_test</inputSchema>
            </database>
    
            <generate>
                
                <daos>true</daos>
                <pojos>true</pojos>
                
                <javaTimeTypes>true</javaTimeTypes>
                
                
                <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>${jooq.version}</version>
    				<executions>
    					<execution>
    						<goals>
    							<goal>generate</goal>
    						</goals>
    					</execution>
    				</executions>
    				<dependencies>
    					<dependency>
    						<groupId>mysql</groupId>
    						<artifactId>mysql-connector-java</artifactId>
    						<version>${mysql.version}</version>
    					</dependency>
    				</dependencies>
    				<configuration>
    					<configurationFile>src/main/resources/JooqConfig.xml</configurationFile>
    				</configuration>
    			</plugin>

需要注意的都在JoopConfig.xml中做了注释

最后运行maven的compile  
将会自动生成一些代码  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlaXN1cmVfbGlmZQ_size_16_color_FFFFFF_t_70]  
初步整合成功

[20190126092235484.png]: /images/20220322/ee0d7496aa674cffbf948be8a8e7a44f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlaXN1cmVfbGlmZQ_size_16_color_FFFFFF_t_70]: /images/20220322/579e9171bbb8485c8b72d7933190b49e.png