How to use

MapHandler

in

org.apache.commons.dbutils.handlers

public MutableMap<String, Object> queryForMap(Connection conn, String sql) {
  return MapAdapter.adapt(this.query(conn, sql, new MapHandler()));
}

public MutableMap<String, Object> queryForMap(Connection conn, String sql) {
  return MapAdapter.adapt(this.query(conn, sql, new MapHandler()));
}

/**
 * 根据sql查询一个map
 */
public static Map<String, Object> findMap(String sql, Object... params) {
  Map<String, Object> map;
  try {
    logger.debug("Sql:" + sql);
    logger.debug("Parameters:" + Arrays.toString(params));
    map = getQueryRunner().query(getConn(), sql, new MapHandler(), params);
  } catch (SQLException e) {
    throw new QueryException(e);
  }
  return map;
}

private Map<String, Object> executeQuery(String sql, InvokeContext context) {
  Connection connection = null;
  try {
    connection = getConnection(context);
    QueryRunner qr = new QueryRunner();
    Map<String, Object> query = qr.query(connection, sql, new MapHandler());
    if (query == null || query.isEmpty()) {
      query = new LinkedHashMap<>();
      LOG.warn("Select Nothing By SQL:{}", sql);
    }
    return query;
  } catch (Exception e) {
    //
  } finally {
    closeClosable(connection);
  }
  return new LinkedHashMap<>();
}

public long add() throws Exception{
  try {
    if (buildSql_Insert()) {
      Map<String, Object> result_insert = new QueryRunner().insert(conn, sql, new MapHandler(), param_data);
      long id=0;
      if(null!=result_insert && result_insert.containsKey("GENERATED_KEY")) {
        id = (long) result_insert.get("GENERATED_KEY");
      }
      D.autoCloseConn(conn);
      return id;
    }
  } catch (Exception e) {
    D.autoCloseConn(conn);
    throw e;
  }
  return 0;
}

public void testEmptyResultSetHandle() throws SQLException {
  ResultSetHandler<Map<String,Object>> h = new MapHandler();
  Map<String,Object> results = h.handle(this.emptyResultSet);
  assertNull(results);
}

public void testHandle() throws SQLException {
  ResultSetHandler<Map<String,Object>> h = new MapHandler();
  Map<String,Object> results = h.handle(this.rs);
  assertNotNull(results);
  assertEquals(COLS, results.keySet().size());
  assertEquals("1", results.get("ONE"));
  assertEquals("2", results.get("two"));
  assertEquals("THREE", results.get("Three"));
}