springboot整合jooq

用的不多，算是个DEMO吧，如有错误欢迎指正

pom文件

<dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-jooq</artifactId></dependency>

<build>        <plugins>            <!--默认打包方式-->            <plugin>                <groupId>org.springframework.boot</groupId>                <artifactId>spring-boot-maven-plugin</artifactId>                <version>1.4.1.RELEASE</version>                <configuration>                    <executable>true</executable>                    <classifier>exec</classifier>                </configuration>            </plugin>            <!--jooq 构建构建工具-->            <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>                    <!-- JDBC connection parameters -->                    <jdbc>                        <driver>com.mysql.jdbc.Driver</driver>                        <url>jdbc:mysql://120.25.211.83:3306</url>                        <user>root</user>                        <password>123</password>                    </jdbc>                    <generator>                        <database>                            <name>org.jooq.util.mysql.MySQLDatabase</name>                            <includes>.*</includes>                            <excludes/>                            <!--数据库名-->                            <!--inputSchema 输入模式-->                            <schemata>                                <schema>                                    <inputSchema>lost_and_found</inputSchema>                                </schema>                                <schema>                                    <inputSchema>wyh</inputSchema>                                </schema>                            </schemata>                            <!--强制类型-->                            <forcedTypes>                                <forcedType>                                    <name>BOOLEAN</name>                                    <types>(?i:TINYINT(\s*\(\d+\))?(\s*UNSIGNED)?)</types>                                </forcedType>                            </forcedTypes>                        </database>                        <generate>                            <pojos>true</pojos>                            <!--<daos>true</daos>-->                            <deprecated>true</deprecated>                        </generate>                        <target>                            <packageName>com.example.domain.jooq</packageName>                            <directory>src/main/java</directory>                        </target>                    </generator>                </configuration>            </plugin>        </plugins>    </build>

引入pom后在maven插件中可以生成对应数据库中的实体

生成的实体如下

jooq不需要dao层，直接上service

/** * Created by rj-wyh on 2017/4/11. */public interface DepartmentService {    List<Department> findAll();    String save(Department department);}

import com.wyh.data.domain.jooq.tables.pojos.Department;import com.wyh.data.domain.jooq.tables.records.DepartmentRecord;import com.wyh.data.service.DepartmentService;import org.jooq.DSLContext;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.ArrayList;import java.util.List;import static com.wyh.data.domain.jooq.tables.Department.DEPARTMENT;/** * Created by rj-wyh on 2017/4/11. */@Servicepublic class DepartmentServiceImpl implements DepartmentService {    @Autowired    private DSLContext create;    @Override    public List<Department> findAll() {        List<DepartmentRecord> departmentRecords= create                .select()                .from(DEPARTMENT)                .fetchInto(DepartmentRecord.class);        List<Department> departmentList = new ArrayList<>();        for (DepartmentRecord departmentRecord:        departmentRecords) {            Department department = new Department();            department.setName(departmentRecord.getName());            department.setEmployeesNum(departmentRecord.getEmployeesNum());            department.setId(departmentRecord.getId());            department.setManager(departmentRecord.getManager());            departmentList.add(department);        }        return departmentList;    }    @Override    public String save(Department department) {        create                .insertInto(DEPARTMENT, DEPARTMENT.NAME, DEPARTMENT.EMPLOYEES_NUM, DEPARTMENT.MANAGER)                .values(department.getName(),  department.getEmployeesNum(), department.getManager())                .execute();        return "success";    }}

上controller层

import com.wyh.data.domain.jooq.tables.pojos.Department;import com.wyh.data.domain.pojo.Result;import com.wyh.data.service.DepartmentService;import com.wyh.data.utils.ResultUtil;import io.swagger.annotations.ApiOperation;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.validation.BindingResult;import org.springframework.validation.annotation.Validated;import org.springframework.web.bind.annotation.*;/** * Created by rj-wyh on 2017/4/11. */@RestController@RequestMapping("/department")public class DepartmentController {    @Autowired    private DepartmentService departmentService;    @PostMapping("/save")    @ApiOperation(value = "保存部门")    public Result save(@RequestBody@Validated Department department, BindingResult bindingResult){        if (bindingResult.hasErrors()){            return ResultUtil.error(bindingResult.getFieldError().getDefaultMessage(), "-1");        }        return ResultUtil.success(departmentService.save(department));    }    @GetMapping("/findAll")    @ApiOperation(value = "查找全部部门")    public Result findAll(){        return ResultUtil.success(departmentService.findAll());    }}