首页 / 浏览问题 / 组件GIS / 问题详情
超图FAQ:请问下iobject java,进行连接查询,怎么去设置返回被连接数据集中的字段
64,468EXP 2024年07月09日
请问下iobject java,进行连接查询,怎么去设置返回被连接数据集中的字段

1个回答

【解决办法】可以参考以下示例代码: Datasource d = workspace.getDatasources().get("geotest"); DatasetVector datasetVector = (DatasetVector)d.getDatasets().get("NewPoint"); JoinItems joinItems = new JoinItems(); JoinItem joinItem = new JoinItem(); joinItem.setJoinType(JoinType.LEFTJOIN); joinItem.setForeignTable("NewPoint_1"); joinItem.setName("myJoinItem"); joinItem.setJoinFilter("NewPoint.col=NewPoint_1.col"); joinItems.add(joinItem); QueryParameter queryParameter = new QueryParameter(); queryParameter.setCursorType(CursorType.STATIC); queryParameter.setJoinItems(joinItems); queryParameter.setResultFields(new String[]{"NewPoint_1.col as col_1","NewPoint.col"}); Recordset recordset = datasetVector.query(queryParameter);
64,468EXP 2024年07月09日
热门文章
关注我们
...