Examples with SqlListResult com.alibaba.druid.admin.model.dto.SqlListResult used on opensource projects

Example 1 with SqlListResult

use of com.alibaba.druid.admin.model.dto.SqlListResult in project druid by alibaba.

the class MonitorStatService method getSqlStatDataList.

/**
 * SQL监控列表
 *
 * @param parameters
 * @return
 */
@SuppressWarnings("unchecked")
public String getSqlStatDataList(Map<String, String> parameters) {
    Map<String, ServiceNode> serviceAllNodeMap = getServiceAllNodeMap(parameters);
    List<Map<String, Object>> arrayMap = new ArrayList<>();
    for (String nodeKey : serviceAllNodeMap.keySet()) {
        ServiceNode serviceNode = serviceAllNodeMap.get(nodeKey);
        String serviceName = serviceNode.getServiceName();
        String url = getRequestUrl(parameters, serviceNode, "/druid/sql.json");
        SqlListResult sqlListResult = HttpUtil.get(url, SqlListResult.class);
        if (sqlListResult != null) {
            List<SqlListResult.ContentBean> nodeContent = sqlListResult.getContent();
            if (nodeContent != null) {
                for (SqlListResult.ContentBean contentBean : nodeContent) {
                    contentBean.setName(serviceName);
                    contentBean.setAddress(serviceNode.getAddress());
                    contentBean.setPort(serviceNode.getPort());
                    contentBean.setServiceId(serviceNode.getId());
                    Map map = JSONObject.parseObject(JSONObject.toJSONString(contentBean), Map.class);
                    arrayMap.add(map);
                }
            }
        }
    }
    List<Map<String, Object>> maps = comparatorOrderBy(arrayMap, parameters);
    String jsonString = JSON.toJSONString(maps);
    JSONArray objects = JSON.parseArray(jsonString);
    JSONObject jsonObject = new JSONObject();
    jsonObject.put("ResultCode", RESULT_CODE_SUCCESS);
    jsonObject.put("Content", objects);
    return jsonObject.toJSONString();
}