openlayers mysql_OpenLayers學習筆記8——使用servlet從mysql獲取數據並標注

[

{

"schoolName": "城陽區第二實驗中學",

"schoolAddress": "山東省青島市城陽區禮陽路107號",

"schoolTel": "0532-81156666",

"schoolKind": "教育學校:中學",

"schoolLat": 36.28491,

"schoolLon": 120.40238

},

{

"schoolName": "小寨子幼兒園",

"schoolAddress": "山東省青島市城陽區 ",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.29791,

"schoolLon": 120.39172

},

{

"schoolName": "新太陽托管中心",

"schoolAddress": "山東省青島市市北區嘉興路11-2",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.10921,

"schoolLon": 120.35659

},

{

"schoolName": "金蘋果幼兒園(香江醫院西)",

"schoolAddress": "山東省青島市黃島區香江路311號(香江醫院西)",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 35.97422,

"schoolLon": 120.16204

},

{

"schoolName": "錦橋社區托輔中心",

"schoolAddress": "山東省青島市黃島區王家石橋村錦橋社區",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 35.87418,

"schoolLon": 120.00619

},

{

"schoolName": "藝星幼兒園",

"schoolAddress": "山東省青島市城陽區嶴東北路541",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.33419,

"schoolLon": 120.2701

},

{

"schoolName": "隱珠街道辦事處中心幼兒園",

"schoolAddress": "山東省青島市膠南市靈海路126號",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 35.89869,

"schoolLon": 120.0444

},

{

"schoolName": "慧諾托管家園",

"schoolAddress": "山東省青島市黃島區虹橋大街83-5",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 35.87653,

"schoolLon": 120.00338

},

{

"schoolName": "四方區尚志幼兒園",

"schoolAddress": "山東省青島市市北區尚志路4",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.11456,

"schoolLon": 120.35691

},

{

"schoolName": "寶貝之家親子園",

"schoolAddress": "山東省青島市嶗山區松嶺路58-1",

"schoolTel": "(0532)88891918,(0532)88893227",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.10406,

"schoolLon": 120.47963

},

{

"schoolName": "天真幼兒園(靈山衛街道辦事處人大工作辦公室北)",

"schoolAddress": "山東省青島市黃島區329省道(靈山衛街道辦事處人大工作辦公室北)",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 35.93806,

"schoolLon": 120.15021

},

{

"schoolName": "城陽區城陽街道皂戶幼兒園",

"schoolAddress": "山東省青島市城陽區正陽中路",

"schoolTel": " ",

"schoolKind": "教育學校:幼兒園",

"schoolLat": 36.30772,

"schoolLon": 120.35847

},

{

"schoolName": "膠南市王台鎮石梁小學",

"schoolAddress": "山東省青島市黃島區 ",

"schoolTel": "0532-83116752",

"schoolKind": "教育學校:小學",

"schoolLat": 36.07053,

"schoolLon": 120.03613

}

]

json解析可以采用json2.js也可以使用js的eval函數。這里采用后者，代碼如下，很簡單就不做解釋了。