使用Postman对ElasticSearch数据库进行增删改查

打开Postma

添加索引

PUT http://192.168.203.132:9200/school

{
	"settings":{
		"number_of_shards":3,
		"number_of_replicas":1
	},
	"mappings":{
		"student":{
			"properties":{
				"stuName":{"type":"keyword"},
				"age":{"type":"integer"},
				"resume":{"type":"text","analyzer":"ik_smart"},
				"tuition":{"type":"scaled_float","scaling_factor":100},
				"hobbies":{"type":"keyword"},
				"address":{
					"properties":{
						"province":{"type":"keyword"},
						"city":{"type":"keyword"},
						"district":{"type":"keyword"}
					}
				}
			}
		}
	}
}

 

创建索引前

点击send就是发送创建索引的请求，下面会显示

{
    "acknowledged": true,
    "shards_acknowledged": true,
    "index": "school"
}

 

 

这就是创建成功的意思，这样就会多出一个叫school的索引

 

新增数据

POST http://192.168.203.132:9200/school/student/1 再按send发送请求
为索引加一个student的类型，在该类下加一个条d是1的数据

{
	"stuName":"张三",
	"age":18,
	"resume":"我是一个喜欢冒险的人，从小到大，阅人无数",
	"tutition":26800.00,
	"hobbies":["太极","游泳"],
	"address":{
		"province":"江苏",
		"city":"南京",
		"district":"雨花"
	}
}

 

可以查询到添加的数据

删除索引下全部数据

DELETE http://192.168.203.132:9200/school/student/1

删除索引下某一条数据

Q：postman删除某一索引下dataDt为20190930的数据

url:地址：9200/索引(_index)/类型（_type）/_delete_by_query

请求方式：post

请求体：{

    "query": {

             "match": {

                 "dataDt": "20190930"

        }

    }

}

修改数据

POST http://192.168.203.132:9200/school/student/1/_update

{
	"doc":{
		"tutition":16666.00
	}
}

 

具体操作，和上面增加类似，不过把请求方式换成post

参看结果发现修改成功

查询

根据ID查询

GET http://192.168.203.132:9200/school/student/1