1、MySQL查询语句:
pointsArr
===
select l.gisbaidu
from smt_lamp l
2、控制层代码:
@RequestMapping(KEY_MAIN)
public String index(ModelMap mm, Model model) {
String sql = Md.getSql("location.pointsArr");//sql语句
@SuppressWarnings("rawtypes")
List<Map> list = Db.selectList(sql);
mm.put("points", JsonKit.toJson(list));//java的数据类型传到js中,需要转化为JSON格式
mm.put("code", CODE);
return BASE_PATH + "location.html";
}
3、前端:
<div id="allmap" style="width:100%; height:500px;"></div>
<script type="text/javascript" src="http://api.map.baidu.com/api?v=2.0&ak=U5IzhV77l7nd7qymfsXVK03sICNeTir2"></script>
<script typ