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 ‘學(xué)校',
gmt_created datetime DEFAULT NULL COMMENT ‘創(chuàng)建時(shí)間',
gmt_modified datetime DEFAULT NULL COMMENT ‘更新時(shí)間',
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 ‘狀態(tài)',
gmt_created datetime DEFAULT NULL COMMENT ‘創(chuàng)建時(shí)間',
gmt_modified datetime DEFAULT NULL COMMENT ‘更新時(shí)間',
is_deleted tinyint(2) DEFAULT 0 COMMENT ‘是否邏輯刪除'
) ENGINE = InnoDB
CHARACTER SET = utf8 COMMENT = ‘成員戀愛(ài)關(guān)系';

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 ‘愛(ài)好: 電影, 爬山, 徒步…',
gmt_created datetime DEFAULT NULL COMMENT ‘創(chuàng)建時(shí)間',
gmt_modified datetime DEFAULT NULL COMMENT ‘更新時(shí)間',
is_deleted tinyint(2) DEFAULT 0 COMMENT ‘是否邏輯刪除'
) ENGINE = InnoDB
CHARACTER SET = utf8 COMMENT = ‘成員愛(ài)好';

public class AppEntityGenerator {


static final String url = “jdbc:mysql://localhost:3306/fluent_mybatis_demo?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(
    /** 數(shù)據(jù)庫(kù)連接信息 **/
    url = url, username = "root", password = "password",
    /** Entity類parent package路徑 **/
    basePack = basePackage,
    /** Entity代碼源目錄 **/
    srcDir = "example/many2many_demo/src/main/java",
    /** 如果表定義記錄創(chuàng)建，記錄修改，邏輯刪除字段 **/
    gmtCreated = "gmt_create", gmtModified = "gmt_modified", logicDeleted = "is_deleted",
    /** 需要生成文件的表 ( 表名稱:對(duì)應(yīng)的Entity名稱 ) **/
    tables = @Table(value = {"t_member", "t_member_love", "t_member_favorite"}, tablePrefix = "t_")
)
static class Noting {
}}

public class MemberEntity extends RichEntity implements IEntity {
// …
/**
* 我的愛(ài)好列表
*
* @return
*/
@RefMethod(“memberId=id”)
public List findMyFavorite() {
return super.loadCache(“findMyFavorite”, MemberEntity.class);
}
}

/**
*

Refs:o - 查詢器，更新器工廠類單例引用o - 應(yīng)用所有Mapper Bean引用o - Entity關(guān)聯(lián)對(duì)象延遲加載查詢實(shí)現(xiàn)@author powered by FluentMybatis
*/
public abstract class Refs extends EntityRefQuery {
public List findMyFavoriteOfMemberEntity(MemberEntity entity) {
return memberFavoriteMapper.listEntity(new MemberFavoriteQuery()
.where.memberId().eq(entity.getId())
.end());
}
}

@Service
public class AllRelationQuery extends Refs {
}

@RunWith(SpringRunner.class)
@SpringBootTest(classes = Application.class)
public class FindMemberFavoriteTest {
@Autowired
private MemberMapper memberMapper;

@Before
public void setup() {
    // 省略數(shù)據(jù)準(zhǔn)備部分
}

@Test
public void findMyFavorite() {
    MemberEntity member = memberMapper.findById(1L);
    List<MemberFavoriteEntity> favorites = member.findMyFavorite();
    System.out.println("愛(ài)好項(xiàng): " + favorites.size());
}


}

public class MemberEntity extends RichEntity implements IEntity {
@RefMethod(“memberId=id && isDeleted=isDeleted”)
public List findMyFavorite() {
return super.loadCache(“findMyFavorite”, MemberEntity.class);
}
}

public abstract class Refs extends EntityRefQuery {
public List findMyFavoriteOfMemberEntity(MemberEntity entity) {
return memberFavoriteMapper.listEntity(new MemberFavoriteQuery()
.where.isDeleted().eq(entity.getIsDeleted())
.and.memberId().eq(entity.getId())
.end());
}
}

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
愛(ài)好項(xiàng): 2

public class MemberEntity extends RichEntity implements IEntity {
/**
* 前任男(女)朋友列表
*
* @return
*/
@RefMethod
public List findExFriends() {
return super.loadCache(“findExFriends”, MemberEntity.class);
}
}

public abstract class Refs extends EntityRefQuery {
/**
* 返回前任男(女)朋友列表
*/
public abstract List findExFriendsOfMemberEntity(MemberEntity entity);
}

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
)

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
)

@Service
public class AllRelationQuery extends Refs {
@Override
public List findExFriendsOfMemberEntity(MemberEntity entity) {
MemberQuery query = new MemberQuery()
.where.isDeleted().isFalse()
.and.id().in(MemberLoveQuery.class, q -> q
.select(entity.getIsGirl() ? boyId.column : girlId.column)
.where.status().eq(“前任”)
.and.isDeleted().isFalse()
.and.girlId().eq(entity.getId(), o -> entity.getIsGirl())
.and.boyId().eq(entity.getId(), o -> !entity.getIsGirl())
.end())
.end();
return memberMapper.listEntity(query);
}
}

@RunWith(SpringRunner.class)
@SpringBootTest(classes = Application.class)
public class FindExFriendsTest {
@Autowired
private MemberMapper memberMapper;

@Test
public void findExBoyFriends() {
    MemberEntity member = memberMapper.findById(1L);
    System.out.println("是否女孩:" + member.getIsGirl());
    List<MemberEntity> boyFriends = member.findExFriends();
    System.out.println(boyFriends);
}


}

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)]