1.下图是geoserver发布的sqlview 详情页面,查询gis_river_sample_p表中与参数pts相交的要素
2.sqlview发布好后,还是用http请求访问,以下是相关的代码
var url = "http://localhost:6080/geoserver/webgis/wfs";
//注意此处单引号用转译
var viewparamsStr = "pts:\'POLYGON((12611548.9609427 2609424.9069851,12611548.9609427 2619275.28660001,12624709.6684682 2619275.28660001,12624709.6684682 2609424.9069851,12611548.9609427 2609424.9069851))\'"
viewparamsStr = viewparamsStr.replace(/\,/g,"\\,");
$.ajax({
type: 'post',
url: url,
async: false,
data:{
service:"WFS",
version:"1.0.0",
request:"GetFeature",
typeName:"webgis:intersects",
maxFeatures:1000,
outputFormat:"application/json",
viewparams:viewparamsStr
},
success: function(result) {
//result为查询结果
console.log(result);
},
error: function() {
console.log('获取图层url执行失败');
}
})