Spring JdbcTemplate实现自定义动态sql拼接功能

需求描述：

        sql 需要能满足支持动态拼接，包含 查询字段、查询表、关联表、查询条件、关联表的查询条件、排序、分组、去重等

实现步骤：

        1，创建表及导入测试数据

CREATE TABLE YES_DEV.T11 (
	ID BINARY_BIGINT NOT NULL,
	NAME VARCHAR(10),
	XX BINARY_BIGINT,
	CONSTRAINT _PK_SYS_25_63 PRIMARY KEY (ID)
);
CREATE TABLE YES_DEV.T111 (
	ID BINARY_INTEGER NOT NULL,
	NAME NUMBER
);
INSERT INTO YES_DEV.T11 (ID,NAME,XX) VALUES
	 (11,'123',11),
	 (9,'9',9),
	 (8,'8',8),
	 (7,'7',7),
	 (6,'6',6),
	 (5,'5',5),
	 (4,'4',4),
	 (3,'3',3),
	 (2,'2',2),
	 (1,'1',1);
INSERT INTO YES_DEV.T111 (ID,NAME) VALUES
	 (1,123);

        2，创建项目并引入 pom依赖

    4.0.0
    org.example
    testMybatis
    1.0-SNAPSHOT
    
    
        org.springframework.boot
        spring-boot-starter-parent
        2.5.8
        
    
    
        15
        15
        UTF-8
    
    
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.4
        
        
        
            com.huawei.gauss
            com.huawei.gauss.jdbc.ZenithDriver
            1.2.1
        
        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
            junit
            junit
            test
        
        
            com.baomidou
            mybatis-plus-boot-starter
            3.4.2
        
        
            commons-lang
            commons-lang
            2.6
        
        
            commons-collections
            commons-collections
            3.2.2
        
        
            com.google.guava
            guava
            30.1-jre
        
    
    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
                
                    
                        
                            org.projectlombok
                            lombok
                        
                    
                
            
        
    

        3，编写 application.properties文件

spring.datasource.url=jdbc:zenith:@xxxx:xxx
spring.datasource.username=xxx
spring.datasource.password=xxxx
spring.datasource.driver-class-name=com.huawei.gauss.jdbc.inner.GaussDriver
mybatis.mapper-locations=classpath:mapper/*.xml
org.apache.springframework.jdbc.core.JdbcTemplate = debug

        4，核心类之 Column

package com.example.dao.sql;
import com.example.utils.SqlUtils;
import lombok.Getter;
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang.ArrayUtils;
import org.apache.commons.lang.StringUtils;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Objects;
@Getter
public class Column {
    private final String name;
    private final List tableAliases = new ArrayList();
    private Column(String name, List tableAliases) {
        this.name = name;
        if (CollectionUtils.isNotEmpty(tableAliases)) {
            this.tableAliases.addAll(tableAliases);
        }
    }
    public static Column of(String name, String... tableAliases) {
        if (ArrayUtils.isNotEmpty(tableAliases)) {
            tableAliases = Arrays.stream(tableAliases).filter(Objects::nonNull).toArray(String[]::new);
        }
        if (ArrayUtils.isEmpty(tableAliases)) {
            String tableAlias = StringUtils.substringBefore(name, ".").trim();
            if (SqlUtils.isValidAlias(tableAlias)) {
                tableAliases = new String[] {tableAlias};
            }
        }
        return new Column(name, ArrayUtils.isEmpty(tableAliases) ? null : Arrays.asList(tableAliases));
    }
    public String getTableAlias() {
        return tableAliases.isEmpty() ? null : tableAliases.get(0);
    }
}

        5，核心类之 Table

package com.example.dao.sql;
import com.baomidou.mybatisplus.core.toolkit.support.SFunction;
import com.example.utils.SqlUtils;
import org.apache.commons.lang.ArrayUtils;
import org.apache.commons.lang.StringUtils;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import java.util.function.Function;
import java.util.function.Predicate;
import java.util.stream.Collectors;
import java.util.stream.Stream;
public class Table {
    private String joinType;
    private boolean weak;
    private boolean optimizable = true;
    private Map> joinPredicateConditions = new ArrayList();
    private final List filterConditions = new ArrayList();
    private final List> getJoinPredicateConditions() {
        return joinPredicateConditions;
    }
    public List getFilterConditions() {
        return filterConditions;
    }
    public List> getParameterTempData() {
        return parameterTempData;
    }
    public void setParameterTempData(Map