-
Mongodb geolocation 위도 경도 javaspring project/mongodb 2020. 6. 4. 10:05
몽고db에 위도경도 정보를 넣고
인덱스 설정 2dsphere 하고
cmd에서 삽입
cmd에서 수정
java에서 수정하는 코드를 알아본다.
db.xx.insert({"name":"cafe2","location":{"type":"Point","coordinates":[127.0451548,37.5234878]}})
db.xx.createIndex( {"location": "2dsphere"} )
db.xx.updateOne({"name":"cafe2"},{$set:{"location.coordinates":[127,57]}})
String lonb = ServletRequestUtils.getStringParameter(request, "lon", "0");
String latb = ServletRequestUtils.getStringParameter(request, "lat", "0");
Number lon = Double.parseDouble(lonb);
Number lat = Double.parseDouble(latb);MongoOperations mo = (MongoOperations)mongoTemplate;
MongoCollection coll = mo.getCollection("testcollection");
BasicDBObject findquery = new BasicDBObject();findquery.put("name", "cafe2");
ArrayList coordinates = new ArrayList();
coordinates.add(lon.doubleValue());
coordinates.add(lat.doubleValue());
BasicDBObject geojson = new BasicDBObject("type", "Point");
geojson.append("coordinates",coordinates);
BasicDBObject set = new BasicDBObject("location", geojson);
BasicDBObject updateObject = new BasicDBObject();updateObject.put("$set", set);
coll.updateOne(findquery, updateObject);
'spring project > mongodb' 카테고리의 다른 글
Mongodb java insert geolocation query (0) 2020.06.05 Mongodb find query with java (0) 2020.06.05 mongodb 필드 값이 배열일때 접근 (0) 2020.05.04 mongodb + java push update query (0) 2020.05.04