public ZooKeeperCluster getZooKeeperClusterByCulsterId(int clusterId) throws DaoException {

    ZooKeeperCluster zookeeperCluster = null;
    // 从数据库中获取指定zookeeper集群中所有机器
    ResultSet rs = null;
    DBConnectionResource myResultSet = null;
    try {
      String querySQL =
          StringUtil.replaceSequenced(SQL_QUERY_CLUSTER_BY_ID, clusterId + EMPTY_STRING);
      myResultSet = DbcpUtil.executeQuery(querySQL);
      if (null == myResultSet) throw new DaoException("没有返回结果");
      rs = myResultSet.resultSet;
      if (rs.next()) {

        String clusterName = rs.getString("cluster_name");
        String serverListStr = rs.getString("server_list");
        String description = rs.getString("description");

        List<String> serverList = null;
        if (!StringUtil.isBlank(serverListStr)) {
          String[] serverListArray = serverListStr.split(COMMA);
          serverList = ArrayUtil.toArrayList(serverListArray);
        }
        zookeeperCluster = new ZooKeeperCluster();
        zookeeperCluster.setClusterId(clusterId);
        zookeeperCluster.setClusterName(clusterName);
        zookeeperCluster.setServerList(serverList);
        zookeeperCluster.setDescription(description);
      }
      return zookeeperCluster;
    } catch (Exception e) {
      throw new DaoException(
          "Error when query zookeeper cluster by cluster_id: "
              + clusterId
              + ", Error: "
              + e.getMessage(),
          e);
    } finally {
      if (null != myResultSet) {
        DbcpUtil.closeResultSetAndStatement(rs, myResultSet.statement);
        DbcpUtil.returnBackConnectionToPool(myResultSet.connection);
      }
    }
  }
  @Override
  public List<ZooKeeperCluster> getAllDetailZooKeeperCluster() throws DaoException {

    List<ZooKeeperCluster> zookeeperClusterList = new ArrayList<ZooKeeperCluster>();
    // 从数据库中获取指定zookeeper集群中所有机器
    ResultSet rs = null;
    DBConnectionResource myResultSet = null;
    try {
      myResultSet = DbcpUtil.executeQuery(SQL_QUERY_ALL_DETAIL_CLUSTER);
      if (null == myResultSet) throw new DaoException("没有返回结果");
      rs = myResultSet.resultSet;
      while (rs.next()) {

        int clusterId = rs.getInt("cluster_id");
        String clusterName = rs.getString("cluster_name");
        String serverListStr = rs.getString("server_list");
        String description = rs.getString("description");

        List<String> serverList = null;
        if (!StringUtil.isBlank(serverListStr)) {
          String[] serverListArray = serverListStr.split(COMMA);
          serverList = ArrayUtil.toArrayList(serverListArray);
        }
        ZooKeeperCluster zookeeperCluster = new ZooKeeperCluster();
        zookeeperCluster.setClusterId(clusterId);
        zookeeperCluster.setClusterName(clusterName);
        zookeeperCluster.setServerList(serverList);
        zookeeperCluster.setDescription(description);

        zookeeperClusterList.add(zookeeperCluster);
      }
      return zookeeperClusterList;
    } catch (Exception e) {
      throw new DaoException("Error when query all zookeeper cluster, Error: " + e.getMessage(), e);
    } finally {
      if (null != myResultSet) {
        DbcpUtil.closeResultSetAndStatement(rs, myResultSet.statement);
        DbcpUtil.returnBackConnectionToPool(myResultSet.connection);
      }
    }
  }