java elasticsearch 存储查询

java elasticsearch 工具类，无需修改，直接就可以使用，存储，查询，修改，删除

squirrel-sql-snapshot-20200213_2231-standard.jar

SQuirrel SQL Client是一个用Java写的数据库客户端，用JDBC统一数据库访问接口以后，可以通过一个统一的用户界面来操作MySQL PostgreSQL MSSQL Oracle等等任何支持JDBC访问的数据库。使用起来非常方便。而且，SQuirrel SQL Client还是一个典型的Swing程序，也算是Swing的一个比较成功的应用了

全国城市乡镇sql脚本

CREATE TABLE `town_` ( `id_` varchar(36) NOT NULL, `city_code_` varchar(255) DEFAULT NULL, `ct_` datetime DEFAULT NULL, `is_delete_` int(11) DEFAULT NULL, `lat_` decimal(19,6) DEFAULT NULL, `lng_` decimal(19,6) DEFAULT NULL, `name_` varchar(255) DEFAULT NULL, `targer_name_` varchar(255) DEFAULT NULL, `show_index_` int(9) DEFAULT NULL, `cid_` varchar(255) DEFAULT '' COMMENT '公司id', `city_name_` char(255) DEFAULT NULL COMMENT '城市名称', `city_id_` char(36) DEFAULT NULL COMMENT '城市id', `ct_id_` varchar(36) DEFAULT NULL COMMENT '创建人id', `et_` datetime DEFAULT NULL COMMENT '修改时间', `et_id_` varchar(36) DEFAULT NULL COMMENT '修改人id', `g_c_id_` varchar(36) DEFAULT NULL COMMENT '公司ID', PRIMARY KEY (`id_`), KEY `NewIndex1` (`city_id_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of town_ -- ---------------------------- INSERT INTO `town_` VALUES ('00113ea047594f0cbc91a11abc37a0ba', '023', '2016-07-12 18:59:52', '1', '29.555236', '106.546967', '渝中', null, '100', '', '重庆市', '8a92c1c5-dec2-11e5-bcc3-00163e1c066c', null, null, null, null); INSERT INTO `town_` VALUES ('004c2e1a384c4b15ab3a70c05940fc8f', '020', '2016-12-22 13:43:39', '1', '22.747632', '113.502645', '横沥', null, null, '', '广州市', '87a7daf8-dec4-11e5-bcc3-00163e1c066c', null, null, null, null); INSERT INTO `town_` VALUES ('0187a9af37ee4169b4c09d11cde3aefc', '020', '2016-12-22 13:43:40', '1', '23.446661', '113.220176', '花都', null, null, '', '广州市', '87a7daf8-dec4-11e5-bcc3-00163e1c066c', null, null, null, null); INSERT INTO `town_` VALUES ('01b263a3053a4116b887bf060ce8658a', '0411', '2017-01-03 22:36:47', '1', '39.620006', '122.274257', '普兰店', null, null, '', '大连市', '86389da7-dec4-11e5-bcc3-00163e1c066c', null, null, null, null); INSERT INTO `town_` VALUES ('01e552d12230438e83404a886d879313', '', '2017-02-09 13:42:12', '1', '22.806493', '108.297234', '仙葫', null, null, '', '南宁市', 'fe12fb1f-ee89-11e6-ac77-00163e031edd', null, null, null, null); INSERT INTO `town_` VALUES ('034060663f254efeb46d73d5d19639b9', '0536', '2018-11-07 16:45:14', '1', null, null, '滨海新区', null, null, '', '潍坊市', CREATE TABLE `city_` ( `id_` varchar(36) NOT NULL, `city_code_` varchar(45) DEFAULT NULL, `content_` varchar(255) DEFAULT NULL, `ct_` datetime DEFAULT NULL, `is_delete_` smallint(9) DEFAULT NULL, `jian_` varchar(255) DEFAULT NULL, `lat_` decimal(9,6) DEFAULT NULL, `lng_` decimal(9,6) DEFAULT NULL, `name_` varchar(255) DEFAULT NULL, `province_id_` varchar(36) DEFAULT NULL, `quan_` varchar(255) DEFAULT NULL, `show_index_` smallint(11) DEFAULT NULL, `targer_name_` varchar(255) DEFAULT NULL, `city_name_` char(255) DEFAULT NULL COMMENT '省名称', `city_id_` char(36) DEFAULT NULL COMMENT '省id', `ct_id_` varchar(36) DEFAULT NULL COMMENT '创建人id', `et_` datetime DEFAULT NULL COMMENT '修改时间', `et_id_` varchar(36) DEFAULT NULL COMMENT '修改人id', `tbl_index_` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '下标', PRIMARY KEY (`id_`), UNIQUE KEY `tbl_index_` (`tbl_index_`), KEY `NewIndex1` (`city_code_`) ) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of city_ -- ---------------------------- INSERT INTO `city_` VALUES ('0563c58d-db26-11e7-be6b-00163e06854a', '0825', '', '2017-12-07 16:10:00', '1', null, '30.533872', '105.591373', '遂宁市', '56afdb02-dec0-11e5-bcc3-00163e1c066c', null, null, null, null, null, null, null, null, '253'); INSERT INTO `city_` VALUES ('14a8db26-73d8-11e8-bf8c-7cd30ae45df2', null, '8710', '2018-06-20 00:00:56', '1', null, '38.489977', '106.236771', '银川市', '56c6f68c-dec0-11e5-bcc3-00163e1c066c', null, null, null, null, null, null, null, null, '255'); INSERT INTO `city_` VALUES ('15f5e037250e44b69aadfc9ccba92e46', '0852', '系统导入', '2016-07-25 18:31:30', '1', 'zy', null, null, '遵义市', '56b1d412-dec0-11e5-bcc3-00163e1c066c', 'zunyi', null, null, null, null, null, null, null, '1'); INSERT INTO `city_` VALUES ('3430a6c9602b45c28e174a9da7cf9bfc', '0851', '系统导入', '2016-07-25 18:18:11', '1', 'gy', '26.622004', '106.685684', '贵阳市', '56b1d412-dec0-11e5-bcc3-00163e1c066c', 'giuyang', null, null, null, null, null, null, null, '2');

全国地铁经纬度坐标sql脚本

DROP TABLE IF EXISTS `subways_`; CREATE TABLE `subways_` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(255) DEFAULT NULL COMMENT '城市名称', `line` varchar(255) DEFAULT NULL COMMENT '地铁线路', `station` varchar(255) DEFAULT NULL COMMENT '地铁站', `lng` varchar(30) DEFAULT NULL COMMENT '经度', `lat` varchar(30) DEFAULT NULL COMMENT '纬度', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3523 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of subways_ -- ---------------------------- INSERT INTO `subways_` VALUES ('1', '上海市', '1号线', '富锦路', '121.43103', '31.398683'); INSERT INTO `subways_` VALUES ('2', '上海市', '1号线', '友谊西路', '121.434336', '31.387741');