MongoDB 创建地图索引及根据位置坐标查询地点小例子
1:MongoDB 的安装
2:创建地图索引:
db.shop.ensureIndex( { loc : "2dsphere" } )
db.shop.ensureIndex( { loc : "2d" } )
1.2D索引,用于存储和查找平面上的点。
2.2Dsphere索引,用于存储和查找球面上的点。
3:spring-mongo的配置:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mongo="http://www.springframework.org/schema/data/mongo"
xsi:schemaLocation="http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/data/mongo
http://www.springframework.org/schema/data/mongo/spring-mongo-1.10.2.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">
<context:component-scan base-package="com.binxm.dao"></context:component-scan>
<context:property-placeholder location="classpath:properties/mongodb.properties" />
<mongo:mongo-client id="mongo" replica-set="${mongo.hostport}">
<mongo:client-options connections-per-host="${mongo.connectionsPerHost}"
threads-allowed-to-block-for-connection-multiplier="${mongo.threadsAllowedToBlockForConnectionMultiplier}"
connect-timeout="${mongo.connectTimeout}"
max-wait-time="${mongo.maxWaitTime}"
socket-keep-alive="${mongo.socketKeepAlive}"
socket-timeout="${mongo.socketTimeout}" />
</mongo:mongo-client>
<mongo:db-factory dbname="database" mongo-ref="mongo" />
<bean id="mongoTemplate" class="org.springframework.data.mongodb.core.MongoTemplate">
<constructor-arg ref="mongo" />
<constructor-arg name="databaseName" value="${mongo.databaseName}" />
</bean>
</beans>
普通的增删改查操作
package com.binxm.dao.impl
import com.binxm.dao.MoUserDao
import com.binxm.pogo.MoUser
import org.springframework.beans.factory.annotation.Autowired
import org.springframework.data.mongodb.core.MongoTemplate
import org.springframework.data.mongodb.core.query.Criteria
import org.springframework.data.mongodb.core.query.Query
import org.springframework.stereotype.Repository
@Repository
public class MoUserDaoImpl implements MoUserDao{
@Autowired
private MongoTemplate mongoTemplate
@Override
public MoUser getUserById(String id) {
Query query = new Query()
//查找
//mongoTemplate.findOne(new Query(Criteria.where("onumber").is("002").and("cname").is("zcy1")),MoUser.class)
//mongoTemplate.findOne(new Query(new Criteria().orOperator(Criteria.where("onumber").is("002"),Criteria.where("cname").is("zc"))),MoUser.class)
//修改
//mongoTemplate.upsert(new Query(Criteria.where("dfs").is("sss")), Update.update("",""),MoUser.class)
//mongoTemplate.updateFirst(new Query(Criteria.where("dfs").is("sss")), Update.update("",""),MoUser.class)
//添加
mongoTemplate.insert(MoUser.class)
mongoTemplate.save(MoUser.class)
//删除
//mongoTemplate.remove(MoUser.class)
query.addCriteria(new Criteria("_id").is(id))
MoUser one = this.mongoTemplate.findOne(query, MoUser.class)
return one
}
}
根据位置坐标查询相关地点信息
package com.binxm.dao.impl;
import com.binxm.dao.ShopDao;
import com.mongodb.AggregationOptions;
import com.mongodb.BasicDBObject;
import com.mongodb.Cursor;
import com.mongodb.DBObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.stereotype.Repository;
import java.util.*;
/**
* Created by li on 2017/9/24.
*/
@Repository
public class ShopDaoImpl implements ShopDao{
@Autowired
private MongoTemplate mongoTemplate;
@Override
public List<DBObject> getShoppingsWithCoordinate(double lon, double lat,double maxDistance) {
List<DBObject> pipeLine = new ArrayList<>();
BasicDBObject aggregate = new BasicDBObject("$geoNear",
new BasicDBObject("near",new BasicDBObject("type","Point").append("coordinates",new double[]{lon, lat}))
.append("distanceField","dist.calculated")
.append("query", new BasicDBObject())
.append("num", 5)
.append("maxDistance", maxDistance)
.append("spherical",true)
);
pipeLine.add(aggregate);
Cursor cursor=mongoTemplate.getCollection("shop").aggregate(pipeLine, AggregationOptions.builder().build());
List<DBObject> list = new LinkedList<>();
while (cursor.hasNext()) {
list.add(cursor.next());
}
return list;
}
}