获取表字段列表

简述:

  • 获取表字段列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
boId string 业务对象名字
columnName string 列名
dsAlias string 数据源别名
tableName string 表名

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/columnList?boId=654765464966135808&columnName=&dsAlias=&tableName=t_jdbd

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": [
        {
            "comment": "主键",
            "id": "id_",
            "text": "id_"
        },
        {
            "comment": "租户ID",
            "id": "tenant_id_",
            "text": "tenant_id_"
        },
        {
            "comment": "IP地址",
            "id": "ip_",
            "text": "ip_"
        },
        {
            "comment": "创建人",
            "id": "create_by_",
            "text": "create_by_"
        },
        {
            "comment": "创建时间",
            "id": "create_time_",
            "text": "create_time_"
        },
        {
            "comment": "更新人",
            "id": "update_by_",
            "text": "update_by_"
        },
        {
            "comment": "更新时间",
            "id": "update_time_",
            "text": "update_time_"
        },
        {
            "comment": "标题",
            "id": "biao_ti_",
            "text": "biao_ti_"
        },
        {
            "comment": "作者",
            "id": "zuo_zhe_",
            "text": "zuo_zhe_"
        },
        {
            "comment": "内容",
            "id": "nei_rong_",
            "text": "nei_rong_"
        },
        {
            "comment": "经费",
            "id": "jing_fei_",
            "text": "jing_fei_"
        }
    ]
}

返回参数说明:

名称 类型 备注
data List<Map<String, String>>

根据表配置设计表单

简述:

  • 根据表配置设计表单

请求URL:

请求方式:

  • POST

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
id string 表配置id

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/design?id=676734401454800896

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": null
}

返回参数说明:

名称 类型 备注
data Map<String, String>

获取字段列表

简述:

  • 获取字段列表

请求URL:

请求方式:

  • POST

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
boId string 业务对象id
dsAlias string 数据源别名
tableName string 表名

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/fieldList?boId=654765464966135808&dsAlias=dataSource_default&tableName=t_jdbd

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": [
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "id_",
            "fieldComment": "主键",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "id",
            "keyName": "pk",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "N",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": true
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "tenant_id_",
            "fieldComment": "租户ID",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "tenantId",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "ip_",
            "fieldComment": "IP地址",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "ip",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 15,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "create_by_",
            "fieldComment": "创建人",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "createBy",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "create_time_",
            "fieldComment": "创建时间",
            "sqlType": "date",
            "javaType": "Date",
            "propName": "createTime",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "between",
            "isNull": "Y",
            "control": "datePicker",
            "length": 0,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "日期控件",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "update_by_",
            "fieldComment": "更新人",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "updateBy",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "update_time_",
            "fieldComment": "更新时间",
            "sqlType": "date",
            "javaType": "Date",
            "propName": "updateTime",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "between",
            "isNull": "Y",
            "control": "datePicker",
            "length": 0,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "日期控件",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "biao_ti_",
            "fieldComment": "标题",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "biaoTi",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 200,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "zuo_zhe_",
            "fieldComment": "作者",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "zuoZhe",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 200,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "nei_rong_",
            "fieldComment": "内容",
            "sqlType": "clob",
            "javaType": "String",
            "propName": "neiRong",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "=",
            "isNull": "Y",
            "control": "editor",
            "length": 65535,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "富文本框",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "jing_fei_",
            "fieldComment": "经费",
            "sqlType": "number",
            "javaType": "Double",
            "propName": "jingFei",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "=",
            "isNull": "Y",
            "control": "text",
            "length": 0,
            "precision": 2,
            "scale": 2,
            "validate": null,
            "defaultValue": null,
            "sn": null,
            "controlLabel": "单行文本",
            "pk2": false
        }
    ]
}

返回参数说明:

名称 类型 备注
data List< FieldConfigPo >

根据表配置名称获取【表配置】列表

简述:

  • 根据表配置名称获取【表配置】列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
tableName string 表名

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/findByName?tableName=t_jdbd

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": [
        {
            "mode": "bo",
            "struType": "list",
            "classVar": "commonTest",
            "id": "t_jdbd",
            "text": "t_jdbd",
            "class": "CommonTest"
        }
    ]
}

返回参数说明:

名称 类型 备注
data List<Map<String, String>>

根据条件获取【物理表】列表

简述:

  • 根据条件获取【物理表】列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
boId string 业务对象id
dsAlias string 数据源别名
tableName string 表名
tableSource string table 表来源

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/findTable?boId=675151667993247744&dsAlias=dataSource_default&tableName=t_test&tableSource=table

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": []
}

返回参数说明:

名称 类型 备注
data List<Map<String, String>>

获取【表配置】数据

简述:

  • 获取【表配置】数据

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
id string 方案id

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/get?id=657589325482950656

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {
        "dataSourceList": [
            {
                "alias": "dataSource_default",
                "name": "def",
                "dbType": "mysql",
                "driver": "com.mysql.jdbc.Driver",
                "driverUrl": "jdbc:mysql://192.168.3.210:3306/ibps_business_test_v3.2.0?useUnicode=true&characterEncoding=utf-8",
                "port": null,
                "poolType": null,
                "user": "root",
                "password": "root",
                "comment": null,
                "status": "actived",
                "isDefault": true,
                "variables": {
                    "minIdle": "20",
                    "validationQuery": "SELECT 'x'",
                    "initialSize": "20",
                    "maxWait": "3600000",
                    "poolPreparedStatements": "true",
                    "filters": "stat",
                    "maxPoolPreparedStatementPerConnectionSize": "20",
                    "logAbandoned": "true",
                    "testOnBorrow": "false",
                    "testWhileIdle": "true",
                    "removeAbandoned": "true",
                    "timeBetweenEvictionRunsMillis": "3600000",
                    "minEvictableIdleTimeMillis": "300000",
                    "testOnReturn": "false",
                    "removeAbandonedTimeout": "1800",
                    "maxActive": "200"
                },
                "param": null,
                "default": true,
                "leader": false,
                "follower": false
            }
        ]
    },
    "data": {
        "pk": "",
        "name": null,
        "ip": null,
        "createBy": null,
        "createTime": 1576823113000,
        "updateBy": null,
        "updateTime": null,
        "tenantId": null,
        "dataStatus": null,
        "dbtype": null,
        "id": "657589325482950656",
        "typeId": "",
        "tableSource": "bo",
        "boId": "654765464966135808",
        "tableName": "t_jdbd",
        "tableComment": "t_jdbd",
        "className": "CommonTest",
        "parentTableName": "",
        "foreignKey": "",
        "fromKey": "",
        "relation": "",
        "layerTemplate": "one",
        "creator": "654755459927900160",
        "struType": "list",
        "idKey": "",
        "pidKey": "",
        "key": "",
        "dsAlias": "dataSource_default",
        "typeName": null,
        "boName": "简单表单",
        "fieldConfigPoList": [
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326384726016",
                "parentId": "657589325482950656",
                "field": "id_",
                "fieldComment": "主键",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "id",
                "keyName": "pk",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "N",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 1,
                "controlLabel": null,
                "pk2": true
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326539915264",
                "parentId": "657589325482950656",
                "field": "tenant_id_",
                "fieldComment": "租户ID",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "tenantId",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 2,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326644772864",
                "parentId": "657589325482950656",
                "field": "ip_",
                "fieldComment": "IP地址",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "ip",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 15,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 3,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326716076032",
                "parentId": "657589325482950656",
                "field": "create_by_",
                "fieldComment": "创建人",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "createBy",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 4,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326787379200",
                "parentId": "657589325482950656",
                "field": "create_time_",
                "fieldComment": "创建时间",
                "sqlType": "date",
                "javaType": "Date",
                "propName": "createTime",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "between",
                "isNull": "Y",
                "control": "datePicker",
                "length": 0,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 5,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327051620352",
                "parentId": "657589325482950656",
                "field": "update_by_",
                "fieldComment": "更新人",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "updateBy",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 6,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327240364032",
                "parentId": "657589325482950656",
                "field": "update_time_",
                "fieldComment": "更新时间",
                "sqlType": "date",
                "javaType": "Date",
                "propName": "updateTime",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "between",
                "isNull": "Y",
                "control": "datePicker",
                "length": 0,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 7,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327345221632",
                "parentId": "657589325482950656",
                "field": "biao_ti_",
                "fieldComment": "标题",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "biaoTi",
                "keyName": "",
                "showList": "Y",
                "showQuery": "Y",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 200,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 8,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327412330496",
                "parentId": "657589325482950656",
                "field": "zuo_zhe_",
                "fieldComment": "作者",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "zuoZhe",
                "keyName": "",
                "showList": "Y",
                "showQuery": "Y",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 200,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 9,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327483633664",
                "parentId": "657589325482950656",
                "field": "nei_rong_",
                "fieldComment": "内容",
                "sqlType": "clob",
                "javaType": "String",
                "propName": "neiRong",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "=",
                "isNull": "Y",
                "control": "editor",
                "length": 65535,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 10,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327588491264",
                "parentId": "657589325482950656",
                "field": "jing_fei_",
                "fieldComment": "经费",
                "sqlType": "number",
                "javaType": "Double",
                "propName": "jingFei",
                "keyName": "",
                "showList": "Y",
                "showQuery": "N",
                "queryOp": "=",
                "isNull": "Y",
                "control": "text",
                "length": 0,
                "precision": 2,
                "scale": 2,
                "validate": null,
                "defaultValue": null,
                "sn": 11,
                "controlLabel": null,
                "pk2": false
            }
        ],
        "delBeforeSave": true
    }
}

返回参数说明:

名称 类型 备注
data TableConfigPo 表配置

获取字段列表

简述:

  • 获取字段列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
tableName string 表名
throwException boolean false 是否抛异常

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/loadCascadeByTableName?tableName=t_jdbd&throwException=false

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": {
        "pk": "",
        "name": null,
        "ip": null,
        "createBy": null,
        "createTime": 1576823113000,
        "updateBy": null,
        "updateTime": null,
        "tenantId": null,
        "dataStatus": null,
        "dbtype": null,
        "id": "657589325482950656",
        "typeId": "",
        "tableSource": "bo",
        "boId": "654765464966135808",
        "tableName": "t_jdbd",
        "tableComment": "t_jdbd",
        "className": "CommonTest",
        "parentTableName": "",
        "foreignKey": "",
        "fromKey": "",
        "relation": "",
        "layerTemplate": "one",
        "creator": "654755459927900160",
        "struType": "list",
        "idKey": "",
        "pidKey": "",
        "key": "",
        "dsAlias": "dataSource_default",
        "typeName": null,
        "boName": null,
        "fieldConfigPoList": [
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326384726016",
                "parentId": "657589325482950656",
                "field": "id_",
                "fieldComment": "主键",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "id",
                "keyName": "pk",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "N",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 1,
                "controlLabel": null,
                "pk2": true
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326539915264",
                "parentId": "657589325482950656",
                "field": "tenant_id_",
                "fieldComment": "租户ID",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "tenantId",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 2,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326644772864",
                "parentId": "657589325482950656",
                "field": "ip_",
                "fieldComment": "IP地址",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "ip",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 15,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 3,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326716076032",
                "parentId": "657589325482950656",
                "field": "create_by_",
                "fieldComment": "创建人",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "createBy",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 4,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589326787379200",
                "parentId": "657589325482950656",
                "field": "create_time_",
                "fieldComment": "创建时间",
                "sqlType": "date",
                "javaType": "Date",
                "propName": "createTime",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "between",
                "isNull": "Y",
                "control": "datePicker",
                "length": 0,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 5,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327051620352",
                "parentId": "657589325482950656",
                "field": "update_by_",
                "fieldComment": "更新人",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "updateBy",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 64,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 6,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327240364032",
                "parentId": "657589325482950656",
                "field": "update_time_",
                "fieldComment": "更新时间",
                "sqlType": "date",
                "javaType": "Date",
                "propName": "updateTime",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "between",
                "isNull": "Y",
                "control": "datePicker",
                "length": 0,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 7,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327345221632",
                "parentId": "657589325482950656",
                "field": "biao_ti_",
                "fieldComment": "标题",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "biaoTi",
                "keyName": "",
                "showList": "Y",
                "showQuery": "Y",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 200,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 8,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327412330496",
                "parentId": "657589325482950656",
                "field": "zuo_zhe_",
                "fieldComment": "作者",
                "sqlType": "varchar",
                "javaType": "String",
                "propName": "zuoZhe",
                "keyName": "",
                "showList": "Y",
                "showQuery": "Y",
                "queryOp": "like",
                "isNull": "Y",
                "control": "text",
                "length": 200,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 9,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327483633664",
                "parentId": "657589325482950656",
                "field": "nei_rong_",
                "fieldComment": "内容",
                "sqlType": "clob",
                "javaType": "String",
                "propName": "neiRong",
                "keyName": "",
                "showList": "N",
                "showQuery": "N",
                "queryOp": "=",
                "isNull": "Y",
                "control": "editor",
                "length": 65535,
                "precision": 0,
                "scale": 0,
                "validate": null,
                "defaultValue": null,
                "sn": 10,
                "controlLabel": null,
                "pk2": false
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": null,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589327588491264",
                "parentId": "657589325482950656",
                "field": "jing_fei_",
                "fieldComment": "经费",
                "sqlType": "number",
                "javaType": "Double",
                "propName": "jingFei",
                "keyName": "",
                "showList": "Y",
                "showQuery": "N",
                "queryOp": "=",
                "isNull": "Y",
                "control": "text",
                "length": 0,
                "precision": 2,
                "scale": 2,
                "validate": null,
                "defaultValue": null,
                "sn": 11,
                "controlLabel": null,
                "pk2": false
            }
        ],
        "delBeforeSave": true
    }
}

返回参数说明:

名称 类型 备注
data TableConfigPo 表配置

获取父级表字段列表

简述:

  • 获取父级表字段列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
boId string 业务对象Id
columnName string 列名
dsAlias string 数据源别名
tableName string 表名

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/pcolumnList?boId=&columnName=&dsAlias=dataSource_default&tableName=t_jdbd

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": [
        {
            "comment": "主键",
            "id": "id_",
            "text": "id_"
        },
        {
            "comment": "租户ID",
            "id": "tenant_id_",
            "text": "tenant_id_"
        },
        {
            "comment": "IP地址",
            "id": "ip_",
            "text": "ip_"
        },
        {
            "comment": "创建人",
            "id": "create_by_",
            "text": "create_by_"
        },
        {
            "comment": "创建时间",
            "id": "create_time_",
            "text": "create_time_"
        },
        {
            "comment": "更新人",
            "id": "update_by_",
            "text": "update_by_"
        },
        {
            "comment": "更新时间",
            "id": "update_time_",
            "text": "update_time_"
        },
        {
            "comment": "标题",
            "id": "biao_ti_",
            "text": "biao_ti_"
        },
        {
            "comment": "作者",
            "id": "zuo_zhe_",
            "text": "zuo_zhe_"
        },
        {
            "comment": "内容",
            "id": "nei_rong_",
            "text": "nei_rong_"
        },
        {
            "comment": "经费",
            "id": "jing_fei_",
            "text": "jing_fei_"
        }
    ]
}

返回参数说明:

名称 类型 备注
data List<Map<String, String>>

根据条件获取父级【物理表】列表

简述:

  • 根据条件获取父级【物理表】列表

请求URL:

请求方式:

  • GET

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
boId string 业务对象Id
columnName string 列名
dsAlias string 数据源别名
tableName string 表名

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/ptableList?boId=654765464966135808&dsAlias=dataSource_default&tableName=t_z1&tableSource=table

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": [
        {
            "comment": "主1",
            "id": "t_z1",
            "text": "t_z1"
        }
    ]
}

返回参数说明:

名称 类型 备注
data List<Map<String, String>>

获取【表配置】列表

简述:

  • 获取【表配置】列表

请求URL:

请求方式:

  • POST

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
request APIRequest[1] 动态查询请求对象

请求参数示例:

{
    "parameters": [],
    "requestPage": {
        "pageNo": 1,
        "limit": 20
    },
    "sorts": []
}

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": {
        "dataResult": [
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": 1581387654000,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "676734401454800896",
                "typeId": "",
                "tableSource": "bo",
                "boId": "675151667993247744",
                "tableName": "t_test",
                "tableComment": "t_test",
                "className": "Test",
                "parentTableName": "",
                "foreignKey": "",
                "fromKey": "",
                "relation": "",
                "layerTemplate": "one",
                "creator": "654384477392338944",
                "struType": "list",
                "idKey": "",
                "pidKey": "",
                "key": "",
                "dsAlias": "dataSource_default",
                "typeName": null,
                "boName": "test",
                "fieldConfigPoList": [],
                "delBeforeSave": true
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": 1576823113000,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "657589325482950656",
                "typeId": "",
                "tableSource": "bo",
                "boId": "654765464966135808",
                "tableName": "t_jdbd",
                "tableComment": "t_jdbd",
                "className": "CommonTest",
                "parentTableName": "",
                "foreignKey": "",
                "fromKey": "",
                "relation": "",
                "layerTemplate": "one",
                "creator": "654755459927900160",
                "struType": "list",
                "idKey": "",
                "pidKey": "",
                "key": "",
                "dsAlias": "dataSource_default",
                "typeName": null,
                "boName": "简单表单",
                "fieldConfigPoList": [],
                "delBeforeSave": true
            },
            {
                "pk": "",
                "name": null,
                "ip": null,
                "createBy": null,
                "createTime": 1576494068000,
                "updateBy": null,
                "updateTime": null,
                "tenantId": null,
                "dataStatus": null,
                "dbtype": null,
                "id": "656209212459712512",
                "typeId": "656209009853857792",
                "tableSource": "bo",
                "boId": "656208542730027008",
                "tableName": "t_ddzbxx",
                "tableComment": "t_ddzbxx",
                "className": "OrderTest",
                "parentTableName": "",
                "foreignKey": "",
                "fromKey": "",
                "relation": "",
                "layerTemplate": "one",
                "creator": "654755459927900160",
                "struType": "list",
                "idKey": "",
                "pidKey": "",
                "key": "",
                "dsAlias": "dataSource_default",
                "typeName": "代码生成",
                "boName": "订单主表信息",
                "fieldConfigPoList": [],
                "delBeforeSave": true
            }
        ],
        "pageResult": {
            "limit": 3,
            "page": 1,
            "totalCount": 4,
            "totalPages": 2
        }
    }
}

返回参数说明:

名称 类型 备注
data APIPageList< TableConfigPo > 表配置

删除表配置

简述:

  • 删除表配置

请求URL:

请求方式:

  • POST

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:
名称 类型 是否必须 默认值 备注 其他信息
ids string[] 表配置ids

请求参数示例:

http://192.168.3.230:15100/ibps/business/v3/codegen/table/config/remove?ids=676797697826488320

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": null
}

返回参数说明:

名称 类型 备注
data Void

保存数据

简述:

  • 保存数据

请求URL:

请求方式:

  • POST

请求参数:

  • Headers:
名称 类型 是否必须 默认值 备注 其他信息
X-Authorization-access_token String 系统令牌
  • Query:

暂无

  • Body:

TableConfigPo 对象信息

名称 类型 是否必须 默认值 备注
id String 主键
typeId String 分类
tableSource String 表来源
boId String bo ID
tableName String 表名
tableComment String 表注释
className String 类名
parentTableName String 主表表名
foreignKey String 外键
fromKey String 来自属性
relation String 关系类型
layerTemplate String 布局模板
creator String 创建人
createTime Date 创建时间
struType String 展现类型
idKey String 节点id字段
pidKey String 父节点id字段
key String 节点名称字段
dsAlias String 数据源配置
typeName String 分类名称
boName String bo名称
fieldConfigPoList List 表字段列表

请求参数示例:

{
    "tableSource": "table",
    "dsAlias": "dataSource_default",
    "boName": "",
    "tableName": "t_z1",
    "tableComment": "t_z1",
    "className": "PhyTest",
    "layerTemplate": "one",
    "parentTableName": "",
    "typeId": "",
    "foreignKey": "",
    "fromKey": "",
    "relation": "",
    "struType": "list",
    "idKey": "",
    "pidKey": "",
    "key": "",
    "creator": "654384477392338944",
    "createTime": null,
    "fieldConfigPoList": [
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "id_",
            "fieldComment": "主键",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "id",
            "keyName": "pk",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "N",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 1,
            "controlLabel": "单行文本",
            "pk2": true
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "tenant_id_",
            "fieldComment": "租户ID",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "tenantId",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 2,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "ip_",
            "fieldComment": "IP地址",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "ip",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 15,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 3,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "create_by_",
            "fieldComment": "创建人",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "createBy",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 4,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "create_time_",
            "fieldComment": "创建时间",
            "sqlType": "date",
            "javaType": "Date",
            "propName": "createTime",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "between",
            "isNull": "Y",
            "control": "datePicker",
            "length": 0,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 5,
            "controlLabel": "日期控件",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "update_by_",
            "fieldComment": "更新人",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "updateBy",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 64,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 6,
            "controlLabel": "单行文本",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "update_time_",
            "fieldComment": "更新时间",
            "sqlType": "date",
            "javaType": "Date",
            "propName": "updateTime",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "between",
            "isNull": "Y",
            "control": "datePicker",
            "length": 0,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 7,
            "controlLabel": "日期控件",
            "pk2": false
        },
        {
            "pk": "",
            "name": null,
            "ip": null,
            "createBy": null,
            "createTime": null,
            "updateBy": null,
            "updateTime": null,
            "tenantId": null,
            "dataStatus": null,
            "dbtype": null,
            "id": null,
            "parentId": null,
            "field": "1_",
            "fieldComment": "1",
            "sqlType": "varchar",
            "javaType": "String",
            "propName": "1",
            "keyName": "",
            "showList": "Y",
            "showQuery": "Y",
            "queryOp": "like",
            "isNull": "Y",
            "control": "text",
            "length": 200,
            "precision": 0,
            "scale": 0,
            "validate": null,
            "defaultValue": null,
            "sn": 8,
            "controlLabel": "单行文本",
            "pk2": false
        }
    ]
}

返回示例:

{
    "state": 200,
    "request": null,
    "message": "",
    "cause": "",
    "variables": {},
    "data": null
}

返回参数说明:

名称 类型 备注
data Void

备注

文档更新时间: 2020-02-27 23:33   作者:朱业成