springboot3 整合jooq
时间: 2023-11-19 20:57:45 浏览: 48
以下是Spring Boot 3整合Jooq的步骤:
1.在pom.xml文件中添加以下依赖:
```xml
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jooq</artifactId>
</dependency>
```
2.在application.yml文件中添加以下配置:
```yaml
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false
username: root
password: root
jooq:
sql-dialect: MYSQL
```
3.在pom.xml文件中添加以下插件:
```xml
<plugin>
<groupId>org.jooq</groupId>
<artifactId>jooq-codegen-maven</artifactId>
<version>3.14.4</version>
<executions>
<execution>
<id>generate-jooq-sources</id>
<phase>generate-sources</phase>
<goals>
<goal>generate</goal>
</goals>
</execution>
</executions>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
</dependencies>
<configuration>
<jdbc>
<driver>com.mysql.cj.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false</url>
<user>root</user>
<password>root</password>
</jdbc>
<generator>
<database>
<name>org.jooq.meta.mysql.MySQLDatabase</name>
<includes>.*</includes>
<excludes></excludes>
<inputSchema>test</inputSchema>
</database>
<target>
<packageName>com.example.demo.jooq</packageName>
<directory>src/main/java</directory>
</target>
</generator>
</configuration>
</plugin>
```
4.在src/main/resources目录下创建jooq.xml文件,添加以下内容:
```xml
<?xml version="1.0" encoding="UTF-8"?>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.14.4.xsd">
<jdbc>
<driver>com.mysql.cj.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false</url>
<user>root</user>
<password>root</password>
</jdbc>
<generator>
<database>
<name>org.jooq.meta.mysql.MySQLDatabase</name>
<includes>.*</includes>
<excludes></excludes>
<inputSchema>test</inputSchema>
</database>
<target>
<packageName>com.example.demo.jooq</packageName>
<directory>src/main/java</directory>
</target>
</generator>
</configuration>
```
5.运行以下命令生成Jooq代码:
```bash
mvn clean install
```
6.在代码中使用Jooq进行CURD操作,例如:
```java
@Autowired
DSLContext dsl;
public void insert() {
dsl.insertInto(TABLE_NAME)
.set(TABLE_NAME.NAME, "test")
.set(TABLE_NAME.AGE, 18)
.execute();
}
public void update() {
dsl.update(TABLE_NAME)
.set(TABLE_NAME.NAME, "test2")
.where(TABLE_NAME.ID.eq(1))
.execute();
}
public void delete() {
dsl.delete(TABLE_NAME)
.where(TABLE_NAME.ID.eq(1))
.execute();
}
public List<Record> select() {
return dsl.select()
.from(TABLE_NAME)
.where(TABLE_NAME.ID.eq(1))
.fetch();
}
```
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)