Google Maps获取经纬度

前几天遇到一个需要详细经纬度的问题，在百度和谷歌之间寻找了很久，见到了各种各样的解决方案。
这些解决方案各有优点，但使用中还存在很多问题。我总结了其中一些的优点，与大家分享一下。
解决这个问题，首先自然是怎么查询一个地名的经纬度呢？Google提供了什么样的接口来查询呢？
开始在Gmaps中找了很久，没有见到相关的函数.后来想大批量的数据使用javascript的接口来实现也不是很的解决方案，于是收了一下看看能不能模仿javascript的请求连接去请求数据。
刚开始自然是百度了，可惜没有找到相关的信息，后来在Google上搜到了几条使用连接直接获取数据的，但是似乎得到相应的数据。后面经过几次尝试终于找到了有效的请求，废话就到这吧下面是我用Apache的一个开源项目，HttpClient 4.01事项的方式。

 

 

import java.io.IOException; import org.apache.http.client.ClientProtocolException; import org.apache.http.client.ResponseHandler; import org.apache.http.client.methods.HttpGet; import org.apache.http.impl.client.BasicResponseHandler; import org.apache.http.impl.client.DefaultHttpClient; public class SearchLnLt { private static String[] address={"皇记羊蝎子","四季恋餐厅","金色池塘自助餐","光谷华美达旋转餐厅","金汉斯","口味堂","楚灶王大酒店","巴犀烧烤"}; private DatabaseSession session = DatabaseSessionFactory.getDatabaseSession(); public static void main(String[] argv) { SearchLnLt search = new SearchLnLt(); for(int i=0;i<address.length;i++){ Location location = search.searchLocation(address[i]); System.out.println(location.getName()); } } public Location searchLocation(String name) { DefaultHttpClient httpClient = new DefaultHttpClient(); HttpGet httpGet = new HttpGet("http://maps.google.com/maps/geo?output=csv&q="+name); ResponseHandler<string> responseHandler = new BasicResponseHandler(); try { String response = httpClient.execute(httpGet, responseHandler); System.out.println(response); Location add = new Location(); String[] data = response.split(","); add.setName(name); add.setLat(data[2]); add.setLon(data[3]); String sql = "insert into restaurant(name,lat,lon) values('"+name+"','"+data[2]+"','"+data[3]+"')"; session.save(sql); return add; } catch (ClientProtocolException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } httpClient.getConnectionManager().shutdown(); return null; } }

 

 

 

其中几处由我自己写的关于数据库的类

 

Location.java package com.database; public class Location { private String Lat; private String Lon; private String name; public String getLat() { return Lat; } public void setLat(String lat) { Lat = lat; } public String getLon() { return Lon; } public void setLon(String lon) { Lon = lon; } public void setName(String name) { this.name = name; } public String getName() { return name; } } DatabaseSessionFactory.java package com.database; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DatabaseSessionFactory { private static DatabaseSession session; private static String className = "com.mysql.jdbc.Driver"; private static String username = "root"; private static String password = "111111"; private static String url = "jdbc:mysql://localhost:3306/cstart"; static{ try { Class.forName(className).newInstance(); Connection con = DriverManager.getConnection(url,username,password); DatabaseSession.setConnection(con); } catch (InstantiationException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public static DatabaseSession getDatabaseSession(){ if(session==null){ session = new DatabaseSession(); } return session; } } DatabaseSession.java package com.database; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DatabaseSession { private static Connection connection = null; public static void setConnection(Connection connection) { DatabaseSession.connection = connection; } public static Connection getConnection() { return connection; } public void save(String sql) { try { Statement st = connection.createStatement(); st.execute(sql); } catch (SQLException e) { e.printStackTrace(); } } public ResultSet find(String sql) { Statement st; ResultSet rs = null; try { st = connection.createStatement(); rs = st.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } return rs; } }