文档
测试

获取已经入库使用的表

GET
http://192.168.1.118:8111/dataDir/getUsedTables?dataBaseName=tbuild&ifSearchFlag=1&pageNumber=1&pageSize=10

请求参数

参数名
类型
描述
必填
dataBaseName
str
数据库code 例:tbuild
必填
ifSearchFlag
int
是否归为查询的表 1是 0否
必填
pageNumber
int
当前页数
必填
pageSize
int
一页展示条数
必填

响应参数

参数名
类型
描述
必填
status
int
示例:200
必填
data
object
数据字典
必填
total
int
示例:12
必填
list
array
数据列表
必填
id
int
示例:4
必填
status
int
示例:1
必填
pDirId
int
示例:1
必填
dirCode
string
示例:g_bd_tallbuildcheckresult
必填
dirName
string
示例:高层建筑消防安全检查实时表
必填
dataBaseName
string
示例:tbuild
必填
dirLevel
int
示例:2
必填
dirSort
int
示例:1
必填
rowCount
int
示例:300
必填
rowCountError
int
示例:7
必填
ifSearch
int
示例:1
必填
pageNum
int
示例:1
必填
pageSize
int
示例:10
必填
size
int
示例:10
必填
startRow
int
示例:1
必填
endRow
int
示例:10
必填
pages
int
示例:2
必填
prePage
int
示例:0
必填
nextPage
int
示例:2
必填
isFirstPage
boolean
示例:true
必填
isLastPage
boolean
示例:false
必填
hasPreviousPage
boolean
示例:false
必填
hasNextPage
boolean
示例:true
必填
navigatePages
int
示例:8
必填
navigatepageNums
array
数据列表
必填
navigateFirstPage
int
示例:1
必填
navigateLastPage
int
示例:2
必填

说明 / 示例

请求示例 ```json http://192.168.1.118:8111/dataDir/getUsedTables?dataBaseName=tbuild&ifSearchFlag=1&pageNumber=1&pageSize=10 ``` 返回示例 ```json { "status": 200, "data": { "total": 7, "list": [ { "id": 7, "status": 1, "pDirId": 1, "dirCode": "", "dirName": "", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 4, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-05-08 15:59:31", "updateUser": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 0 }, { "id": 11, "status": 1, "pDirId": 1, "dirCode": "g_bd_firebrigadeinfo", "dirName": "专职消防队信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 8, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 19 }, { "id": 12, "status": 1, "pDirId": 1, "dirCode": "g_bd_fireperson", "dirName": "消防机关人员表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 9, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 21 }, { "id": 13, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildabnormalsys", "dirName": "高层建筑异常信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 10, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 }, { "id": 14, "status": 1, "pDirId": 1, "dirCode": "f_bs_waterauditdtl", "dirName": "水源审核信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 11, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 7 }, { "id": 15, "status": 1, "pDirId": 1, "dirCode": "g_bd_firedepart", "dirName": "消防机构组织机构", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 12, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 23 }, { "id": 16, "status": 1, "pDirId": 1, "dirCode": "g_bd_firepersonattach", "dirName": "消防机关人员附件表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 13, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 } ], "pageNum": 1, "pageSize": 7, "size": 7, "startRow": 0, "endRow": 6, "pages": 1, "prePage": 0, "nextPage": 0, "isFirstPage": true, "isLastPage": true, "hasPreviousPage": false, "hasNextPage": false, "navigatePages": 8, "navigatepageNums": [ 1 ], "navigateFirstPage": 1, "navigateLastPage": 1 } } ```