converting database data to json object java

Thoughtless Tamarin answered on August 7, 2023 Popularity 2/10 Helpfulness 1/10

answer converting database data to json object java

converting database data to json object java

Comment

ResultSetMetaData md = resultSet.getMetaData();
int numCols = md.getColumnCount();
List<String> colNames = IntStream.range(0, numCols)
  .mapToObj(i -> {
      try {
          return md.getColumnName(i + 1);
      } catch (SQLException e) {
          e.printStackTrace();
          return "?";
      }
  })
  .collect(Collectors.toList());

JSONArray result = new JSONArray();
while (resultSet.next()) {
    JSONObject row = new JSONObject();
    colNames.forEach(cn -> {
        try {
            row.put(cn, resultSet.getObject(cn));
        } catch (JSONException | SQLException e) {
            e.printStackTrace();
        }
    });
    result.add(row);
}
Copy

Popularity 2/10 Helpfulness 1/10 Language javascript

Source: www.baeldung.com

Tags: database java javascript object to-json

Link to this answer
Share Copy Link

Contributed on Aug 07 2023

Thoughtless Tamarin

0 Answers Avg Quality 2/10

converting database data to json object java

Contents

More Related Answers

converting database data to json object java

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.