Fluent Mybatis

https://gitee.com/fluent-mybatis/fluent-mybatis-docs
Admin
Fluent Mybatis is a powerful ORM framework based on MyBatis, providing a fluent API for simpler and...
Tokens:47,676
Snippets:736
Trust Score:10
Update:3 months ago
Show doc for...
Tokens:
Raw
### Database Schema Setup

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/04-advanced-generator

SQL script to create the fluent_mybatis schema and the user and receiving_address tables.

```sql
create schema fluent_mybatis;
use fluent_mybatis;

drop table if exists user;
CREATE TABLE user  (
  id bigint(21) unsigned auto_increment primary key COMMENT '主键id',
  avatar varchar(255) DEFAULT NULL COMMENT '头像',
  account varchar(45) DEFAULT NULL COMMENT '账号',
  password varchar(45) DEFAULT NULL COMMENT '密码',
  user_name varchar(45) DEFAULT NULL COMMENT '名字',
  birthday datetime DEFAULT NULL COMMENT '生日',
  e_mail varchar(45) DEFAULT NULL COMMENT '电子邮件',
  phone varchar(20) DEFAULT NULL COMMENT '电话',
  bonus_points bigint(21) DEFAULT 0 COMMENT '会员积分',
  status varchar(32) DEFAULT NULL COMMENT '状态(字典)',
  gmt_create datetime DEFAULT NULL COMMENT '创建时间',
  gmt_modified datetime DEFAULT NULL COMMENT '更新时间',
  is_deleted tinyint(2) DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB CHARACTER SET = utf8 COMMENT = '用户表';

drop table  if exists receiving_address;
CREATE TABLE receiving_address  (
  id bigint(21) unsigned auto_increment primary key COMMENT '主键id',
  user_id bigint(21) NOT NULL COMMENT '用户id',
  province varchar(50) DEFAULT NULL COMMENT '省份',
  city varchar(50) DEFAULT NULL COMMENT '城市',
  district varchar(50) DEFAULT NULL COMMENT '区',
  detail_address varchar(100) DEFAULT NULL COMMENT '详细住址',
  gmt_create datetime DEFAULT NULL COMMENT '创建时间',
  gmt_modified datetime DEFAULT NULL COMMENT '更新时间',
  is_deleted tinyint(2) DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB CHARACTER SET = utf8 COMMENT = '用户收货地址';
```

--------------------------------

### Console Log Output

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

Example of the SQL logs generated when accessing the associated entity list.

```text
DEBUG - ==>  Preparing: SELECT id, ..., user_name FROM t_member WHERE id = ?  
DEBUG - ==> Parameters: 1(Long) 
DEBUG - <==      Total: 1 
DEBUG - ==>  Preparing: SELECT id, ..., member_id FROM t_member_favorite WHERE member_id = ?  
DEBUG - ==> Parameters: 1(Long) 
DEBUG - <==      Total: 2 
爱好项: 2
```

--------------------------------

### Console Log Output for Default Values

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/02-advanced-hello-world

Example of the generated SQL and object output showing default values applied.

```text
Preparing: INSERT INTO hello_world(say_hello, your_name, gmt_create, gmt_modified, is_deleted) VALUES (?, ?, now(), now(), 0)  
2517 [main] DEBUG c.o.a.f.m.d.e.m.H.insert - ==> Parameters: hello(String), fluent mybatis(String) 
2518 [main] DEBUG c.o.a.f.m.d.e.m.H.insert - <==    Updates: 1 

HelloWorldEntity(id=7, sayHello=hello, yourName=fluent mybatis, gmtCreate=Fri Oct 09 22:35:06 CST 2020, gmtModified=Fri Oct 09 22:35:06 CST 2020, isDeleted=false)
```

--------------------------------

### HTTPS Authentication Prompt

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop

Example of the authentication prompt encountered when using HTTPS; use a personal access token instead of a password.

```text
Username for 'https://gitee.com': userName
Password for 'https://userName@gitee.com': # Private Token
```

--------------------------------

### Importing a BaseDao class

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/issues/I4C49U

Example of an import statement for a generated BaseDao class that may be missing if the code generation process was not executed correctly.

```java
import cn.org.fluent.mybatis.springboot.demo.dao.base.CountyDivisionBaseDao;
```

--------------------------------

### Debug Log Output for One-to-Many Query

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

Example of the SQL generated by Fluent Mybatis when executing the conditional query.

```text
DEBUG - ==>  Preparing: SELECT id, ..., user_name FROM t_member WHERE id = ?  
DEBUG - ==> Parameters: 1(Long) 
DEBUG - <==      Total: 1 
DEBUG - ==>  Preparing: SELECT id, ..., member_id FROM t_member_favorite 
    WHERE is_deleted = ? 
    AND member_id = ?  
DEBUG - ==> Parameters: false(Boolean), 1(Long) 
DEBUG - <==      Total: 2 
爱好项: 2
```

--------------------------------

### Create Database Table

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/spring-boot-demo

SQL script to create the sample table used for demonstration.

```sql
DROP TABLE IF EXISTS `your_table`;
create table `your_table`
(
    id bigint auto_increment comment '主键ID' primary key,
    name varchar(30) charset utf8 null comment '姓名',
    age int null comment '年龄',
    email varchar(50) charset utf8 null comment '邮箱',
    gmt_create datetime null comment '记录创建时间',
    gmt_modified datetime null comment '记录最后修改时间',
    is_deleted tinyint(2) default 0 null comment '逻辑删除标识'
);
```

--------------------------------

### Define Database Schema

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/01-hello-world

Create the hello_world table structure required for the demonstration.

```sql
create schema fluent_mybatis;

create table hello_world
(
    id           bigint unsigned auto_increment primary key,
    say_hello    varchar(100) null,
    your_name    varchar(100) null,
    gmt_created   datetime   DEFAULT NULL COMMENT '创建时间',
    gmt_modified datetime   DEFAULT NULL COMMENT '更新时间',
    is_deleted   tinyint(2) DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB
  CHARACTER SET = utf8 comment '简单演示表';
```

--------------------------------

### Initialize Student Database Table

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/fluent-mybatis-dynamic

SQL script to create the student table with standard audit fields.

```sql
DROP TABLE IF EXISTS `student`;

CREATE TABLE `student`
(
    `id`           bigint(21) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
    `name`         varchar(20) DEFAULT NULL COMMENT '姓名',
    `phone`        varchar(20) DEFAULT NULL COMMENT '电话',
    `email`        varchar(50) DEFAULT NULL COMMENT '邮箱',
    `gender`       tinyint(2)  DEFAULT NULL COMMENT '性别',
    `locked`       tinyint(2)  DEFAULT NULL COMMENT '状态(0:正常,1:锁定)',
    `gmt_created`  datetime    DEFAULT CURRENT_TIMESTAMP COMMENT '存入数据库的时间',
    `gmt_modified` datetime    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改的时间',
    `is_deleted`   tinyint(2)  DEFAULT 0,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_0900_ai_ci COMMENT ='学生表';
```

--------------------------------

### Generated Entity Class

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/spring-boot-demo

Example of an entity class generated by Fluent MyBatis with appropriate annotations.

```java
@Data
@Accessors(chain = true)
@FluentMybatis(table = "your_table")
public class YourEntity implements IEntity{
    private static final long serialVersionUID = 1L;

    @TableId(value = "id")
    private Long id;

    @TableField(value = "gmt_create", insert = "now()")
    private Date gmtCreate;

    @TableField(value = "gmt_modified", insert = "now()", update = "now()")
    private Date gmtModified;

    @TableField(value = "is_deleted", insert = "0")
    private Boolean isDeleted;

    @TableField(value = "age")
    private Integer age;

    @TableField(value = "email")
    private String email;
 
    @TableField(value = "name")
    private String name;

    @Override
    public Serializable findPk() {
        return id;
    }
}
```

--------------------------------

### 新增数据并自动填充环境和租户

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/env_tenant_demo

演示插入数据时，即使未显式设置 env 和 tenant 属性，系统也会自动填充这些字段。

```java
@RunWith(SpringRunner.class)
@SpringBootTest(classes = AppMain.class)
public class InsertWithEnvDemo {
    @Autowired
    private StudentMapper mapper;

    @Test
    public void insertEntity() {
        mapper.delete(new StudentQuery());
        mapper.insert(new StudentEntity()
            .setAddress("宇宙深处")
            .setUserName("FluentMybatis")
        );
        StudentEntity student = mapper.findOne(StudentQuery.query()
            .where.userName().eq("FluentMybatis").end()
            .limit(1));
        System.out.println(student.getUserName() + ", env:" + student.getEnv() + ", tenant:" + student.getTenant());
    }
}
```

```text
DEBUG - ==>  Preparing: 
    INSERT INTO student(gmt_created, gmt_modified, is_deleted, address, env, tenant, user_name) 
    VALUES (now(), now(), 0, ?, ?, ?, ?)  
DEBUG - ==> Parameters: 宇宙深处(String), test1(String), 222222(Long), FluentMybatis(String) 
DEBUG - <==    Updates: 1 
DEBUG - ==>  Preparing: SELECT id, gmt_created, gmt_modified, is_deleted, address, age, birthday, bonus_points, env, gender_man, grade, home_address_id, home_county_id, phone, status, tenant, user_name, version 
    FROM student WHERE user_name = ? LIMIT ?, ?  
DEBUG - ==> Parameters: FluentMybatis(String), 0(Integer), 1(Integer) 
DEBUG - <==      Total: 1 
FluentMybatis, env:test1, tenant:222222
```

--------------------------------

### MyBatis XML Multi-Update Statement

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/issues/I3IPR5

Example of a MyBatis XML mapper configuration for executing multiple update statements in one call.

```xml
<update id="update" parameterType="com.mxsoft.ssmdemo.model.Foo">
        UPDATE a_foo set password = #{password} WHERE a_id = #{id, jdbcType=INTEGER};
        UPDATE b_foo set password = #{password} WHERE b_id = #{id, jdbcType=INTEGER};
</update>
```

--------------------------------

### Configure Annotation Processors in 01-hello-world/pom.xml

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/pulls/1.patch

Updates the compiler plugin configuration to include annotationProcessorPaths for Lombok and fluent-mybatis-processor.

```xml
--- a/01-hello-world/pom.xml
+++ b/01-hello-world/pom.xml
@@ -11,6 +11,7 @@
     <properties>
         <fluent.mybatis.version>1.8.0.1</fluent.mybatis.version>
         <spring.version>5.3.3</spring.version>
+        <org.projectlombok.version>1.18.20</org.projectlombok.version>
     </properties>
     <dependencies>
         <dependency>
@@ -18,20 +19,8 @@
             <artifactId>fluent-mybatis</artifactId>
             <version>${fluent.mybatis.version}</version>
         </dependency>
-        <dependency>
-            <groupId>com.github.atool</groupId>
-            <artifactId>fluent-mybatis-processor</artifactId>
-            <version>${fluent.mybatis.version}</version>
-            <scope>provided</scope>
-        </dependency>
 
         <!--应用项目依赖: lombok, spring, mysql等-->
-        <dependency>
-            <groupId>org.projectlombok</groupId>
-            <artifactId>lombok</artifactId>
-            <version>1.18.20</version>
-            <scope>provided</scope>
-        </dependency>
         <dependency>
             <groupId>mysql</groupId>
             <artifactId>mysql-connector-java</artifactId>
@@ -82,6 +71,18 @@
                     <source>1.8</source>
                     <target>1.8</target>
                     <encoding>utf-8</encoding>
+                    <annotationProcessorPaths>
+                        <path>
+                            <groupId>org.projectlombok</groupId>
+                            <artifactId>lombok</artifactId>
+                            <version>${org.projectlombok.version}</version>
+                        </path>
+                        <path>
+                            <groupId>com.github.atool</groupId>
+                            <artifactId>fluent-mybatis-processor</artifactId>
+                            <version>${fluent.mybatis.version}</version>
+                        </path>
+                    </annotationProcessorPaths>
                 </configuration>
                 <dependencies>
                     <dependency>
```

--------------------------------

### SQL Query with Reserved Keyword

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/issues/I4758K

Example of a SQL query where 'Index' is used as a column name, requiring special handling due to it being a reserved keyword.

```sql
SELECT * FROM Test WHERE [Index] >= 1
```

--------------------------------

### Configure Spring Beans

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/01-hello-world

Set up the Spring configuration class including DataSource, SqlSessionFactoryBean, and MapperFactory.

```java
@ComponentScan(basePackages = "cn.org.atool.fluent.mybatis.demo1")
@MapperScan("cn.org.atool.fluent.mybatis.demo1.entity.mapper")
@Configuration
public class HelloWorldConfig {
    /**
     * 设置dataSource属性
     *
     * @return
     */
    @Bean
    public DataSource dataSource() {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/fluent_mybatis?useUnicode=true&characterEncoding=utf8");
        dataSource.setUsername("root");
        dataSource.setPassword("password");
        return dataSource;
    }

    /**
     * 定义mybatis的SqlSessionFactoryBean
     *
     * @param dataSource
     * @return
     */
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        return bean;
    }

   @Bean
   public MapperFactory mapperFactory() {
      return new MapperFactory();
   }
}
```

--------------------------------

### Incorrect Oracle SQL Output

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/issues/I43972

Example of the generated SQL containing double quotes around column names, which causes syntax errors in Oracle.

```sql
INSERT INTO T_MESSAGES ("phone_num", "type", "code", "status", "msg")
VALUES ('*****', 1, 'test', false, 'test')
```

--------------------------------

### Build commands for code generation

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/issues/I1Z2CX

Use these commands to trigger the compilation process and generate the required classes.

```bash
mvn compile
```

```bash
gradle build
```

--------------------------------

### Scan projects with OpenSCA CLI

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/open_sca

Use the CLI tool to analyze project dependencies and vulnerabilities with various output and configuration options.

```bash
opensca-cli -path ${project_path}
```

```bash
opensca-cli -path ${project_path} -out report.html
```

```bash
opensca-cli -url ${url} -token ${token} -path ${project_path}
```

```bash
opensca-cli -db db.json -path ${project_path}
```

--------------------------------

### 实现IDefaultSetter进行自动拦截

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/env_tenant_demo

通过实现IDefaultSetter接口，在增删改查操作中自动注入环境和租户条件。

```java
/**
 * 增删改查中，环境和租户隔离设置
 */
public interface IsolateSetter extends IDefaultSetter {
    /**
     * 插入的entity,如果没有显式设置环境和租户，根据工具类进行默认设置
     *
     * @param entity
     */
    @Override
    default void setInsertDefault(IEntity entity) {
        IsolateEntity isolateEntity = (IsolateEntity) entity;
        if (isolateEntity.getEnv() == null) {
            isolateEntity.setEnv(EnvUtils.currEnv());
        }
        if (isolateEntity.getTenant() == null) {
            isolateEntity.setTenant(TenantUtils.findUserTenant());
        }
    }

    /**
     * 查询条件追加环境隔离和租户隔离
     *
     * @param query
     */
    @Override
    default void setQueryDefault(IQuery query) {
        query.where()
            .apply("env", SqlOp.EQ, EnvUtils.currEnv())
            .apply("tenant", SqlOp.EQ, TenantUtils.findUserTenant());
    }

    /**
     * 更新条件追加环境隔离和租户隔离
     *
     * @param updater
     */
    @Override
    default void setUpdateDefault(IUpdate updater) {
        updater.where()
            .apply("env", SqlOp.EQ, EnvUtils.currEnv())
            .apply("tenant", SqlOp.EQ, TenantUtils.findUserTenant());
    }
}
```

--------------------------------

### Configure Spring Beans

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/v1.5/01-hello-world

Set up the DataSource and SqlSessionFactoryBean for the Fluent Mybatis application using Spring configuration.

```java
@ComponentScan(basePackages = "cn.org.atool.fluent.mybatis.demo1")
@MapperScan("cn.org.atool.fluent.mybatis.demo1.entity.mapper")
@Configuration
public class HelloWorldConfig {
    /**
     * 设置dataSource属性
     *
     * @return
     */
    @Bean
    public DataSource dataSource() {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/fluent_mybatis_tutorial?useUnicode=true&characterEncoding=utf8");
        dataSource.setUsername("root");
        dataSource.setPassword("password");
        return dataSource;
    }

    /**
     * 定义mybatis的SqlSessionFactoryBean
     *
     * @param dataSource
     * @return
     */
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        return bean;
    }
}
```

--------------------------------

### Create Entity Class

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/01-hello-world

Define the HelloWorldEntity class annotated with @FluentMybatis and extending RichEntity.

```java
@FluentMybatis
public class HelloWorldEntity extends RichEntity {
    private Long id;

    private String sayHello;

    private String yourName;

    private Date gmtCreated;

    private Date gmtModified;

    private Boolean isDeleted;
    
    // get, set, toString 方法

   @Override
   public Class<? extends IEntity> entityClass() {
      return HelloWorldEntity.class;
   }
}
```

--------------------------------

### Configure Maven Dependencies

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/01-hello-world

Include the fluent-mybatis runtime and processor dependencies in your pom.xml file.

```xml
<dependencies>
    <!-- 引入fluent-mybatis 运行依赖包, scope为compile -->
    <dependency>
        <groupId>com.github.atool</groupId>
        <artifactId>fluent-mybatis</artifactId>
        <version>1.9.7</version>
    </dependency>
    <!-- 引入fluent-mybatis-processor, scope设置为provider 编译需要，运行时不需要 -->
    <dependency>
        <groupId>com.github.atool</groupId>
        <artifactId>fluent-mybatis-processor</artifactId>
        <version>1.9.7</version>
    </dependency>
</dependencies>
```

--------------------------------

### Configure and execute EntityGenerator

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/v1.5/03-entity-generator

Use the EntityGenerator class to define output paths, package names, database credentials, and the tables to be processed.

```java
public class EntityGeneratorDemo {
    public static void main(String[] args) throws Exception {
        EntityGenerator.build()
            .globalConfig(g -> g
                /** 设置src/java 所在的路径 **/
                .setOutputDir(baseDir + "src/main/java/")
                /** 设置package **/
                .setBasePackage("cn.org.atool.fluent.mybatis.demo3")
                /** 设置数据库连接 **/
                .setDataSource(url, "root", "password")
            )
            .tables(t -> t
                /** 设置需要生成Entity类的表 **/
                .table("hello_world")
                //.table("其它表")
                //.table("其它表")
            )
            .execute();
    }
}
```

--------------------------------

### 使用默认条件查询数据

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/env_tenant_demo

演示使用 defaultQuery() 方法，该方法会自动应用 IsolateSetter 中定义的默认查询条件。

```java
@RunWith(SpringRunner.class)
@SpringBootTest(classes = AppMain.class)
public class QueryWithEnvDemo {
    @Autowired
    private StudentMapper mapper;

    @Test
    public void testQueryWithEnv(){
        mapper.delete(new StudentQuery());
        mapper.insert(new StudentEntity()
            .setAddress("宇宙深处")
            .setUserName("FluentMybatis")
        );
        StudentEntity student = mapper.findOne(mapper.defaultQuery()
            .where.userName().eq("FluentMybatis").end()
            .limit(1));
        System.out.println(student.getUserName() + ", env:" + student.getEnv() + ", tenant:" + student.getTenant());
    }
}
```

```text
DEBUG - ==>  Preparing: SELECT id, gmt_created, ... , tenant, user_name, version 
    FROM student 
    WHERE env = ? 
    AND tenant = ? 
    AND user_name = ? 
    LIMIT ?, ?  
DEBUG - ==> Parameters: test1(String), 222222(Long), FluentMybatis(String), 0(Integer), 1(Integer) 
DEBUG - <==      Total: 1 
FluentMybatis, env:test1, tenant:222222
```

--------------------------------

### Implement Choose Logic in MyBatis XML

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/fluent-mybatis-dynamic

Standard MyBatis XML configuration using <choose>, <when>, and <otherwise> tags to handle conditional query logic.

```xml
<select id="selectByIdOrName" resultMap="BaseResultMap" parameterType="...">
    select
    <include refid="Base_Column_List" />
    from student
    <where>
        <choose>
          <when test="id != null">
            and id=#{id}
          </when>
          <when test="name != null and name != ''">
            and name=#{name}
          </when>
          <otherwise>
            and 1=2
          </otherwise>
        </choose>
    </where>
</select>
```

--------------------------------

### Maven Compiler Annotation Processor Configuration

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/pulls/1/checks

Recommendation to configure annotation processors via the maven-compiler plugin instead of adding them as direct dependencies.

```text
应该使用 maven-compiler 指定注解处理器，而不是引入依赖的方式
```

--------------------------------

### 查看FluentMybatis注解定义

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/env_tenant_demo

FluentMybatis注解中用于配置默认设置实现的属性。

```java
public @interface FluentMybatis {
    /**
     * entity, query, updater默认值设置实现
     *
     * @return
     */
    Class<? extends IDefaultSetter> defaults() default IDefaultSetter.class;
}
```

--------------------------------

### SQL for Many-to-Many Queries

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/master/many2many_demo

SQL queries for fetching ex-partners based on gender and relationship status.

```sql
select * from t_member
where is_deleted=0
  and id in (select boy_id from t_memeber_love
              where status = '前任'
                and girl_id = ? -- 女孩id
                and is_deleted = 0
)
```

```sql
select * from t_member
where is_deleted=0
  and id in (select girl_id from t_memeber_love
              where status = '前任'
                and  boy_id= ? -- 男孩id
                and is_deleted = 0
)
```

--------------------------------

### 配置 FluentMybatis 代码生成器

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

使用 @Tables 注解配置数据库连接信息及表映射，通过 FileGenerator.build 方法生成对应的 Entity 类。

```java
public class AppEntityGenerator {
    static final String url = "jdbc:mysql://localhost:3306/fluent_mybatis?useSSL=false&useUnicode=true&characterEncoding=utf-8";
    /**
     * 生成代码的package路径
     */
    static final String basePackage = "cn.org.fluent.mybatis.many2many.demo";

    public static void main(String[] args) {
        FileGenerator.build(Noting.class);
    }

    @Tables(
        /** 数据库连接信息 **/
        url = url, username = "root", password = "password",
        /** Entity类parent package路径 **/
        basePack = basePackage,
        /** Entity代码源目录 **/
        srcDir = "example/many2many_demo/src/main/java",
        /** 如果表定义记录创建，记录修改，逻辑删除字段 **/
        gmtCreated = "gmt_create", gmtModified = "gmt_modified", logicDeleted = "is_deleted",
        /** 需要生成文件的表 ( 表名称:对应的Entity名称 ) **/
        tables = @Table(value = {"t_member", "t_member_love", "t_member_favorite"}, tablePrefix = "t_")
    )
    static class Noting {
    }
}
```

--------------------------------

### Configure Full Entity Code Generation

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

Defines the database connection, package structure, and relationship mappings for automatic Entity generation.

```java
public class AppEntityFullGenerator {
    static final String url = "jdbc:mysql://localhost:3306/fluent_mybatis?useSSL=false&useUnicode=true&characterEncoding=utf-8";
    /**
     * 生成代码的package路径
     */
    static final String basePackage = "cn.org.fluent.mybatis.many2many.demo";

    public static void main(String[] args) {
        FileGenerator.build(Noting.class);
    }

    @Tables(
        /** 数据库连接信息 **/
        url = url, username = "root", password = "password",
        /** Entity类parent package路径 **/
        basePack = basePackage,
        /** Entity代码源目录 **/
        srcDir = "example/many2many_demo/src/main/java",
        /** 如果表定义记录创建，记录修改，逻辑删除字段 **/
        gmtCreated = "gmt_create", gmtModified = "gmt_modified", logicDeleted = "is_deleted",
        /** 需要生成文件的表 ( 表名称:对应的Entity名称 ) **/
        tables = @Table(value = {"t_member", "t_member_love", "t_member_favorite"}, tablePrefix = "t_"),
        relations = {
             @Relation(method = "findMyFavorite", source = "t_member", target = "t_member_favorite", type = RelationType.OneWay_0_N
                , where = "id=member_id && is_deleted=is_deleted"),
             @Relation(method = "findExFriends", source = "t_member", target = "t_member", type = RelationType.OneWay_0_N),
             @Relation(method = "findCurrFriend", source = "t_member", target = "t_member", type = RelationType.OneWay_0_1)
        }
    )
    static class Noting {
    }
}
```

--------------------------------

### Create student table with isolation fields

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/env_tenant_demo

Defines the student table schema including 'env' for environment isolation and 'tenant' for multi-tenant data separation.

```sql
create table student
(
    id              bigint(21) unsigned auto_increment comment '主键id'
        primary key,
    age             int                  null comment '年龄',
    grade           int                  null comment '年级',
    user_name       varchar(45)          null comment '名字',
    gender_man      tinyint(2) default 0 null comment '性别, 0:女; 1:男',
    birthday        datetime             null comment '生日',
    phone           varchar(20)          null comment '电话',
    bonus_points    bigint(21) default 0 null comment '积分',
    status          varchar(32)          null comment '状态(字典)',
    home_county_id  bigint(21)           null comment '家庭所在区县',
    home_address_id bigint(21)           null comment 'home_address外键',
    address         varchar(200)         null comment '家庭详细住址',
    version         varchar(200)         null comment '版本号',
    env             varchar(10)          NULL comment '数据隔离环境',
    tenant          bigint               NOT NULL default 0 comment '租户标识',
    gmt_created     datetime             null comment '创建时间',
    gmt_modified    datetime             null comment '更新时间',
    is_deleted      tinyint(2) default 0 null comment '是否逻辑删除'
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8
    COMMENT '学生信息表';
```

--------------------------------

### Test4J Configuration Properties

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/04-advanced-generator

Configuration file for Test4J database connectivity, placed in src/test/resources.

```properties
db.dataSource.list=dataSource
db.dataSource.script.factory=cn.org.atool.fluent.mybatis.tutorial.DataSourceScript
db.dataSource.type=mysql
db.dataSource.driver=com.mysql.jdbc.Driver
db.dataSource.url=jdbc:mysql://localhost:3306/fluent_mybatis?characterEncoding=utf8
db.dataSource.userName=root
db.dataSource.password=password
db.dataSource.schemaName=fluent_mybatis
```

--------------------------------

### SQL for Querying Ex-Boyfriends

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

SQL logic required when the member is female.

```sql
select * from t_member
where is_deleted=0
  and id in (select girl_id from t_memeber_love
              where status = '前任'
                and  boy_id= ? -- 男孩id
                and is_deleted = 0
)
```

--------------------------------

### SQL for Querying Ex-Girlfriends

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

SQL logic required when the member is male.

```sql
select * from t_member
where is_deleted=0
  and id in (select boy_id from t_memeber_love
              where status = '前任'
                and girl_id = ? -- 女孩id
                and is_deleted = 0
)
```

--------------------------------

### Debug Log Output for Many-to-Many Query

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

Log output showing the dynamic SQL generation for the many-to-many relationship.

```text
DEBUG - ==>  Preparing: SELECT id, ..., user_name FROM t_member WHERE id = ?  
DEBUG - ==> Parameters: 1(Long) 
DEBUG - <==      Total: 1 
是否女孩:true
DEBUG - ==>  Preparing: SELECT id, ..., user_name FROM t_member 
    WHERE is_deleted = ? 
    AND id IN (SELECT boy_id 
        FROM t_member_love 
        WHERE status = ? 
        AND is_deleted = ? 
        AND girl_id = ?)  
DEBUG - ==> Parameters: false(Boolean), 前任(String), false(Boolean), 1(Long) 
DEBUG - <==      Total: 1 
[MemberEntity(id=2, gmtModified=Sun Nov 08 12:31:57 CST 2020, isDeleted=false, age=null, gmtCreated=null, isGirl=false, school=null, userName=mike)]
```

--------------------------------

### 定义多对多关系数据库表结构

Source: https://gitee.com/fluent-mybatis/fluent-mybatis-docs/tree/develop/many2many_demo

包含成员表、恋爱关系表以及成员爱好表的 SQL 定义，用于支持多对多关联查询。

```sql
CREATE TABLE t_member
(
    id           bigint(21) unsigned auto_increment primary key COMMENT '主键id',
    user_name    varchar(45) DEFAULT NULL COMMENT '名字',
    is_girl      tinyint(1)  DEFAULT 0 COMMENT '0:男孩; 1:女孩',
    age          int         DEFAULT NULL COMMENT '年龄',
    school       varchar(20) DEFAULT NULL COMMENT '学校',
    gmt_created  datetime    DEFAULT NULL COMMENT '创建时间',
    gmt_modified datetime    DEFAULT NULL COMMENT '更新时间',
    is_deleted   tinyint(1)  DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB
  CHARACTER SET = utf8 COMMENT = '成员表:女孩或男孩信息';

CREATE TABLE t_member_love
(
    id           bigint(21) unsigned auto_increment primary key COMMENT '主键id',
    girl_id      bigint(21) NOT NULL COMMENT 'member表外键',
    boy_id       bigint(21) NOT NULL COMMENT 'member表外键',
    status       varchar(45) DEFAULT NULL COMMENT '状态',
    gmt_created  datetime    DEFAULT NULL COMMENT '创建时间',
    gmt_modified datetime    DEFAULT NULL COMMENT '更新时间',
    is_deleted   tinyint(2)  DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB
  CHARACTER SET = utf8 COMMENT = '成员恋爱关系';

CREATE TABLE t_member_favorite
(
    id           bigint(21) unsigned auto_increment primary key COMMENT '主键id',
    member_id    bigint(21) NOT NULL COMMENT 'member表外键',
    favorite     varchar(45) DEFAULT NULL COMMENT '爱好: 电影, 爬山, 徒步...',
    gmt_created  datetime    DEFAULT NULL COMMENT '创建时间',
    gmt_modified datetime    DEFAULT NULL COMMENT '更新时间',
    is_deleted   tinyint(2)  DEFAULT 0 COMMENT '是否逻辑删除'
) ENGINE = InnoDB
  CHARACTER SET = utf8 COMMENT = '成员爱好';
```
Tokens:
Raw