用户信息列表
<h5>简要描述</h5>
<ul>
<li>用户信息列表</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>http://xx.com/visitLog/getDbUserList</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;">currentPage</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>第几页</td>
</tr>
<tr>
<td style="text-align: left;">pageSize</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>每页几条</td>
</tr>
<tr>
<td style="text-align: left;">conditions</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>查询条件,嵌套一层json。conditions:{"proxyServerId":"226"}</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<pre><code>{
"total": 2,
"flag": true,
"data": [
{
"id": null,
"dbUser": "ghca31",
"accessDate": null,
"firstAccessDate": "2021-10-10 18:16:51",
"number": "4",
"proxyIp": null,
"proxyPort": null,
"status": null,
"accessSqlType": null,
"accessClient": null,
"accessIp": null,
"accessMac": null,
"impactAction": null,
"tableNamesFamily": null,
"tableNum": 1,
"accessOsUser": null,
"columnsInSql": null,
"proxyServerId": null
},
{
"id": null,
"dbUser": "MYDATA",
"accessDate": null,
"firstAccessDate": "2021-10-10 17:44:10",
"number": "2",
"proxyIp": null,
"proxyPort": null,
"status": null,
"accessSqlType": null,
"accessClient": null,
"accessIp": null,
"accessMac": null,
"impactAction": null,
"tableNamesFamily": null,
"tableNum": 1,
"accessOsUser": null,
"columnsInSql": null,
"proxyServerId": null
}
]
}</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;">flag</td>
<td style="text-align: left;">boolean</td>
<td>状态</td>
</tr>
<tr>
<td style="text-align: left;">total</td>
<td style="text-align: left;">int</td>
<td>数据总条数</td>
</tr>
<tr>
<td style="text-align: left;">dbUser</td>
<td style="text-align: left;">string</td>
<td>用户名</td>
</tr>
<tr>
<td style="text-align: left;">number</td>
<td style="text-align: left;">string</td>
<td>访问次数</td>
</tr>
<tr>
<td style="text-align: left;">firstAccessDate</td>
<td style="text-align: left;">string</td>
<td>加入时间</td>
</tr>
<tr>
<td style="text-align: left;">tableNum</td>
<td style="text-align: left;">int</td>
<td>用到的表数</td>
</tr>
</tbody>
</table>
<h5>备注</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>