spring boot使用jooq配置

拼搏现实的明天。 2023-01-14 11:57 158阅读 0赞

### 文章目录 ###

*   *   *  场景
         *  配置

### 场景 ###

*  jooq相对mybaits的优势

### 配置 ###

<?xml version="1.0" encoding="UTF-8"?>
    <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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.4.5</version>
            <relativePath/> 
        </parent>
        <groupId>com.carsonlius</groupId>
        <artifactId>jooq</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>jooq</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>11</java.version>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            
            <maven.compiler.source>11</maven.compiler.source>
            <maven.compiler.target>11</maven.compiler.target>
            
            <db.url>jdbc:mysql://localhost:3307</db.url>
            <db.username>root</db.username>
            <db.password>root</db.password>
            <db.schema>gulimall_admin</db.schema>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.23</version>
            </dependency>
            <dependency>
                <groupId>org.jooq</groupId>
                <artifactId>jooq-codegen</artifactId>
            </dependency>
    
            
            
    
    
    
    
    
    
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <configuration>
                        <skip>true</skip>
                    </configuration>
                </plugin>
                <plugin>
                    
                    <groupId>org.jooq</groupId>
                    <artifactId>jooq-codegen-maven</artifactId>
                    
                    <executions>
                        <execution>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <configuration>
                        
                        <jdbc>
                            <driver>com.mysql.jdbc.Driver</driver>
                            <url>${db.url}</url>
                            <user>${db.username}</user>
                            <password>${db.password}</password>
                        </jdbc>
                        
                        <generator>
                            <database>
    
                                <name>org.jooq.meta.mysql.MySQLDatabase</name>
                                <includes>.*</includes>
                                <inputSchema>${db.schema}</inputSchema>
                                <forcedTypes>
                                    <forcedType>
                                        <name>BOOLEAN</name>
                                        <expression>.*\.HANDMADE</expression>
                                        <types>.*</types>
                                    </forcedType>
                                </forcedTypes>
                            </database>
                            <generate>
                                
                                <daos>true</daos>
                                <pojos>true</pojos>
                                
                                <javaTimeTypes>true</javaTimeTypes>
                                
                                
                                <springAnnotations>true</springAnnotations>
                            </generate>
    
                            <target>
                                <packageName>com.carsonlius.jooq.generator</packageName>
                                <directory>src/main/java</directory>
                            </target>
                        </generator>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    
    </project>