文档
测试

数据源列表

POST
http://122.112.221.198:8080/dgp_api/dq_data_source/queryDataSourceListByPage

请求头

参数名
类型
描述
必填
Authorization
String
token
必填

请求参数

参数名
类型
描述
必填
pagination
object
数据字典
必填
pageNumber
int
示例:1
必填
pageSize
int
示例:10
必填
search
object
数据字典
必填
sourceName
string
示例:
必填
sourceType
string
示例:
必填

响应参数

参数名
类型
描述
必填
success
boolean
示例:true
必填
msg
string
示例:查询成功
必填
obj
object
数据字典
必填
total
int
示例:4
必填
rows
array
数据列表
必填
id
string
示例:712667798702264320
必填
createUserName
string
示例:admin
必填
createTime
string
示例:2020-05-20 14:07:24
必填
updateUserName
string
示例:admin
必填
updateTime
string
示例:2020-05-20 14:07:24
必填
sourceName
string
示例:鹏飞测试MySql
必填
sourceType
string
示例:com.mysql.jdbc.Driver
必填
url
string
示例:jdbc:mysql://139.9.171.171:3306/testdbz1
必填
username
string
示例:root
必填
passwd
string
示例:mysql@2020~
必填
connState
string
示例:0
必填
description
string
示例:
必填
dataContextPath
object
示例:null
必填
sourceWay
string
示例:0
必填
createRealName
string
示例:管理员
必填
connMsg
object
示例:null
必填
treeId
object
示例:null
必填
used
object
示例:null
必填
createUserId
string
示例:1
必填

说明 / 示例

{ "success": true, "msg": "查询成功", "obj": { "total": 4, "rows": [ { "id": "712667798702264320", "createUserName": "admin", "createTime": "2020-05-20 14:07:24", "updateUserName": "admin", "updateTime": "2020-05-20 14:07:24", "sourceName": "鹏飞测试MySql", "sourceType": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://139.9.171.171:3306/testdbz1", "username": "root", "passwd": "mysql@2020~", "connState": "0", "description": "", "dataContextPath": null, "sourceWay": "0", "createRealName": "管理员", "connMsg": null, "treeId": null, "used": null, "createUserId": "1" }, { "id": "710917379214938112", "createUserName": "admin", "createTime": "2020-05-15 18:11:51", "updateUserName": "admin", "updateTime": "2020-05-19 22:29:49", "sourceName": "dgp华军测试勿动", "sourceType": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://116.62.15.227:3306/dgp?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "username": "root", "passwd": "Hangzhouzj*&1", "connState": "1", "description": "", "dataContextPath": null, "sourceWay": "0", "createRealName": "管理员", "connMsg": null, "treeId": null, "used": null, "createUserId": "1" }, { "id": "710885275819184128", "createUserName": "ysw", "createTime": "2020-05-15 16:04:17", "updateUserName": "admin", "updateTime": "2020-05-21 08:35:17", "sourceName": "MYSQL8_DEV", "sourceType": "com.mysql.cj.jdbc.Driver", "url": "jdbc:mysql://139.9.171.171:3308/dgp2dev?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&useSSL=false", "username": "dgp2dev", "passwd": "dgp2dev@yatop", "connState": "1", "description": "", "dataContextPath": null, "sourceWay": "0", "createRealName": "ysw", "connMsg": null, "treeId": null, "used": "710885275819184128", "createUserId": "ff80808172174a290172175786e00013" }, { "id": "710820384265605120", "createUserName": "admin", "createTime": "2020-05-15 11:46:26", "updateUserName": "admin", "updateTime": "2020-05-15 11:52:29", "sourceName": "0515数据源", "sourceType": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://120.27.246.149:3306/dgp2pro?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "username": "dgp2pro", "passwd": "dgp2_pro@yatop123", "connState": "1", "description": "", "dataContextPath": null, "sourceWay": "0", "createRealName": "管理员", "connMsg": null, "treeId": null, "used": "710820384265605120", "createUserId": "1" } ] } }