凡图科技

主题

fine-data模块 ​

  • 通用数据接口

依赖

  • pom.xml
xml
<!--fine-data-->
<dependency>
    <groupId>cn.finemap</groupId>
    <artifactId>fine-data</artifactId>
    <version>${fine.version}</version>
</dependency>

配置

  • src/main/resources/application.yml
yaml
# 使用data配置
springdoc:
  # openapi分组
  group-configs:
    - group: '后台管理'
      paths-to-match: '/**'
      packages-to-scan: cn.finemap.data.base
    - group: '数据管理'
      paths-to-match: '/**'
      packages-to-scan: cn.finemap.data.data
    - group: '联表查询'
      paths-to-match: '/**'
      packages-to-scan: cn.finemap.data.union
    - group: '聚合查询'
      paths-to-match: '/**'
      packages-to-scan: cn.finemap.data.aggr
    - group: 'excel管理'
      paths-to-match: '/**'
      packages-to-scan: cn.finemap.data.excel

启动类注解

java
@ComponentScan(basePackages = {"cn.finemap"})
@EnableJpaRepositories({"cn.finemap"})
@EntityScan({"cn.finemap"})

创建子模块：fine-data ​

  • 在fine-parent中创建：fine-data子模块

fine-data

  • 创建子模块：New > Module...
  • 添加依赖
  • 添加接口：base、data、union
依赖
  • fine-data/pom.xml
xml
<dependencies>
  <!--fine-boot-->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-boot</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!-- fine-commons -->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-commons</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!-- fine-sql -->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-sql</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!-- fine-logs -->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-logs</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!-- fine-doc -->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-doc</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!--fine-cache-->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-cache</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
  <!--fine-auth-->
  <dependency>
      <groupId>cn.finemap</groupId>
      <artifactId>fine-auth</artifactId>
      <version>${fine.version}</version>
      <optional>true</optional>
  </dependency>
</dependencies>
数据操作配置application-data.yml
  • src/main/resources/application-data.yml
yaml
fine:
  data:
    # 数据库设置
    sql:
      # 数据库备份路径
      # backup: /sql/backup
      # 数据库运行路径 :如果不存在，使用应用resources中的路径
      # run: /sql/run/fine_base.sql
    # 批处理设置
    batch:
      # 是否启用批处理
      # enabled: true
      # 批处理大小
      # size: 1000

fine-data使用 ​

服务调用 ​

后台管理 ​

表后台管理

java
@Slf4j
@Service
public class TestService {

    @Autowired
    private FmBaseService fmBaseService;

    //用例数据
    private final static String appName = "admin";
    private final static String tableName = "tableName";
   
    // 获取表信息
    public Result getBase(){
      Result<BaseVo> result = fmBaseService.getBase(appName, tableName);
      Result<BaseVo> result = fmBaseService.getBase(appName, tableName, TableType.PUBLIC);
      Result<BaseVo> result = fmBaseService.getBase(appName, tableName, TableType.TREE);
      return result;
    }
	
}

:::

数据管理 ​

普通表数据服务

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 添加接口
  public Result<HashMap> add(){

    // 添加Map数据
    HashMap<String, Object> map = new HashMap<>();
    map.put("name", "测试名称");
    map.put("age", 25);
    map.put("time", new Date());
    Result<HashMap> addResult = publicDataService.add(appName, tableName, JSON.toJSONString(map));

    // 添加字符串，JSON结构
    String params = "{\"name\":\"测试名称\",\"age\":25}";
    Result<HashMap> addResult = publicDataService.add(appName, tableName, params);

    // 添加成功，返回参数
    if (addResult.isSuccess()){
      HashMap data = addResult.getData();
    }
    return addResult;
  }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 批量添加接口
  public Result adds(){
     // 添加字符串，JSON结构
    String params = "[{\"name\":\"测试名称1\",\"age\":25},{\"name\":\"测试名称2\",\"age\":26}]";
    Result addsResult =  publicDataService.adds(appName, tableName, params);

     // 添加成功，返回参数
    if (addsResult.isSuccess()){
      String data = addsResult.getData();
    }
    return addsResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 删除接口
  public Result<String> delete(){
    String id = "1";
    Result<String> delResult = publicDataService.delete(appName, tableName, id);

    
     // 删除成功，返回参数
    if (delResult.isSuccess()){
      String data = delResult.getData();
    }
    return delResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 批量删除
  public Result<String> deletes(){
    String ids = "[\"1\",\"2\"]";
    Result<String> delsResult = publicDataService.deletes(appName, tableName, ids);

     // 删除成功，返回参数
    if (delsResult.isSuccess()){
      String data = delsResult.getData();
    }
    return delsResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 条件删除
  public Result conditionDeletes(){
      String params = "{\"name\":\"测试名称\",\"age\":25}";
      String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
      Result<String> conditionDelResult = publicDataService.conditionDeletes(appName, tableName, params,matcherFormat);

      // 删除成功，返回参数
      if (conditionDelResult.isSuccess()){
        String data = conditionDelResult.getData();
      }
      return conditionDelResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 修改接口
  public Result<HashMap> update(){
      String params = "{\"id\":1,\"age\":25}";
      Result<HashMap> updateResult = publicDataService.update(appName, tableName, params,true);

       // 修改成功，返回参数
      if (updateResult.isSuccess()){
        HashMap data = updateResult.getData();
      }
      return updateResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 获取单条接口
  public Result get(){
    String id = "uuid";
    Result<HashMap> result = publicDataService.get(appName, tableName, id);

    // 获取成功，返回参数
    if (result.isSuccess()){
      HashMap data = result.getData();
    }
    return result;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 列表查询接口
  public ResponseResult<List<Map<String, Object>>> findAll(){
    String params = "{\"key\":\"value\"}";
    String sortFormat = "{\"sortNum\":\"ASC\"}";
    String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
    // 时间格式：字符串，2025-05-23 15:10:01
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"2025-05-23 15:10:01\" }"; 
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"2025-05-23\" }"; 
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"" + JSON.toJSONString(new Date()) + "\" }"; 
    // 时间格式：SimpleDateFormat，2025-05-23 15:10:01.108
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"" + (new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")).format(new Date()) + "\" }"; 
    // 时间格式：Timestamp，2025-05-23 15:10:01.108
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"" + new Timestamp(System.currentTimeMillis()) + "\" }"; 
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"" + new Timestamp((new Date()).getTime()) + "\" }";
    // String matcherFormat = "{\"name\" : \"name\",\"value\" : \"" + Timestamp.valueOf(timeUpdate) + "\" }";
    ResponseResult<List<Map<String, Object>>> findAllResult = publicDataService.findAll(appName, tableName, params, sortFormat, matcherFormat);

    // 获取成功，返回参数
    if (findAllResult.isSuccess()){
      <List<Map<String, Object>>> findAllData = findAllResult.getData();
    }
    return findAllResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicDataService publicDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 分页查询接口
  public PageResult<List<Map<String, Object>>> page(){
    String params = "{\"key\":\"value\"}";
    String sortFormat = "{\"sortNum\":\"ASC\"}";
    String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
    PageResult<List<Map<String, Object>>> pageResult = publicDataService.page(appName, tableName, 1, 10000, params, sortFormat, matcherFormat);

    // 获取成功，返回参数
    if (pageResult.isSuccess()){
      <List<Map<String, Object>>> pageData = pageResult.getData();
    }
    return pageResult;
  }
  
}

树表数据服务

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 添加接口
  public Result<HashMap> add(){

    // 添加Map数据
    HashMap<String, Object> map = new HashMap<>();
    map.put("name", "测试名称");
    map.put("age", 25);
    map.put("pid",1)
    Result<HashMap> addResult = treeDataService.add(appName, tableName, JSON.toJSONString(map));

    // 添加字符串，JSON结构
    String params = "{\"name\":\"测试名称\",\"age\":25,\"pid\":1}";
    Result<HashMap> addResult = treeDataService.add(appName, tableName, params);

    // 添加成功，返回参数
    if (addResult.isSuccess()){
      HashMap data = addResult.getData();
    }
    return addResult;
  }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 批量添加接口
  public Result adds(){
     // 添加字符串，JSON结构
    String params = "[{\"name\":\"测试名称1\",\"age\":25,\"pid\":1},{\"name\":\"测试名称2\",\"age\":25,\"pid\":2}]";
    Result addsResult =  treeDataService.adds(appName, tableName, params);

     // 添加成功，返回参数
    if (addsResult.isSuccess()){
      String data = addsResult.getData();
    }
    return addsResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 删除接口
  public Result<String> delete(){
    String id = "1";
    Result<String> delResult = treeDataService.delete(appName, tableName, id);

    
     // 删除成功，返回参数
    if (delResult.isSuccess()){
      String data = delResult.getData();
    }
    return delResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 批量删除
  public Result<String> deletes(){
    String ids = "[\"1\",\"2\"]";
    Result<String> delsResult = treeDataService.deletes(appName, tableName, ids);

     // 删除成功，返回参数
    if (delsResult.isSuccess()){
      String data = delsResult.getData();
    }
    return delsResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 条件删除
  public Result conditionDeletes(){
      String params = "{\"name\":\"测试名称\",\"age\":25}";
      String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
      Result<String> conditionDelResult = treeDataService.conditionDeletes(appName, tableName, params,matcherFormat);

      // 删除成功，返回参数
      if (conditionDelResult.isSuccess()){
        String data = conditionDelResult.getData();
      }
      return conditionDelResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 修改接口
  public Result<HashMap> update(){
      String params = "{\"id\":1,\"age\":25}";
      Result<HashMap> updateResult = treeDataService.update(appName, tableName, params,true);

       // 修改成功，返回参数
      if (updateResult.isSuccess()){
        HashMap data = updateResult.getData();
      }
      return updateResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 获取单条接口
  public Result get(){
    String id = "1";
    Result<HashMap> result = treeDataService.get(appName, tableName, id);

    // 获取成功，返回参数
    if (result.isSuccess()){
      HashMap data = result.getData();
    }
    return result;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 列表查询接口
  public ResponseResult<List<Map<String, Object>>> findAll(){
    String params = "{\"key\":\"value\"}";
    String sortFormat = "{\"sortNum\":\"ASC\"}";
    String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
    ResponseResult<List<Map<String, Object>>> findAllResult = treeDataService.findAll(appName, tableName, params, sortFormat, matcherFormat);

    // 获取成功，返回参数
    if (findAllResult.isSuccess()){
      <List<Map<String, Object>>> findAllData = findAllResult.getData();
    }
    return findAllResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 分页查询接口
  public PageResult<List<Map<String, Object>>> page(){
    String params = "{\"key\":\"value\"}";
    String sortFormat = "{\"sortNum\":\"ASC\"}";
    String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
    PageResult<List<Map<String, Object>>> pageResult = treeDataService.page(appName, tableName, 1, 10000, params, sortFormat, matcherFormat);

    // 获取成功，返回参数
    if (pageResult.isSuccess()){
      <List<Map<String, Object>>> pageData = pageResult.getData();
    }
    return pageResult;
  }
  
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeDataService treeDataService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  // 树接口
  public TreeResult<List<Map<String, Object>>> tree(){
    String params = "{\"key\":\"value\"}";
    String sortFormat = "{\"sortNum\":\"ASC\"}";
    String matcherFormat = "{\"name\" : \"名称\",\"value\" : 1}";
    TreeDTO treeDTO = new TreeDTO();
    treeDTO.setMatcherFormat(matcherFormat);
    treeDTO.setSortFormat(sortFormat);
    treeDTO.setRootReduce(false);
    treeDTO.setChildField("children");
    treeDTO.setQueryType("tree");
    treeDTO.setAsync(false);
    treeDTO.setIsParent("isParent");

    TreeResult<List<Map<String, Object>>> treeResult = treeDataService.tree(appName, tableName, 1, 10000, params, treeDTO);

    // 获取成功，返回参数
    if (treeResult.isSuccess()){
      <List<Map<String, Object>>> treeData = treeResult.getData();
    }
    return treeResult;
  }
  
}

联表查询 ​

普通表联表查询服务

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicUnionService publicUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"field\": \"org-1\", \"table\": \"org\"";
      String unionFormat = UnionFormatUtil.oneToOne(field, table); //简写
      String unionFormat = UnionFormatUtil.oneToOne(field, table, key,view, nullable, type);
      String fieldFormat = ["name", "sortNum"];
      //获取单条数据
      Result unionResult = publicUnionService.getUnion(appName,tableName, id, unionFormat, fieldFormat);

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = publicUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat, fieldFormat);
      //获取分页列表数据
      Result unionResult = publicUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicUnionService publicUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"table\": \"user\",\"key\": \"depId\",\"view\": \"users\"}";
      String unionFormat = UnionFormatUtil.oneToMany(table, key); //简写
      String unionFormat = UnionFormatUtil.oneToMany(field, table, key,view, nullable, type);
      Result unionResult = publicUnionService.getUnion(appName,tableName, id, unionFormat);
      //获取单条数据
      String fieldFormat = ["name", "sortNum"];

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = publicUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat);
      //获取分页列表数据
      Result unionResult = publicUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicUnionService publicUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"table\": \"role\",\"view\": \"roles\"," +
              "\"join\":{\"field\": \"userid\",\"table\": \"userRole\"\"key\": \"roleId\"}" +
              "}";
      String unionFormat = UnionFormatUtil.ManyToMany(table, view, joinField , joinTable, joinKey); //简写
      String unionFormat = UnionFormatUtil.ManyToMany(field, table, key, view, nullable, type, joinField, joinTable, joinKey);
      String fieldFormat = ["name", "sortNum"];
      //获取单条数据
      Result unionResult = publicUnionService.getUnion(appName,tableName, id, unionFormat, fieldFormat);

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = publicUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat, fieldFormat);
      //获取分页列表数据
      Result unionResult = publicUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat, fieldFormat);
    }
}

树表联表查询服务

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeUnionService treeUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"field\": \"org-1\", \"table\": \"org\"";
      String unionFormat = UnionFormatUtil.oneToOne(field, table); //简写
      String unionFormat = UnionFormatUtil.oneToOne(field, table, key,view, nullable, type);
      String fieldFormat = ["name", "sortNum"];
      //获取单条数据      
      Result unionResult = treeUnionService.getUnion(appName,tableName, id, unionFormat, fieldFormat);

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = treeUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat, fieldFormat);
      //获取分页列表数据
      Result unionResult = treeUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat ,fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeUnionService treeUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"table\": \"user\",\"key\": \"depId\",\"view\": \"users\"}";
      String unionFormat = UnionFormatUtil.oneToMany(table, key); //简写
      String unionFormat = UnionFormatUtil.oneToMany(field, table, key,view, nullable, type);
      String fieldFormat = ["name", "sortNum"];
      //获取单条数据
      Result unionResult = treeUnionService.getUnion(appName,tableName, id, unionFormat, fieldFormat);

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = treeUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat, fieldFormat);
      //获取分页列表数据
      Result unionResult = treeUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeUnionService treeUnionService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String unionFormat = "{\"table\": \"role\",\"view\": \"roles\"," +
              "\"join\":{\"field\": \"userid\",\"table\": \"userRole\"\"key\": \"roleId\"}" +
              "}";
      String unionFormat = UnionFormatUtil.ManyToMany(table, view, joinField , joinTable, joinKey); //简写
      String unionFormat = UnionFormatUtil.ManyToMany(field, table, key, view, nullable, type, joinField, joinTable, joinKey);
      String fieldFormat = ["name", "sortNum"];
      //获取单条数据
      Result unionResult = treeUnionService.getUnion(appName,tableName, id, unionFormat, fieldFormat);

      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      //获取列表数据
      Result unionResult = treeUnionService.findAllUnion(appName, tableName, params, sortFormat, matcherFormat, unionFormat, fieldFormat);
      //获取分页列表数据
      Result unionResult = treeUnionService.pageUnion(appName, tableName, params, 1, 10, sortFormat, matcherFormat, unionFormat, fieldFormat);
    }
}

聚合查询 ​

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private AggrService aggrService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      //获取最大值
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String fieldFormat = ["name", "sortNum"];
      ResponseResult<Map<String, Object>> unionResult = aggrService.max(appName, tableName, params, matcherFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private AggrService aggrService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      //获取最小值
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String fieldFormat = ["name", "sortNum"];
      ResponseResult<Map<String, Object>> unionResult = aggrService.min(appName, tableName, params, matcherFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private AggrService aggrService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      //获取平均值
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String fieldFormat = ["name", "sortNum"];
      ResponseResult<Map<String, Object>> unionResult = aggrService.avg(appName, tableName, params, matcherFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private AggrService aggrService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      //获取总和
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String fieldFormat = ["name", "sortNum"];
      ResponseResult<Map<String, Object>> unionResult = aggrService.sum(appName, tableName, params, matcherFormat, fieldFormat);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private AggrService aggrService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      //获取数量
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String fieldFormat = ["name", "sortNum"];
      ResponseResult<Map<String, Object>> unionResult = aggrService.count(appName, tableName, params, matcherFormat, fieldFormat);
    }
}

Excel管理 ​

java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicExcelService publicExcelService;
  
  public void test() {
      String excelData =  "[{\"name\":\"属性名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      String fileName = "钢筋.xlsx";
      ResponseEntity unionResult = publicExcelService.exportExcelHeader(excelData, fileName);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicExcelService publicExcelService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"钢筋\"}";
      String excelData =  "[{\"name\":\"属性名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      String fileName = "钢筋.xlsx";

      ResponseEntity unionResult = publicExcelService.exportExcelHeader(appName, tableName, params, sortFormat, matcherFormat, excelData, fileName);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private PublicExcelService publicExcelService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String params = "{\"name\": \"钢筋\"}";
      String excelData =  "[{\"name\":\"属性名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      Result unionResult = publicExcelService.exportExcelHeader(appName, tableName, file, params, excelData);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeExcelService treeExcelService;
   
  public void test() {
      String treeName = "流域名称";
      String excelData =  "[{\"name\":\"属性名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      String fileName = "树表导出表头.xlsx";
      ResponseEntity exportHeaderResult = treeExcelService.treeExcelExportHeader(excelData, treeName, fileName);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeExcelService treeExcelService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String sortFormat = "{\"id\":\"desc\"}";
      String matcherFormat = "{\"id\":\"ignore\"}";
      String params = "{\"name\": \"流域名称\"}";
      String excelData =  "[{\"name\":\"流域名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      String treeName = "流域名称";
      String fileName = "流域名称.xlsx";

      ResponseEntity exportExcelResult = treeExcelService.exportExcel(appName, tableName, params, sortFormat, matcherFormat, excelData, treeName, fileName);
    }
}
java
@Slf4j
@Service
public class TestService {

  @Autowired
  private TreeExcelService treeExcelService;
   
  // 静态表名
  private final static String appName = "admin";
  private final static String tableName = "tableName";

  public void test() {
      String params = "{\"name\": \"流域名称\"}";
      String excelData =  "[{\"name\":\"流域名称\"},{\"defValue\":\"默认值\"},{\"fieldName\":\"字段名称\"}]";
      String treeName = "流域名称";
      Result importExcelResult = treeExcelService.importExcel(appName, tableName, file, params, excelData, treeName);
    }
}

汇总查询 ​

API调用 ​

数据中心（fine-base）

数据管理（fine-data）