package dao; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.util.ArrayList; import java.util.HashMap; import java.util.List; public class ResultObject { private final List> data = new ArrayList<>(); public ResultObject(ResultSet rs) throws SQLException { ResultSetMetaData metaData = rs.getMetaData(); int columnCount = metaData.getColumnCount(); while(rs.next()) { HashMap row = new HashMap<>(); for (int i = 1; i <= columnCount; i++) { row.put(metaData.getColumnName(i), rs.getObject(i)); } data.add(row); } // rs.close(); // rs.getStatement().close(); // rs.getStatement().getConnection().close(); } public List> getData() { return data; } }