Google Maps API 应用；读取xml文件，实现轨迹回放

ylzyd12345

浏览: 121175 次
性别:
来自: 江苏

最近访客更多访客>>

wzgadmin

fcoffee

wangzyabc

fufangshi

博主相关

博客

微博

相册

留言

关于我

博客专栏

: 玩懂Log，打开Andro...
浏览量：10509

文章分类

社区版块

存档分类

博客分类：

其他

XML Google 应用服务器 SQL Servlet

前台页面，两个功能一个是定位，一个是轨迹回放。定位的功能是实时访问数据库，每隔6秒访问一次，功能还没有完成，查询出来的数据不是实时更新的，模拟的时候是返回好几条数据，所以定位就会显示几个位置。不看也罢；轨迹回放则访问的是服务器上的XML文件，很好的实现了：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml">
    <head>
        <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
        <title>Google 地图 API 示例: GGeoXml KML 叠加层</title>
        <script src="http://ditu.google.cn/maps?file=api&amp;v=2&amp;key=ABQIAAAAzr2EBOXUKnm_jVnk0OJI7xSosDVG8KKPE1-m51RBrvYughuyMxQ-i1QfUnH94QxWIa6N4U6MouMmBA&hl=zh-CN" type="text/javascript">
        </script>
        <script type="text/javascript">
            
            var map;
            var geoXml;
            var status = "running";
            var TruckIcon = new GIcon(G_DEFAULT_ICON);
	        TruckIcon.image = "truck.png";
	        TruckIcon.iconSize = new GSize(32, 22);
	        markerOptions = {
	            icon: TruckIcon
	        };
            function initialize(){
                if (GBrowserIsCompatible()) {
                    map = new GMap2(document.getElementById("map_canvas"));
                    map.setCenter(new GLatLng(24.414333333333, 120.726366666667), 12);
                    map.addControl(new GMapTypeControl());
                    map.addControl(new GLargeMapControl());
                    map.enableScrollWheelZoom();
                }
            }
            
            // Stops and starts the tracking function
            function toggleStatus(){
                if (status == "stopped") {
                    status = "running";
                    document.getElementById("statusLink").value = "Running";
                }
                else {
                    status = "stopped";
                    document.getElementById("statusLink").value = "Stopped";
                }
            }
            
            // Refresh map function
            function refreshMap(map){
                if (status == "stopped") {
                    window.setTimeout(function(){
                        refreshMap(map)
                    }, 6000);
                    return;
                }
                var point;
                // AJAX XML Data Download and marker placement, straight 
                // from Google API documentation
                var request = GXmlHttp.create();
                request.open("POST", "http://localhost:8080/GPS/getdate", true);
                request.onreadystatechange = function(){
                    if (request.readyState == 4) {
						map.clearOverlays();
                        var xmlDoc = request.responseXML;
                        var markers = xmlDoc.documentElement.getElementsByTagName("mark");
                        for (var i = 0; i < markers.length; i++) {
                            point = new GLatLng(parseFloat(markers[i].getAttribute("lat")), parseFloat(markers[i].getAttribute("lng")));
                            var marker = new GMarker(point,markerOptions);
                            map.addOverlay(marker);
                        }
						var startPoint = new GLatLng(parseFloat(markers[0].getAttribute("lat")), parseFloat(markers[0].getAttribute("lng")));
						map.openInfoWindowHtml(startPoint,"Start Place");
						map.setCenter(point);
                    }
                }
                request.send(null);
                // Reloads map every 6 seconds    
                window.setTimeout(function(){
                    refreshMap(map)
                }, 6000);
            }
			
			function guiji(){
				var point;
                // AJAX XML Data Download and marker placement, straight 
                // from Google API documentation
                var request = GXmlHttp.create();
                request.open("POST", "http://localhost:8080/GPS/getdate?method='guiji'", true);
                request.onreadystatechange = function(){
                    if (request.readyState == 4) {
						map.clearOverlays();
                        var xmlDoc = request.responseXML;
                        var markers = xmlDoc.documentElement.getElementsByTagName("mark");
                        for (var i = 0; i < markers.length; i++) {
                            point = new GLatLng(parseFloat(markers[i].getAttribute("lat")), parseFloat(markers[i].getAttribute("lng")));
                            var marker = new GMarker(point,markerOptions);
                            map.addOverlay(marker);
                        }
						var startPoint = new GLatLng(parseFloat(markers[0].getAttribute("lat")), parseFloat(markers[0].getAttribute("lng")));
						map.openInfoWindowHtml(startPoint,"车辆开始的位置");
						map.setCenter(point);
                    }
                }
                request.send(null);
			}
        </script>
    </head>
    <body onload="initialize();">
        <b><a href="#" onclick="refreshMap(map)();">定位</a></b>:
		<input type="submit" value="开始" onclick="toggleStatus();"><input type="submit" value="结束" onclick="toggleStatus();"><input type="text" value="Running" id="statusLink" size="10">
        <br>
		<b><a href="#" onclick="guiji();">轨迹</a></b>
        <div id="map_canvas" style="width: 100%; height: 650px; float:left; border: 1px solid black;">
        </div>
    </body>
</html>

后台：

写连接mysql的配置文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/gmaptracker
user=root
password=root
characterEncoding=UTF-8

一个连接mysql的工具类。不知道写的对不对，感觉写的不好，有错误的地方请大虾们指出

package util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class JdbcMySql {
	static Properties props = null;

	private JdbcMySql() {
	}

	static {
		props = getProperties();
	}

	public static Connection getConn() {
		Connection conn = null;
		if (props != null) {
			// 读取出属性文件里面的内容
			String driver = props.getProperty("driver");
			String url = props.getProperty("url");
			String user = props.getProperty("user");
			String password = props.getProperty("password");
			String characterEncoding = props.getProperty("characterEncoding");
			try {
				Class.forName("com.mysql.jdbc.Driver");
				Class.forName(driver);// 加载驱动
			} catch (ClassNotFoundException e1) {
				System.out.println("驱动没有找到");
				e1.printStackTrace();
			}
			
			try {
				conn = DriverManager.getConnection(url + "?characterEncoding="
						+ characterEncoding, user, password);
			} catch (SQLException e) {
				System.out.println("建立连接出错");
				e.printStackTrace();
			}// 建立连接
		}
		return conn;
	}

	public static void free(ResultSet rs, Statement st, Connection conn) {
		try {

			if (rs != null)
				rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (st != null)
					st.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {

				try {
					if (conn != null)
						conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}

	}

	public static Properties getProperties() {
		Properties props = new Properties();
		InputStream is = null;
		try {
			is = JdbcMySql.class.getResourceAsStream("/jdbc_mysql.properties");
			props.load(is);
		} catch (Exception ex) {
			ex.printStackTrace();
			return null;
		} finally {
			if (is != null)
				try {
					is.close();
				} catch (IOException e) {
					e.printStackTrace();
				}
		}
		return props;
	}

}

读写XML文件工具类

package util;

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.SAXReader;
import org.dom4j.io.XMLWriter;

public class XMLUtil {
	public static Document getDocument() {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		String sql = "select * from gmaptracker";
		
		Document document = null;
		Element root = null;
        Element category = null;
        Element latElement = null;
        Element lngElement = null;
        double lat = 0.0;
        double lng = 0.0;
		
		try {
			conn = JdbcMySql.getConn();
			st = conn.createStatement();
			rs = st.executeQuery(sql);

			document = DocumentHelper.createDocument();   
	        //生成一个接点   
	        root = document.addElement("marks");
	        
	       /*
    			 * <?xml version="1.0" encoding="UTF-8"?>    
    				<marks>   
    				  	<mark id="xx" lat="xx" lng="xx"/>   
    				</marks> 
    			 */
			while (rs.next()) {
				category = root.addElement("mark");
				lat = rs.getDouble(4);
				latElement = category.addElement("lat");   
		        latElement.addText(Double.toString(lat));
				lng = rs.getDouble(5);
		        lngElement = category.addElement("lng");   
		        lngElement.addText(Double.toString(lng));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcMySql.free(rs, st, conn);
		}
		return document;
	}
	
	 /**  
     * 写入xml文件地址  
     * @param document 所属要写入的内容  
     * @param outFile 文件存放的地址  
     */  
    public static void writeDocument(Document document, String outFile){   
        try{   
            //读取文件   
            FileWriter fileWriter = new FileWriter(outFile);   
            //设置文件编码   
            OutputFormat xmlFormat = new OutputFormat();   
            xmlFormat.setEncoding("UTF-8");   
            //创建写文件方法   
            XMLWriter xmlWriter = new XMLWriter(fileWriter,xmlFormat);   
            //写入文件   
            xmlWriter.write(document);   
            //关闭   
            xmlWriter.close();   
        }catch(IOException e){   
            System.out.println("文件没有找到");   
            e.printStackTrace();   
        }   
    }
    public static Document readDocument(String outFile){
    	Document document = null;
        try{   
        	SAXReader reader = new SAXReader();   
            document = reader.read(new File(outFile));
        }catch (DocumentException e) {
			e.printStackTrace();
			System.out.println("文件读取出错");
		}
		return document;   
    }
}

一个servlet，相应前台ajax请求，返回xml数据。

package gps.demo;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.dom4j.Document;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;

import util.JdbcMySql;
import util.XMLUtil;

/**
 * Servlet implementation class Gps
 */
public class Gps extends HttpServlet {
	private static final long serialVersionUID = 1L;

	@Override
	public void init() throws ServletException {
		// TODO Auto-generated method stub
		super.init();
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doPost(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		String sql = "select * from gmaptracker";
		
		Document document = null;
		Element root = null;
        Element category = null;
        int id = 0;
        double lat = 0.0;
        double lng = 0.0;
        String carOwner = null;
		String method = request.getParameter("method");
        System.out.print(method);
        
        if(method.equals("guiji")) {
        	//测试，先在D盘写入车辆轨迹坐标
        	XMLUtil.writeDocument(XMLUtil.getDocument(), "D:\\a.xml");
        	//读取XML
        	document = XMLUtil.readDocument("D:\\a.xml");
        	response.setContentType("text/xml");
			response.getWriter().write(document.asXML());
        } else {

    		try {
    			conn = JdbcMySql.getConn();
    			st = conn.createStatement();
    			rs = st.executeQuery(sql);

    			document = DocumentHelper.createDocument();   
    	        //生成一个接点   
    	        root = document.addElement("marks");
    	        
    	        /*
    			 * <?xml version="1.0" encoding="UTF-8"?>    
    				<marks>   
    				  	<mark id="xx" lat="xx" lng="xx"/>   
    				</marks> 
    			 */
    			while (rs.next()) {
    				category = root.addElement("mark");
    				carOwner = rs.getString(3);
    				category.addAttribute("owner", carOwner);
    				id = rs.getInt(1);
    				category.addAttribute("id",Integer.toString(id));
    				lat = rs.getDouble(4);
    				category.addAttribute("lat", Double.toString(lat)); 
    				lng = rs.getDouble(5);
    		        category.addAttribute("lng", Double.toString(lng));  
    			}
    			System.out.println(document.asXML());
    			//这一句，必须加上
    			response.setContentType("text/xml");
    			response.getWriter().write(document.asXML());
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} finally {
    			JdbcMySql.free(rs, st, conn);
    		}
		}
        
	}
}

web.xml配置servlet

<servlet>
    <servlet-name>Gps</servlet-name>
    <servlet-class>gps.demo.Gps</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>Gps</servlet-name>
    <url-pattern>/getdate</url-pattern>
  </servlet-mapping>

附件内容：xml的的操作使用的dom4J，所以要导入包；前台页面中标注图片truck.png放在和html文件同一目录下；数据库表的sql语句。

gmaptracker.rar (283.7 KB)
下载次数: 316

5
顶

0
踩

分享到：

Eclipse中拷贝J2EE项目，发布到tomcat中名 ... | J2SE六大代码问题检验你（对于异常的处理） ...

2010-03-01 11:10
浏览 7315
评论(0)
分类:编程语言
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

博客专栏

文章分类

社区版块

存档分类

最新评论

Google Maps API 应用；读取xml文件，实现轨迹回放

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

博客专栏

文章分类

社区版块

存档分类

最新评论

Google Maps API 应用；读取xml文件，实现轨迹回放

评论

发表评论

相关推荐

聊聊信息差赚钱

简单判断编码解码对错

EF BB BF Unicode签名BOM(Byte Order Mark)

南京诚迈 待遇

sun.jnu.encoding与file.encoding

传业内多家游戏网站被黑 用户数据遭泄露（转）这次真的是地震了。

黑客公开CSDN网站数据库 600余万用户资料泄露 (转)---这个消息太令人震惊了！！！

南京诚迈公司面试

“皮之不存，毛将焉附”---看2030肢解中国-美国全球战略与中国危机（戴旭）后感

2010计划

最近访客更多访客>>

南京诚迈待遇

传业内多家游戏网站被黑用户数据遭泄露（转）这次真的是地震了。