第一次写博客 如有不对或者有更好的想法 希望大家多提意见。 后端Java框架 springboot 数据库 postgresql
@Override
public List pipesdataselect(PipAnalysisModel pipAnalysisModel) {
ArrayList arrayList = new ArrayList();
//换取别名
String subclass = pipAnalysisModel.getSubclass();
ArrayList<Map> realsubclass = mapdataStatisticsMapper.getDataSet(subclass);
Workspace workspace = new Workspace();
//数据连接信息
DatasourceConnectionInfo datasourceconnection = connectionInfo();
// 打开数据源
Datasource datasource = workspace.getDatasources().open(datasourceconnection);
Datasets datasets = datasource.getDatasets();
Map rsc = realsubclass.get(0);
//获取对应的数据集名称
String rsc1 = rsc.get("tablename").toString().substring(0, rsc.get("tablename").toString().lastIndexOf("@"));
//获取管网线的数据集
DatasetVector sourceVector = (DatasetVector) datasets.get(rsc1);
//管网点数据集
DatasetVector datasetVector = sourceVector.getChildDataset();
QueryParameter parameterLine = new QueryParameter();
QueryParameter parameterNode = new QueryParameter();
parameterLine.setAttributeFilter("smid = " + pipAnalysisModel.getSmid());
parameterLine.setCursorType(CursorType.STATIC);
//获取管段信息
ArrayList arrayList2 = getLineMessage1(parameterLine, parameterNode, sourceVector, datasetVector,