API FOR REST
2016-07-26 本文已影响0人
秦淮河的风
1. 海警
1.1. 查询海警信息记录
URL：
http://127.0.0.1:8096/haijing/
Request Type：
get
Example：
输入
.GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
海警查询输入
输出
{
"flag": 0,
"data": [
{
"id": 1,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"shipno": "No.55243852",
"cdma": "18950826997",
"inmc": "INMC.07026",
"speed": 18,
"heading": 258
}
]
}
海警查询输出
1.2. 批量插入海警信息记录
URL：
http://127.0.0.1:8096/haijing/create/
Request Type：
post
Example：
输入
POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[
{
"latitude": 128.123, //纬度 DECIMAL(20,16)
"longitude": 32.001, //经度 DECIMAL(20,16)
"updated": "2016-07-24 18:00:09", //更新时间 DATETIME
"status": 0, //不需要关注，可选
"shipno": "No.55243852", //船只编号 VARCHAR(50)
"cdma": "18950826997",//CDMA编号 VARCHAR(20)
"inmc": "INMC.07026", //INMC编号 VARCHAR(50)
"speed": 18,//航速 DECIMAL(8,4)
"heading": 258//航向 DECIMAL(8,4)
}
]
海警批量插入输入
输出
{
"flag": 0,
"data": [
{
"id": 2,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"shipno": "No.55243852",
"cdma": "18950826997",
"inmc": "INMC.07026",
"speed": 18,
"heading": 258
}
]
}
海警批量插入输出
1.3. 分页查询海警信息记录
URL：
http://127.0.0.1:8096/haijing/page?pn=1&ps=3
Request Type：
get
Example：
输入
.GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
海警分页查询输入
输出
{
"flag": 0,
"data": {
"content": [
{
"id": 4,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"shipno": "No.55243852",
"cdma": "18950826997",
"inmc": "INMC.07026",
"speed": 18,
"heading": 258
},
{
"id": 5,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"shipno": "No.552438525",
"cdma": "18950826997",
"inmc": "INMC.07026",
"speed": 18,
"heading": 258
}
],
"totalPages": 1,
"totalElements": 2,
"last": true,
"size": 3,
"number": 0,
"first": true,
"sort": [
{
"direction": "DESC",
"property": "updated",
"ignoreCase": false,
"nullHandling": "NATIVE",
"ascending": false
}
],
"numberOfElements": 2
}
}
海警分页查询输出
2. 融合
2.1. 查询融合信息记录
URL：
Request Type：
get
Example：
输入
GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
融合查询输入
输出
{
"flag": 0,
"data": [
{
"id": 1,
"latitude": 125.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"rongheno": "RH.53273943"
}
]
}
融合查询输出
2.2. 批量插入融合信息记录
URL：
http://127.0.0.1:8096/ronghe/create/
Request Type：
post
Example：
输入
POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[
{
"latitude": 125.123, //纬度 DECIMAL(20,16)
"longitude": 33.001, //经度 DECIMAL(20,16)
"updated": "2016-07-24 18:00:09", //更新时间 DATETIME
"status": 0, //不需要关注，可选
"rongheno": "RH.53273943" //融合编号 VARCHAR(50)
}
]
融合批量插入输入
输出
{
"flag": 0,
"data": [
{
"id": 2,
"latitude": 125.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"rongheno": "RH.53273943"
}
]
}
融合批量插入输出
2.3. 分页查询融合信息记录
URL：
http://127.0.0.1:8096/ronghe/page?pn=1&ps=3
Request Type：
get
Example：
输入
.GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
融合信息分页查询输入
输出
{
"flag": 0,
"data": {
"content": [
{
"id": 3,
"latitude": 125.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"rongheno": "RH.53273943"
}
],
"totalPages": 1,
"totalElements": 1,
"last": true,
"size": 3,
"number": 0,
"first": true,
"sort": [
{
"direction": "DESC",
"property": "updated",
"ignoreCase": false,
"nullHandling": "NATIVE",
"ascending": false
}
],
"numberOfElements": 1
}
}
融合信息分页查询输出
3. AIS
3.1. 查询 AIS 信息记录
URL：
Request Type：
get
Example：
输入
GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
AIS查询输入
输出
{
"flag": 0,
"data": [
{
"id": 1,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"aisno": "hk.8923",
"shipname": "北极1号",
"radiocallsign": "pjyo",
"speed": 19,
"heading": 279.7,
"channel": 347.2
}
]
}
AIS查询输出
3.2.批量插入 AIS 信息记录
URL：
http://127.0.0.1:8096/ais/create/
Request Type：
post
Example：
输入
POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[{
"aisno": "hk.8923", //AIS编号 VARCHAR(50)
"shipname": "钓鱼岛1号", //船名 VARCHAR(50)
"radiocallsign": "axyx01", //呼号 VARCHAR(50)
"latitude": 32.001, //纬度 DECIMAL(20,16)
"longitude": 128.123004, //经度 DECIMAL(20,16)
"speed": 55.245, //航速 DECIMAL(8,4)
"heading": 220, //航向 DECIMAL(8,4)
"channel": 110, // 船道向 DECIMAL(8,4)
"updated": "2016-07-25 00:02:00", //更新时间 DATETIME
"status": 0 //不需要关注，可选
},{
"aisno": "hk.8955",
"shipname": "钓鱼岛5号",
"radiocallsign": "axyx05",
"latitude": 32.3432,
"longitude": 128.1263,
"speed": 44.12,
"heading": 105,
"channel": 85,
"updated": "2016-07-25 00:02:00",
"status": 0
}]
AIS批量插入输入
输出
{
"flag": 0,
"data": [
{
"id": 2,
"latitude": 32.001,
"longitude": 128.123004,
"updated": "2016-07-25 00:02:00",
"status": 0,
"aisno": "hk.8923",
"shipname": "钓鱼岛1号",
"radiocallsign": "axyx01",
"speed": 55.245,
"heading": 220,
"channel": 110
},
{
"id": 3,
"latitude": 32.3432,
"longitude": 128.1263,
"updated": "2016-07-25 00:02:00",
"status": 0,
"aisno": "hk.8955",
"shipname": "钓鱼岛5号",
"radiocallsign": "axyx05",
"speed": 44.12,
"heading": 105,
"channel": 85
}
]
}
AIS批量插入输出
3.3. 分页查询AIS信息记录
URL：
http://127.0.0.1:8096/ais/page?pn=1&ps=3
Request Type：
get
Example：
输入
.GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
AIS分页查询输入
输出
{
"flag": 0,
"data": {
"content": [
{
"id": 6,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"aisno": "hk.8923",
"shipname": "北极2号",
"radiocallsign": "pjyo",
"speed": 19,
"heading": 279.7,
"channel": 347.2
},
{
"id": 7,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"aisno": "3",
"shipname": "北极2号",
"radiocallsign": "pjyo",
"speed": 19,
"heading": 279.7,
"channel": 347.2
},
{
"id": 9,
"latitude": 128.123,
"longitude": 32.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"aisno": "5",
"shipname": "北极2号",
"radiocallsign": "pjyo",
"speed": 19,
"heading": 279.7,
"channel": 347.2
}
],
"totalPages": 2,
"totalElements": 5,
"last": false,
"size": 3,
"number": 0,
"first": true,
"sort": [
{
"direction": "DESC",
"property": "updated",
"ignoreCase": false,
"nullHandling": "NATIVE",
"ascending": false
}
],
"numberOfElements": 3
}
}
AIS分页查询输出
4. 雷达
4.1 查询雷达信息记录
URL：
Request Type：
get
Example：
输入
GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
雷达查询输入
输出
{
"flag": 0,
"data": [
{
"id": 1,
"latitude": 128.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"radarno": "No.99_5",
"radarposition": "psvnaexvc",
"direction": "257.3300",
"distance": "1.4998213081",
"speed": 6,
"heading": 278.5
}
]
}
4.2.批量插入雷达信息记录
URL：
http://127.0.0.1:8096/radar/create/
Request Type：
post
Example：
输入
POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[
{
"latitude": 128.123, //纬度 DECIMAL(20,16)
"longitude": 33.001, //经度 DECIMAL(20,16)
"updated": "2016-07-24 18:00:09", //更新时间 DATETIME
"status": 0, //不需要关注，可选
"radarno": "No.99_5", //雷达目标编号 VARCHAR(50)
"radarposition": "psvnaexvc", //雷达位置 VARCHAR(100)
"direction": "257.3300", //方位 DECIMAL(8,4)
"distance": "1.4998213081", //距离 DECIMAL(20,10)
"speed": 6, //航速 DECIMAL(8,4)
"heading": 278.5 //航向 DECIMAL(8,4)
}
]
雷达批量插入输入
输出
{
"flag": 0,
"data": [
{
"id": 2,
"latitude": 128.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 0,
"radarno": "No.99_5",
"radarposition": "psvnaexvc",
"direction": "257.3300",
"distance": "1.4998213081",
"speed": 6,
"heading": 278.5
}
]
}
雷达批量插入输出
4.3. 分页查询雷达信息记录
URL：
http://127.0.0.1:8096/radar/page?pn=1&ps=3
Request Type：
get
Example：
输入
.GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
雷达分页查询输入
输出
{
"flag": 0,
"data": {
"content": [
{
"id": 4,
"latitude": 128.123,
"longitude": 33.001,
"updated": "2016-07-24 18:00:09",
"status": 1,
"radarno": "No.99_5",
"radarposition": "psvnaexvc",
"direction": "257.3300",
"distance": "1.4998213081",
"speed": 4446,
"heading": 278.5
}
],
"totalPages": 1,
"totalElements": 1,
"last": true,
"size": 3,
"number": 0,
"first": true,
"sort": [
{
"direction": "DESC",
"property": "updated",
"ignoreCase": false,
"nullHandling": "NATIVE",
"ascending": false
}
],
"numberOfElements": 1
}
}
雷达分页查询输出
5. 雷达站
5.1 查询雷达站信息记录
URL：
http://127.0.0.1:8096/radarstation/listall
Request Type：
get
Example：
输入
![Uploading Paste_Image_094020.png . . .]
GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
雷达站查询输入
输出
{
"flag": 0,
"data": [
{
"id": 1,
"latitude": 20.418083,
"longitude": 109.91086,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "001",
"name": "湛江流沙雷达站",
"camerano": "1",
"radius": 100,
"remark": "湛江流沙雷达站"
},
{
"id": 2,
"latitude": 22.238566,
"longitude": 113.5779,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "002",
"name": "珠海雷达站",
"camerano": "1",
"radius": 110,
"remark": "珠海雷达站"
},
{
"id": 3,
"latitude": 22.5969,
"longitude": 114.337783,
"updated": "2016-08-09 10:03:28",
"status": 0,
"radarstationno": "003",
"name": "深圳背仔角雷达站",
"camerano": "1",
"radius": 110,
"remark": "深圳背仔角雷达站"
},
{
"id": 4,
"latitude": 22.611716,
"longitude": 114.40225,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "004",
"name": "深圳土洋雷达站",
"camerano": "1",
"radius": 110,
"remark": "深圳土洋雷达站"
},
{
"id": 5,
"latitude": 22.50075,
"longitude": 114.47915,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "005",
"name": "深圳羊筹角雷达站",
"camerano": "1",
"radius": 110,
"remark": "深圳羊筹角雷达站"
},
{
"id": 6,
"latitude": 23.336116,
"longitude": 116.7451,
"updated": "2016-08-09 12:03:28",
"status": 1,
"radarstationno": "006",
"name": "汕头妈屿岛雷达站",
"camerano": "1",
"radius": 100,
"remark": "汕头妈屿岛雷达站"
},
{
"id": 7,
"latitude": 23.45703,
"longitude": 116.97708,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "007",
"name": "汕头南澳岛雷达站",
"camerano": "1",
"radius": 120,
"remark": "汕头南澳岛雷达站"
}
]
}
![雷达查询输出]](https://img.haomeiwen.com/i2578430/cd9076df1f219173.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240))
4.2.批量插入雷达站信息记录
URL：
http://127.0.0.1:8096/radarstation/create/
Request Type：
post
Example：
输入
POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[
{
"latitude": 23.45703, //纬度 DECIMAL(20,16)
"longitude": 116.97708, //经度 DECIMAL(20,16)
"updated": "2016-08-09 10:03:28", //更新时间 DATETIME
"status": 1, //不需要关注，可选 INT
"radarstationno": "007", //雷达站编号 VARCHAR(50)
"name": "汕头南澳岛雷达站",//雷站达名称 VARCHAR(50)
"camerano": "1", //摄像头编号 VARCHAR(20)
"radius": 120, // 半径 DECIMAL(8,4)
"remark": "汕头南澳岛雷达站" //描述 VARCHAR(100)
}
]
雷达站批量插入输入
输出
{
"flag": 0,
"data": [
{
"id": 8,
"latitude": 23.45703,
"longitude": 116.97708,
"updated": "2016-08-09 10:03:28",
"status": 1,
"radarstationno": "007",
"name": "汕头南澳岛雷达站2",
"camerano": "1",
"radius": 120,
"remark": "汕头南澳岛雷达站2"
}
]
}
雷达站批量插入输出
6. MYSQl脚本
CREATE SCHEMA `coast` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
#海警
DROP TABLE IF EXISTS `coast`.`t_haijing`;
CREATE TABLE `coast`.`t_haijing` (
`id` INT NOT NULL auto_increment,
`shipNo` VARCHAR(50) NOT NULL,
`CDMA` VARCHAR(20) NULL,
`INMC` VARCHAR(50) NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
`speed` DECIMAL(8,4) NULL,
`heading` DECIMAL(8,4) NULL,
`updated` DATETIME NOT NULL,
`status` INT NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_haijing` DROP INDEX index_haijing;
ALTER TABLE `t_haijing` ADD INDEX index_haijing (`updated`);
ALTER TABLE `t_haijing` ADD INDEX index_no (`shipNo`);
#融合
DROP TABLE IF EXISTS `coast`.`t_ronghe`;
CREATE TABLE `coast`.`t_ronghe` (
`id` INT NOT NULL auto_increment,
`rongheNo` VARCHAR(50) NOT NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
`updated` DATETIME NOT NULL,
`status` INT NOT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_ronghe` DROP INDEX index_ronghe;
ALTER TABLE `t_ronghe` ADD INDEX index_ronghe ( `updated`);
ALTER TABLE `t_ronghe` ADD INDEX index_no ( `rongheNo`);
#AIS
DROP TABLE IF EXISTS `coast`.`t_ais`;
CREATE TABLE `coast`.`t_ais` (
`id` INT NOT NULL auto_increment,
`aisNo` VARCHAR(50) NOT NULL,
`shipName` VARCHAR(50) NULL,
`radioCallSign` VARCHAR(50) NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
`speed` DECIMAL(8,4) NULL,
`heading` DECIMAL(8,4) NULL,
`channel` DECIMAL(8,4) NULL,
`updated` DATETIME NOT NULL,
`status` INT NOT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_ais` DROP INDEX index_ais;
ALTER TABLE `t_ais` ADD INDEX index_ais ( `updated`);
ALTER TABLE `t_ais` ADD INDEX index_no ( `aisNo`);
#雷达
DROP TABLE IF EXISTS `coast`.`t_radar`;
CREATE TABLE `coast`.`t_radar` (
`id` INT NOT NULL auto_increment,
`radarNo` VARCHAR(50) NOT NULL,
`radarPosition` VARCHAR(100) NULL,
`direction` DECIMAL(8,4) NULL,
`distance` DECIMAL(20,10) NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
`speed` DECIMAL(8,4) NULL,
`heading` DECIMAL(8,4) NULL,
`updated` DATETIME NOT NULL,
`status` INT NOT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_radar` DROP INDEX index_radar;
ALTER TABLE `t_radar` ADD INDEX index_radar (`updated`);
ALTER TABLE `t_radar` ADD INDEX index_no ( `radarNo`);
#雷达站
DROP TABLE IF EXISTS `coast`.`t_radar_station`;
CREATE TABLE `coast`.`t_radar_station` (
`id` INT NOT NULL auto_increment,
`radarstationNo` VARCHAR(20) NOT NULL,
`name` VARCHAR(50) NOT NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
`radius` DECIMAL(8,4) NULL,
`remark` VARCHAR(100) NULL,
`updated` DATETIME NOT NULL,
`status` INT NOT NULL,
`cameraNo` VARCHAR(20) NOT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
ALTER TABLE `t_radar_station` ADD INDEX index_radar_station (`updated`);
ALTER TABLE `t_radar_station` ADD INDEX index_no ( `radarstationNo`);
#ALTER TABLE `t_radar_station` DROP INDEX index_no;
#支队信息
DROP TABLE IF EXISTS `coast`.`t_team_region`;
CREATE TABLE `coast`.`t_team_region` (
`id` INT NOT NULL auto_increment,
`objId` INT NOT NULL,
`order` INT NOT NULL,
`latitude` DECIMAL(20,16) NULL,
`longitude` DECIMAL(20,16) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#图层控制管理对象关系
DROP TABLE IF EXISTS `coast`.`t_opt_relation`;
CREATE TABLE `coast`.`t_opt_relation` (
`id` INT NOT NULL auto_increment,
`name` VARCHAR(50) NOT NULL,
`parentId` INT NULL,
`tableName` VARCHAR(200) NULL,
`objId` INT NULL,
`isLeaf` INT NULL,
`desc` VARCHAR(500) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
