正文

ArcGIS Javascript查询数据库并添加到地图上

IP云
IP云V管理员/4 阅读
06/24
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

将数据存放到数据库中，动态的调取比较灵活，数据变动后不需要改变图层的属性表。

此处采用的方法是通过jquery查询数据库，并将数据库的结果生产json串返回给js，在js中动态解析json串增加点至地图上

1、jquery调取查询并处理json

var data = [];
function getData(vipstatus){
data=[];//清空数据列表
$.get('getVIPStatus.jsp',{vipstatus:vipstatus},function(result){
//alert(result);
var obj = JSON.parse(result);//将传递过来的json串转换成json对象
$.each(obj, function(index){
data.push(this);
});
displayPoints(data);//加载点到地图上，参见另外一篇文章
});
}

说明6-9行需要对返回的json传进行一个处理，因为传过来的数据格式为

{
"id25" : {
"XMJSNR" : "30万千瓦",
"ZRDW" : "xx市政府",
"XMMC" : "海上风电场H2",
"PROJECT_ID" : "ddafb1a4-668a-4b0c-85f0-081d90778e82",
"LONGITUDE" : "125.22222",
"LATITUDE" : "33.305264"
},
"id24" : {
"XMJSNR" : "年产海洋生物营养保健品系列2万吨、抗癌系列新药1万吨",
"ZRDW" : "xx市政府",
"XMMC" : "海洋生物营养保健品、抗癌新药项目",
"PROJECT_ID" : "d26da381-e7ca-4ab7-8c9c-d09c2b242c27",
"LONGITUDE" : "124.55555",
"LATITUDE" : "33.30223"
}
}

而实际需要的是个json数组，如下：（此处应该可以改进，需要继续优化）

[{"name":"name1","x":"x1","y":"y1","img":"img1","content":"content1"}...]

2、getVIPStatus.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="com.marost.tool.*,java.sql.*" %>
<%@ page import="java.util.Map,java.util.HashMap" %>
<%@ page import="org.json.JSONException,org.json.JSONObject" %>
<%
JDBConnection connection = new JDBConnection();
String vipstatus = Chinese.toChinese(request.getParameter("vipstatus"));
//System.out.println(vipname);
JSONObject jsonObj = new JSONObject(); String sql = "SELECT " +
"T_PROJECT_INFO.PROJECT_ID," +
"T_PROJECT_INFO.XMMC," +
"T_PROJECT_LOCATION.LONGITUDE,"+
"T_PROJECT_LOCATION.LATITUDE," +
"T_PROJECT_INFO.XMJSNR," +
"T_PROJECT_INFO.ZRDW " +
"FROM T_PROJECT_INFO ,T_PROJECT_LOCATION " +
"WHERE T_PROJECT_INFO.XMZT = (select code from t_code where code_name='"+vipstatus+"' and SECTION_NAME='项目状态') " +
"AND T_PROJECT_INFO.PROJECT_ID = T_PROJECT_LOCATION.PROJECT_ID";
System.out.println(sql);
try {
ResultSet rs = connection.executeQuery(sql);
while (rs.next()) {
Map <String, String> ingredients = new HashMap <String, String>();
ingredients.put("PROJECT_ID", rs.getString(1));
ingredients.put("name", rs.getString(2));
ingredients.put("x", rs.getString(3));
ingredients.put("y", rs.getString(4));
ingredients.put("XMJSNR", rs.getString(5));
ingredients.put("ZRDW", rs.getString(6));
ingredients.put("img","images/map_pin_fill_20.png");
try {
jsonObj.put("id"+rs.getRow(), ingredients);
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//System.out.print(deptno+"\t"+dname+"\t"+loc);
//System.out.println(rs.getRow());
}
//System.out.println(jsonObj);
} catch (SQLException e) {
e.printStackTrace();
}
connection.closeConnection();
response.getWriter().print(jsonObj);
%>

说明：生成json时用到org.json.jar