山东信用评价

山东信用评价


数据库管理

<h5>简要描述</h5> <ul> <li>数据库管理查询表信息</li> </ul> <h5>请求URL</h5> <ul> <li><code>/web/dbmgt/getTables</code></li> </ul> <h5>请求方式</h5> <ul> <li>POST </li> </ul> <h5>参数</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">必选</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">likeTable</td> <td style="text-align: left;">否</td> <td style="text-align: left;">String</td> <td>like查询对象</td> </tr> </tbody> </table> <h5>返回示例</h5> <pre><code> { "code": 0, "type": "success", "message": "成功", "data": [ { "name": "bwlst_att_d", "comment": "黑白名单登记附件表", "fields": [ { "name": "BWLST_ATT_ID", "comment": "黑白名单附件ID", "type": "varchar(20)" }, { "name": "BWLST_REG_ID", "comment": "黑白名单登记ID", "type": "varchar(20)" }, { "name": "EVTSN", "comment": "事件流水号", "type": "varchar(50)" }, { "name": "ATT_NAME", "comment": "附件名称", "type": "varchar(200)" }, { "name": "ATT_ID", "comment": "附件ID", "type": "varchar(40)" }, { "name": "ATT_ADDR", "comment": "附件地址", "type": "varchar(400)" }, { "name": "SEQ", "comment": "顺序号", "type": "int(11)" }, { "name": "UPDT_TIME", "comment": "数据更新时间", "type": "datetime" }, { "name": "RID", "comment": "数据唯一记录号", "type": "varchar(40)" }, { "name": "CRTE_TIME", "comment": "数据创建时间", "type": "datetime" } ], "likeTable": null }, { "name": "test_d", "comment": "", "fields": [ { "name": "test_id", "comment": "", "type": "varchar(40)" }, { "name": "name", "comment": "", "type": "varchar(40)" } ], "likeTable": null } ], "total": 0 } </code></pre> <h5>返回对象解析</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">name</td> <td style="text-align: left;">string</td> <td>表名</td> </tr> <tr> <td style="text-align: left;">comment</td> <td style="text-align: left;">string</td> <td>注释</td> </tr> <tr> <td style="text-align: left;">字段对象</td> <td style="text-align: left;">JSONObject</td> <td>fields</td> </tr> </tbody> </table> <h5>字段对象说明</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">name</td> <td style="text-align: left;">string</td> <td>字段名</td> </tr> <tr> <td style="text-align: left;">comment</td> <td style="text-align: left;">string</td> <td>注释</td> </tr> <tr> <td style="text-align: left;">type</td> <td style="text-align: left;">string</td> <td>字段类型</td> </tr> </tbody> </table>

页面列表

ITEM_HTML