Advertisement
Guest User

Untitled

a guest
Sep 21st, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. private List<Map<String, String>> resultsetToMap(ResultSet resultObject) throws SQLException {
  2. List<Map<String, String>> keyAndFields = new ArrayList<>();
  3. if (resultObject == null) {
  4. return null;
  5. }
  6. while (resultObject.next()) {
  7. Map<String, String> columnNameAndFields = new HashMap<>();
  8. int counter = 1;
  9. while (counter <= resultObject.getMetaData().getColumnCount()) {
  10. String columnName = resultObject.getMetaData().getColumnLabel(counter);
  11. String value = String.valueOf(resultObject.getObject(counter));
  12. columnNameAndFields.put(columnName, value);
  13. counter++;
  14. }
  15. keyAndFields.add(columnNameAndFields);
  16. }
  17. return keyAndFields;
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement