Fluent Mybatis快速入门详细教程

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 = ‘成员爱好' ;

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 (

     /** 数据库连接信息 **/

     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 {

}}

public class MemberEntity extends RichEntity implements IEntity {

// …

/**

* 我的爱好列表

*

* @return

*/

@RefMethod ([memberId=id])

public List findMyFavorite() {

return super .loadCache([findMyFavorite], MemberEntity. class );

}

}

/**

*

Refs:o - 查询器，更新器工厂类单例引用o - 应用所有Mapper Bean引用o - Entity关联对象延迟加载查询实现@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() {

     // 省略数据准备部分

}

@Test

public void findMyFavorite() {

     MemberEntity member = memberMapper.findById(1L);

     List<MemberFavoriteEntity> favorites = member.findMyFavorite();

     System.out.println( "爱好项: " + 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

爱好项: 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)]