src/dao/ResultObject.java


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

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<HashMap<String, Object>> data = new ArrayList<>();

    public ResultObject(ResultSet rs) throws SQLException
    {
        ResultSetMetaData metaData = rs.getMetaData();
        int columnCount = metaData.getColumnCount();

        while(rs.next())
        {
            HashMap<String, Object> 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<HashMap<String, Object>> getData()
    {
        return data;
    }
}