SpringBoot整合Mybatis-Fluent框架

柔光的暖阳◎ 2022-09-05 06:00 190阅读 0赞

### 文章目录 ###

*  1.引入依赖
 *  2.配置文件
 *  3.目录结构
 *  4.写实体类
 *  5.启动类
 *  6.接口
 *  7.测试

# 1.引入依赖 #

注意：我并没有使用父类的springboot的方式。

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <parent>
            <artifactId>cxl-spring-mybatis</artifactId>
            <groupId>com.cxl.core</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.cxl.core.mybatis</groupId>
        <artifactId>cxl-spring-mybatis-fluent</artifactId>
    
        <properties>
            <maven.compiler.source>8</maven.compiler.source>
            <maven.compiler.target>8</maven.compiler.target>
        </properties>
    
        <dependencyManagement>
            <dependencies>
                <dependency>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-dependencies</artifactId>
                    <version>2.5.3</version>
                    <type>pom</type>
                    <scope>import</scope>
                </dependency>
                <dependency>
                    <artifactId>mybatis-spring</artifactId>
                    <groupId>org.mybatis</groupId>
                    <version>2.0.6</version>
                </dependency>
            </dependencies>
        </dependencyManagement>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>com.github.atool</groupId>
                <artifactId>fluent-mybatis</artifactId>
                <version>1.6.8</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.atool</groupId>
                <artifactId>fluent-mybatis-processor</artifactId>
                <version>1.6.8</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.20</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.19</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.1</version>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    
    </project>

# 2.配置文件 #

server:
      port: 3999
    
    spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        username: root
        password: 123456
        url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
    
    mybatis:
      type-aliases-package: com.cxl.spring.mybaits.fluent.mapper

# 3.目录结构 #

可以忽视最外层的项目  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQxMzE2MTc_size_16_color_FFFFFF_t_70]

# 4.写实体类 #

自己 建表哈

package com.cxl.spring.mybatis.fluent.entity;
    
    import cn.org.atool.fluent.mybatis.annotation.FluentMybatis;
    import cn.org.atool.fluent.mybatis.annotation.TableId;
    import cn.org.atool.fluent.mybatis.base.IEntity;
    import lombok.Data;
    
    import java.util.Date;
    
    /** * @author cxl */
    @FluentMybatis
    @Data
    public class HelloWorldEntity implements IEntity { 
    
        @TableId("id")
        private Long id;
    
        private String sayHello;
    
        private String yourName;
    
        private Date gmtCreate;
    
        private Date gmtModified;
    
        private Boolean isDeleted;
    }

# 5.启动类 #

import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    @SpringBootApplication
    @MapperScan("com.cxl.spring.mybaits.fluent.mapper")
    public class CxlSpringMybatisFluentApp { 
    
        @RequestMapping("/")
        String home() { 
            return "Hello World!";
        }
    
        public static void main(String[] args) { 
            SpringApplication.run(CxlSpringMybatisFluentApp.class, args);
        }
    
    }

# 6.接口 #

package com.cxl.spring.mybatis.fluent.api;
    
    import cn.org.atool.fluent.mybatis.base.crud.IQuery;
    import com.cxl.spring.mybatis.fluent.mapper.HelloWorldMapper;
    import com.cxl.spring.mybatis.fluent.wrapper.HelloWorldQuery;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.HashMap;
    
    /** * @author cxl **/
    @RestController
    @MapperScan("com.cxl.spring.mybatis.fluent.mapper")
    public class TestHelloWorldApi { 
    
        @Autowired
        HelloWorldMapper helloWorldMapper;
    
        @GetMapping("/get")
        public Object getList(){ 
            return helloWorldMapper.listEntity(
                    new HelloWorldQuery().selectAll()
            );
        }
    }

# 7.测试 #

访问 127.0.0.1/get 即可查询数据

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTQxMzE2MTc_size_16_color_FFFFFF_t_70]: /images/20220829/7e87f10d7cdc49f7ba1f756bf18cc262.png