数据库管理
<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>