传统数据库索引
存储用户登入字段主要包括 userId，lat，lng。分别代表用户 ID、最近一次 check-in 的经度、纬度。
lat/lng 建立复合索引。
然后通过手机的定位，得到自己的位置，比如记为 myLat，myLng。
代码如下，先做一个计算，算出 1km 所对应的经纬度范围：
double range = 180 / Math.PI * 1 / 6372.797; //里面的 1 就代表搜索 1km 之内，单位km
double lngR = range / Math.cos(myLat * Math.PI / 180.0);
double maxLat = myLat range;
double minLat = myLat – range;
double maxLng = myLng lngR;
double minLng = myLng – lngR;
然后执行 SQL ：
SELECT xxxx FROM checkinTable WHERE ((lat BETWEEN ? AND ?) AND (lng BETWEEN ? AND ?)) LIMIT 100
这四个问号，分别代入变量
minLat、maxLat、minLng、maxLng
然后就可以查询得到结果
但是，这样得到的结果不是有序的。
如果要排序，在程序代码（比如 app 客户端）执行。
不建议在 SQL 层上执行，因为上述的那个 SQL 是可以用到索引进行查询的，一旦引入排序后，索引就无法发挥作用，从而会影响效率。
资源文件列表
nearbydemo-master/.gitignore , 474
nearbydemo-master/GETDISTANCE.sql , 648
nearbydemo-master/LICENSE , 11515
nearbydemo-master/LocationDemo/.classpath , 356
nearbydemo-master/LocationDemo/.project , 815
nearbydemo-master/LocationDemo/.settings/org.eclipse.jdt.core.prefs , 173
nearbydemo-master/LocationDemo/AndroidManifest.xml , 1359
nearbydemo-master/LocationDemo/ic_launcher-web.png , 51394
nearbydemo-master/LocationDemo/proguard-project.txt , 781
nearbydemo-master/LocationDemo/project.properties , 563
nearbydemo-master/LocationDemo/res/drawable-hdpi/ic_launcher.png , 7658
nearbydemo-master/LocationDemo/res/drawable-mdpi/ic_launcher.png , 3777
nearbydemo-master/LocationDemo/res/drawable-xhdpi/ic_launcher.png , 12516
nearbydemo-master/LocationDemo/res/drawable-xxhdpi/ic_launcher.png , 24777
nearbydemo-master/LocationDemo/res/layout/gps.xml , 618
nearbydemo-master/LocationDemo/res/layout/main.xml , 1218
nearbydemo-master/LocationDemo/res/layout/network.xml , 621
nearbydemo-master/LocationDemo/res/layout/telepony.xml , 621
nearbydemo-master/LocationDemo/res/menu/main.xml , 253
nearbydemo-master/LocationDemo/res/values-sw600dp/dimens.xml , 195
nearbydemo-master/LocationDemo/res/values-sw720dp-land/dimens.xml , 268
nearbydemo-master/LocationDemo/res/values-v11/styles.xml , 323
nearbydemo-master/LocationDemo/res/values-v14/styles.xml , 380
nearbydemo-master/LocationDemo/res/values/dimens.xml , 212
nearbydemo-master/LocationDemo/res/values/strings.xml , 221
nearbydemo-master/LocationDemo/res/values/styles.xml , 679
nearbydemo-master/LocationDemo/src/com/andieguoe/locationdemo/GpsActivity.java , 3514
nearbydemo-master/LocationDemo/src/com/andieguoe/locationdemo/MainActivity.java , 981
nearbydemo-master/LocationDemo/src/com/andieguoe/locationdemo/NetWorkActivity.java , 3766
nearbydemo-master/LocationDemo/src/com/andieguoe/locationdemo/TelephonyActivity.java , 8729
nearbydemo-master/LocationJDBC/.classpath , 449
nearbydemo-master/LocationJDBC/.project , 371
nearbydemo-master/LocationJDBC/.settings/org.eclipse.jdt.core.prefs , 587
nearbydemo-master/LocationJDBC/src/com/andieguo/location/JDBCInsertGPS.java , 5575
nearbydemo-master/LocationJDBC/src/com/andieguo/location/JDBC_Test.java , 2716
nearbydemo-master/LocationJDBC/src/com/andieguo/location/Record.java , 709
nearbydemo-master/NearByDemo/.classpath , 466
nearbydemo-master/NearByDemo/.project , 813
nearbydemo-master/NearByDemo/.settings/org.eclipse.core.resources.prefs , 55
nearbydemo-master/NearByDemo/.settings/org.eclipse.jdt.core.prefs , 173
nearbydemo-master/NearByDemo/AndroidManifest.xml , 2965
nearbydemo-master/NearByDemo/ic_launcher-web.png , 51394
nearbydemo-master/NearByDemo/libs/armeabi/liblocSDK4b.so , 35032
nearbydemo-master/NearByDemo/proguard-project.txt , 781
nearbydemo-master/NearByDemo/project.properties , 563
nearbydemo-master/NearByDemo/res/drawable-hdpi/ic_action_submit.png , 1452
nearbydemo-master/NearByDemo/res/drawable-hdpi/ic_launcher.png , 7658
nearbydemo-master/NearByDemo/res/drawable-mdpi/ic_launcher.png , 3777
nearbydemo-master/NearByDemo/res/drawable-xhdpi/ic_launcher.png , 12516
nearbydemo-master/NearByDemo/res/drawable-xxhdpi/ic_launcher.png , 24777
nearbydemo-master/NearByDemo/res/layout/activity_login.xml , 1020
nearbydemo-master/NearByDemo/res/layout/activity_main.xml , 594
nearbydemo-master/NearByDemo/res/layout/activity_main_list_item.xml , 2044
nearbydemo-master/NearByDemo/res/menu/main.xml , 255
nearbydemo-master/NearByDemo/res/menu/submit.xml , 296
nearbydemo-master/NearByDemo/res/values-sw600dp/dimens.xml , 196
nearbydemo-master/NearByDemo/res/values-sw720dp-land/dimens.xml , 269
nearbydemo-master/NearByDemo/res/values-v11/styles.xml , 324
nearbydemo-master/NearByDemo/res/values-v14/styles.xml , 381
nearbydemo-master/NearByDemo/res/values/dimens.xml , 213
nearbydemo-master/NearByDemo/res/values/strings.xml , 312
nearbydemo-master/NearByDemo/res/values/styles.xml , 680
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/BitmapLruCache.java , 956
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/GsonRequest.java , 2141
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/LoginActivity.java , 3141
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/MainActivity.java , 7370
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/MyListAdapter.java , 2188
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/message/NearbyInfo.java , 1381
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/message/NearbyInfoResponse.java , 323
nearbydemo-master/NearByDemo/src/com/loveplusplus/demo/nearby/util/PhoneUtil.java , 378
nearbydemo-master/NearbyServerDemo/.classpath , 735
nearbydemo-master/NearbyServerDemo/.mymetadata , 314
nearbydemo-master/NearbyServerDemo/.project , 1701
nearbydemo-master/NearbyServerDemo/.settings/.jsdtscope , 488
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.core.resources.prefs , 85
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.jdt.core.prefs , 387
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.wst.common.component , 477
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.wst.common.project.facet.core.xml , 245
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.wst.jsdt.ui.superType.container , 49
nearbydemo-master/NearbyServerDemo/.settings/org.eclipse.wst.jsdt.ui.superType.name , 6
nearbydemo-master/NearbyServerDemo/WebRoot/META-INF/MANIFEST.MF , 36
nearbydemo-master/NearbyServerDemo/WebRoot/WEB-INF/classes/.gitignore , 5
nearbydemo-master/NearbyServerDemo/WebRoot/WEB-INF/web.xml , 1231
nearbydemo-master/NearbyServerDemo/WebRoot/index.jsp , 780
nearbydemo-master/NearbyServerDemo/WebRoot/query.jsp , 1218
nearbydemo-master/NearbyServerDemo/db/nearby.sql , 2147
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/bean/GPS.java , 1141
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/bean/UserInfo.java , 915
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/dao/GpsDao.java , 6089
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/dao/UserDao.java , 1865
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/message/NearbyInfo.java , 1679
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/message/NearbyInfoResponse.java , 314
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/message/UserResponse.java , 380
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/service/Service.java , 1722
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/servlet/NearbyServlet.java , 3467
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/servlet/QueryServlet.java , 1938
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/servlet/UserServlet.java , 2280
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/test/GpsServiceTest.java , 744
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/util/DBUtil.java , 1769
nearbydemo-master/NearbyServerDemo/src/com/andieguo/nearby/util/GPSUtil.java , 4289
nearbydemo-master/README.md , 196
nearbydemo-master/ZonesionLocation/.classpath , 356
nearbydemo-master/ZonesionLocation/.project , 819
nearbydemo-master/ZonesionLocation/.settings/org.eclipse.jdt.core.prefs , 173
nearbydemo-master/ZonesionLocation/AndroidManifest.xml , 2843
nearbydemo-master/ZonesionLocation/ic_launcher-web.png , 51394
nearbydemo-master/ZonesionLocation/libs/armeabi/liblocSDK4b.so , 35032
nearbydemo-master/ZonesionLocation/proguard-project.txt , 781
nearbydemo-master/ZonesionLocation/project.properties , 563
nearbydemo-master/ZonesionLocation/res/drawable-hdpi/ic_launcher.png , 7658
nearbydemo-master/ZonesionLocation/res/drawable-mdpi/ic_launcher.png , 3777
nearbydemo-master/ZonesionLocation/res/drawable-xhdpi/ic_launcher.png , 12516
nearbydemo-master/ZonesionLocation/res/drawable-xxhdpi/ic_launcher.png , 24777
nearbydemo-master/ZonesionLocation/res/layout/main.xml , 888
nearbydemo-master/ZonesionLocation/res/menu/main.xml , 253
nearbydemo-master/ZonesionLocation/res/values-sw600dp/dimens.xml , 195
nearbydemo-master/ZonesionLocation/res/values-sw720dp-land/dimens.xml , 268
nearbydemo-master/ZonesionLocation/res/values-v11/styles.xml , 323
nearbydemo-master/ZonesionLocation/res/values-v14/styles.xml , 380
nearbydemo-master/ZonesionLocation/res/values/dimens.xml , 212
nearbydemo-master/ZonesionLocation/res/values/strings.xml , 223
nearbydemo-master/ZonesionLocation/res/values/styles.xml , 679
nearbydemo-master/ZonesionLocation/src/com/andieguo/loaction/MainActivity.java , 1650
nearbydemo-master/ZonesionLocation/src/com/andieguo/loaction/ZApplication.java , 2830
nearbydemo-master/comprise_index.mysql , 553
nearbydemo-master/geohash.sql , 9193
nearbydemo-master/nearby2014-5-16.sql , 71762
nearbydemo-master/寻找附近的人ppt.txt , 1120
nearbydemo-master/计算矩形内的用户.txt , 903
nearbydemo-master/附近的人.pdf , 948647
nearbydemo-master/附近的人.ppt , 1702400