query_queryBySQL.html 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. <!--********************************************************************
  2. * Copyright© 2000 - 2021 SuperMap Software Co.Ltd. All rights reserved.
  3. *********************************************************************-->
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. <meta charset="utf-8">
  8. <title data-i18n="resources.title_queryBySQL"></title>
  9. <style type="text/css">
  10. body {
  11. margin: 0;
  12. overflow: hidden;
  13. background: #fff;
  14. width: 100%;
  15. height: 100%
  16. }
  17. #map {
  18. position: absolute;
  19. width: 100%;
  20. height: 100%;
  21. }
  22. #toolbar {
  23. position: absolute;
  24. top: 50px;
  25. right: 10px;
  26. text-align: center;
  27. z-index: 100;
  28. border-radius: 4px;
  29. }
  30. </style>
  31. </head>
  32. <body>
  33. <div id="toolbar" class="panel panel-primary">
  34. <div class='panel-heading'>
  35. <h5 class='panel-title text-center' data-i18n="resources.title_queryBySQL"></h5></div>
  36. <div class='panel-body content'>
  37. <input type="button" class="btn btn-default" data-i18n="[value]resources.text_query" onclick="queryBySQL()"/>&nbsp;
  38. <input type="button" class="btn btn-default" data-i18n="[value]resources.text_input_value_clear" onclick="clearFeatures()"/>
  39. </div>
  40. </div>
  41. <div id="map"></div>
  42. <script type="text/javascript" include="bootstrap,widgets.alert" src="../js/include-web.js"></script>
  43. <script type="text/javascript" exclude="iclient-classic" src="../../dist/classic/include-classic.js"></script>
  44. <script>
  45. var map, local, layer, vectorLayer,
  46. style = {
  47. strokeColor: "#304DBE",
  48. strokeWidth: 1,
  49. fillColor: "#304DBE",
  50. fillOpacity: "0.8"
  51. },
  52. host = window.isLocal ? window.server : "https://iserver.supermap.io",
  53. url = host + "/iserver/services/map-world/rest/maps/World";
  54. init();
  55. function init() {
  56. map = new SuperMap.Map("map", {
  57. controls: [
  58. new SuperMap.Control.ScaleLine(),
  59. new SuperMap.Control.Zoom(),
  60. new SuperMap.Control.Navigation({
  61. dragPanOptions: {
  62. enableKinetic: true
  63. }
  64. })]
  65. });
  66. map.addControl(new SuperMap.Control.LayerSwitcher(), new SuperMap.Pixel(42, 80));
  67. layer = new SuperMap.Layer.TiledDynamicRESTLayer("World", url, {
  68. transparent: true,
  69. cacheEnabled: true
  70. }, {maxResolution: "auto"});
  71. layer.events.on({"layerInitialized": addLayer});
  72. vectorLayer = new SuperMap.Layer.Vector("Vector Layer");
  73. }
  74. function addLayer() {
  75. map.addLayers([layer, vectorLayer]);
  76. map.setCenter(new SuperMap.LonLat(106.3, 37), 2);
  77. }
  78. function queryBySQL() {
  79. vectorLayer.removeAllFeatures();
  80. var queryParam, queryBySQLParams, queryBySQLService;
  81. queryParam = new SuperMap.REST.FilterParameter({
  82. name: "Countries@World.1",
  83. attributeFilter: "Pop_1994>1000000000 and SmArea>900"
  84. });
  85. queryBySQLParams = new SuperMap.REST.QueryBySQLParameters({
  86. queryParams: [queryParam]
  87. });
  88. queryBySQLService = new SuperMap.REST.QueryBySQLService(url, {
  89. eventListeners: {"processCompleted": processCompleted, "processFailed": processFailed}
  90. });
  91. queryBySQLService.processAsync(queryBySQLParams);
  92. }
  93. function processCompleted(queryEventArgs) {
  94. var i, j, feature,
  95. result = queryEventArgs.result;
  96. if (result && result.recordsets) {
  97. for (i = 0; i < result.recordsets.length; i++) {
  98. if (result.recordsets[i].features) {
  99. for (j = 0; j < result.recordsets[i].features.length; j++) {
  100. feature = result.recordsets[i].features[j];
  101. feature.style = style;
  102. vectorLayer.addFeatures(feature);
  103. }
  104. }
  105. }
  106. }
  107. }
  108. function processFailed(e) {
  109. widgets.alert.showAlert(e.error.errorMsg, false);
  110. }
  111. function clearFeatures() {
  112. //先清除上次的显示结果
  113. vectorLayer.removeAllFeatures();
  114. vectorLayer.refresh();
  115. }
  116. </script>
  117. </body>
  118. </html>