multi-table-query 多表查询DAO框架

1.功能&特点

①.基础多表查询的简单&统一实现 (不需手写xxxMapper.xml)

使用习惯类似 MyBatis-Plus https://baomidou.com

public class UserStaff {
    private String staffName;
    private TestConst.SexEnum sex;
    private Long adminUserId;
    //关联表属性(属性名为relationCode)
    private User userAndUserStaff;
}

List<UserStaff> userStaffsSimple = MultiExecutor.list(
    new MultiWrapper<>(MultiWrapperMain.lambda(UserStaff.class), User.class, UserAddress.class)
);

IMultiPage<UserStaff> page = MultiExecutor.page(new MultiPage<>(1, 10),
    new MultiWrapper<>(MultiWrapperMain.lambda(UserStaff.class)
	    .desc(BaseModel::getCreateTime)
	    , User.class, UserAddress.class, Address.class));

MultiAggregateResult aggregateSumAll = MultiExecutor.aggregate(
    new MultiWrapper<>(MultiWrapperMain.lambda(UserStaff.class).aggregateAll(MultiConstant.MultiAggregateTypeEnum.SUM),
    MultiWrapperSub.lambda(User.class)
));
//...包含有 list getOne page aggregate(聚合,例如sum) paramMap(统一参数传递)... 等查询功能

//list查询结果:
[
  {
    "id": 11,
    "createTime": "2021-11-09",
    "updateTime": "2021-11-09",
    "staffName": "staff1",
    "sex": 0,
    "adminUserId": 1,
    "userAndUserStaff": {
      "id": 1,
      "createTime": "2021-11-09",
      "updateTime": "2021-11-09",
      "username": "username1",
      "sex": 1,
      "parentId": null,
      "userAndUserAddress": [
	{
	  "id": 111,
	  "createTime": "2021-11-09",
	  "updateTime": "2021-11-09",
	  "userId": "1",
	  "province": "province1",
	  "street": "street1"
	},
	{
	  "id": 112,
	  "createTime": "2021-11-09",
	  "updateTime": "2021-11-09",
	  "userId": "1",
	  "province": "province2",
	  "street": "street2"
	}
      ]
    }
  },
  {}
]

②.实体类可以直接用枚举类做属性

数据库中储存IMultiEnum.getValue(),查询结果出来为具体的枚举属性 (spring-mvc下依赖jackson枚举自定义序列化)

2.快速入门

1.引入jar

<!-- https://mvnrepository.com/artifact/io.github.qaz4042/multi-table-query -->
<dependency>
    <groupId>io.github.qaz4042</groupId>
    <artifactId>multi-table-query</artifactId>
    <version>0.0.2</version>
</dependency>

2.配置表和表的关系,数据库查询引擎

public class MybatisPlusMultiConfig {
    public static void build() {
        MultiConfig.build(
                new MultiProperties(),
		//表和表的关系
                new MultiTableRelationServiceImpl(),
//                new MultiDbJdbcAdaptor(
//                        "org.h2.Driver",
//                        "jdbc:h2:mem:multi_table_query_demo",
//                        "multi_table_query_demo",
//                        ""
//                )
		// 数据库查询引擎
                new MultiDbJdbcAdaptor( 
                "com.mysql.jdbc.Driver",
                "jdbc:mysql://127.0.0.1:3306/multi_table_query_demo?useUnicode=true&characterEncoding=utf-8",
                "root",
                "root"
                )
        );
    }
}

//表和表的关系
public class MultiTableRelationServiceImpl implements MultiTableRelationService {

    @Override
    public List<MultiClassRelation> loadRelation() {
        //todo可以查询数据库/枚举信息
        return Arrays.asList(MultiClassRelation.builder()
                        .code("userAndUserStaff")
                        .className1("user")
                        .class1KeyProp("id")
                        .class1OneOrMany(MultiConstant.ClassRelationOneOrManyEnum.ONE)
                        .class1Require(true)
                        .className2("userStaff")
                        .class2KeyProp("adminUserId")
                        .class2OneOrMany(MultiConstant.ClassRelationOneOrManyEnum.MANY)
                        .class2Require(false)
                        .build()
        );
    }
}

3.使用

List<UserStaff> userStaffsSimple = MultiExecutor.list(
    new MultiWrapper<>(MultiWrapperMain.lambda(UserStaff.class), User.class, UserAddress.class)
);

3.DEMO项目

multi-table-query-demo

multi-table-query-demo-jdk
    测试入口类 Main.java 中 main() 方法
multi-table-query-demo-spring
    测试入口类 MultiTableQueryDemoApplicationTest.java 中 @Test 相关方法

4.调试环境

jdk8 mysql5.6

jdk8 spring-jdbc h2database(内存数据库模式)/mysql5.6

5.交流讨论

QQ群    multi-table-query交流群    390137834
群主QQ 404286846

6.license

Apache Licence 2.0

7.作者有话说 & 赞助

该框架立足点:
1.关系型事务数据库,对服务端编程的意义
2.Mybatis相对于Hibernate编程的高可扩展性和易用性兼并,以及MybatisPlus等框架,对其单表增删改查的便捷性优化,的充分支持
3.对[基础的多表查询],在编程,开发和扩展功能时,存在的重复和琐碎的,编程&对接&测试的工作量,高度不可忍
该框架相斥观点:(也欢迎讨论battle)
4.DTO,VO的必须95%以上强制使用,尤其是公司内部2个服务(例如:微服务的上下层)的对接时也强制使用DTO,VO的规范论
5.实体类为了干净而干净,为了大众规范的强制分层论 
	(认为,实体类应有规划地调整,靠近面向对象编程,靠近java核心(面向对象设计-编码-编译-运行)开发生态的优化)

为更nice更有爱的代码,加油