<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:mx="library://ns.adobe.com/flex/mx"
xmlns:esri="http://www.esri.com/2008/ags"
xmlns:s="library://ns.adobe.com/flex/spark"
pageTitle="Query Task (without a map)">
<!--
This sample shows how to query the server and displaying
the result in a datagrid.
The query is sent using the execute() method on a QueryTask.
This sample sets up a QueryTask (what layer on what server to query).
When the user clicks the "Get Details" button, a Query is sent with
the user-provided text to search for.
Meanwhile a DataGrid has been created which listens for the results
(using executeLastResult) from the querytask.
-->
<s:layout>
<s:VerticalLayout horizontalAlign="center" paddingTop="25"/>
</s:layout>
<fx:Declarations>
<esri:QueryTask id="queryTask"
url="http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer/5"
useAMF="false"/>
<esri:Query id="query"
outFields="[STATE_NAME,STATE_FIPS,SUB_REGION,STATE_ABBR,POP2000,POP2007]"
returnGeometry="false"
text="{stateName.text}"/>
</fx:Declarations>
<s:Panel title="Using Query tasks without maps">
<s:layout>
<s:VerticalLayout/>
</s:layout>
<s:HGroup verticalAlign="middle">
<s:Label text="US state name: "/>
<s:TextInput id="stateName" text="Carolina"/>
<s:Button click="queryTask.execute(query);" label="Get Details"/>
</s:HGroup>
<mx:DataGrid id="resultsGrid"
dataProvider="{queryTask.executeLastResult.attributes}"
visible="{queryTask.executeLastResult != null}">
<mx:columns>
<mx:DataGridColumn dataField="STATE_NAME" headerText="State Name"/>
<mx:DataGridColumn dataField="SUB_REGION" headerText="Region"/>
<mx:DataGridColumn dataField="STATE_FIPS" headerText="FIPS"/>
<mx:DataGridColumn dataField="STATE_ABBR" headerText="Abbreviation"/>
<mx:DataGridColumn dataField="POP2000" headerText="Population 2000"/>
<mx:DataGridColumn dataField="POP2007" headerText="Population 2007"/>
</mx:columns>
</mx:DataGrid>
</s:Panel>
</s:Application>
注：Query里面的属性text真正的查询条件是,featuryLayer里的Display field = '%text%'
- 大小: 6.9 KB
分享到：
相关推荐
List<MyObject> result = runner.query(sql, handler, 123); // 123是参数值 // 处理查询结果 for (MyObject obj : result) { System.out.println(obj); } ``` 批量操作也是QueryRunner的一个强项，例如批量插入...
$result = $conn->query($sql); $data = array(); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $data[] = $row; } } else { echo "0 结果"; } $conn->close(); echo json_encode($...
### 数据分析 Power Query Formula #### 一、引言与概述 在数据分析领域，Microsoft Power Query 是一个非常重要的工具，它能够帮助用户从多种数据源获取并整合数据，从而为更深层次的数据分析提供基础。Power ...
(c) typing a syntactically correct SQL query that uses column and table names similar to the correct column and table names in a database (d) writing an English description of the data that the user...
query_result = db2table.query(connection, "SELECT * FROM my_table") # 将查询结果转换为DataFrame df = query_result.to_dataframe() # 现在你可以对df进行各种数据分析操作 ``` db2table库可能还提供了其他...
If the table is a heap (in other words, it has no clustered index), the bookmark is a RID, which is an actual row locator in the form File#:Page#:Slot#. Finding Rows with a NC Index on a Heap ...
var query = from entity in context.YourEntityType where entity.PartitionKey == "partitionValue" && entity.RowKey == "rowValue" select entity; var result = query.Execute().ToList(); ``` 以上代码...
There is one large table per query. All tables are small, except for one. A query result is significantly smaller than the source data. In other words, data is filtered or aggregated, so the result ...
// Now try to execute the query and display the results in a table Statement statement = null; // An object to execute the query try { // Create a statement to use statement = db....
$query = "SELECT * FROM $table WHERE session='$session' AND product='$product' "; $result = mysql_query($query); if(!$result) { return 0; } $numRows = mysql_num_rows($result); if($...
查询HyperLEDA（query.hyperleda） 从HyperLEDA Web数据访问服务查询（注意：... query_object ( 'UGC12591' , properties = 'all' )>> > print ( result_table ) # an astropy.table.Table pgc objname objtype ... c
List, Object>> result = query.getResultList(); // ... } ``` 7. Java中使用Query语言动态拼接SQL的注意事项 在使用Query语言动态拼接SQL时，需要注意以下几点： * 安全性：Query语言可以防止SQL注入攻击，但...
-Now result parameter detection in UniConnection.ExecSQL is similar to the one in ODAC -Bug with connection establishing if the client has negative half-hour time zone is fixed -Bug with transactions ...
Query<Table2> query = session.createQuery(hql, Table2.class); query.setParameter("value", someValue); List<Table2> table2List = query.getResultList(); // 处理Table2列表 for (Table2 table2 : table2...
$result = $conn->query($sql); if ($result->num_rows > 0) { // 输出数据 while($row = $result->fetch_assoc()) { echo "<tr><td>" . $row["column1"] . "</td><td>" . $row["column2"] . "</td></tr>"; } }...
$result = mysqli_query($connection, $query); $data = array(); while ($row = mysqli_fetch_array($result)) { $data[] = $row; } $response = array( 'total' => $totalRows, // 总行数 'rows' => $data // ...
result["description"] = query.value(2).toString(); result["min"] = query.value(3).toInt(); result["max"] = query.value(4).toInt(); } } else { qCritical() ; } return result; } ``` 这些方法允许...
In the file Rel-ops.txt, list which relational operations you used, from among the select/project/join operations, in order to perform this query. Explain the role of each operation in your query. 4...
Use data preview ofr analysing of query result. GPS Visualiser -Visualise points, polygons, and lines on map. Use Open Street Map, Goole Maps, Bing maps and more than 50 other popular map providers....