Java Utililty Methods SQL ResultSet to

switch (sqlType) {
case Types.ARRAY:
    return rs.getArray(name);
case Types.BIGINT:
    return rs.getLong(name);
case Types.BINARY:
case Types.LONGVARBINARY:
case Types.VARBINARY:
...

ResultSetMetaData rsmd = rs.getMetaData();
List<Map<String, Object>> res = new ArrayList<Map<String, Object>>();
while (rs.next()) {
    int numColumns = rsmd.getColumnCount();
    Map<String, Object> obj = new HashMap<String, Object>();
    for (int i = 1; i < numColumns + 1; i++) {
        String column_name = rsmd.getColumnName(i).toLowerCase();
        if (rsmd.getColumnType(i) == java.sql.Types.ARRAY) {
...

JSONArray jsonArray = new JSONArray();
if (resultSet != null) {
    while (resultSet.next()) {
        int total_rows = resultSet.getMetaData().getColumnCount();
        JSONObject obj = new JSONObject();
        for (int i = 0; i < total_rows; i++) {
            int colNextIndex = i + 1;
            obj.put(resultSet.getMetaData().getColumnLabel(colNextIndex).toLowerCase(),
...

try {
    ResultSetMetaData metaData = rs.getMetaData();
    int colum = metaData.getColumnCount();
    Collection<Map<String, Object>> collection = new ArrayList<Map<String, Object>>();
    Map<String, Object> row = null;
    while (rs.next()) {
        row = new HashMap<String, Object>();
        for (int i = 0; i < colum; i++)
...

fillRowNames(metaData, rs);
Map<String, Object> row = new HashMap<String, Object>();
for (Map.Entry<String, Integer> entry : metaData.entrySet()) {
    Object value = null;
    if (Types.DATE == entry.getValue()) {
        value = formartDate(rs.getDate(entry.getKey()));
    } else if (Types.TIMESTAMP == entry.getValue()) {
        value = formartDateTime(rs.getTimestamp(entry.getKey()));
...

List<Map<String, Object>> list = null;
if (rs != null) {
    list = new ArrayList<Map<String, Object>>();
    try {
        while (rs.next()) {
            Map<String, Object> map = resultSet2Map(rs);
            if (map != null && map.size() > 0) {
                list.add(map);
...

Map<String, Object> map = null;
if (rs != null) {
    map = new HashMap<String, Object>();
    try {
        ResultSetMetaData rsMetaData = rs.getMetaData();
        int columnCount = rsMetaData.getColumnCount();
        for (int i = 1; i <= columnCount; i++) {
            String cName = rsMetaData.getColumnLabel(i);
...

StringBuilder sb = new StringBuilder();
ResultSetMetaData rsmd = rsh.getMetaData();
int numColumns = rsmd.getColumnCount();
String colName1 = rsmd.getColumnName(1).replace("\"", "").replace(",", "").trim();
colName1 = colName1.substring(0, 1).toUpperCase() + ((colName1.length() > 0) ? colName1.substring(1) : "");
String colNames = "\"" + colName1 + "\"";
for (int i = 2; i < numColumns + 1; i++) {
    String colName = rsmd.getColumnName(i).replace("\"", "").replace(",", "").trim();
...

ResultSetMetaData metaData = rs.getMetaData();
StringBuilder column = new StringBuilder();
int columns = metaData.getColumnCount();
StringBuilder sb = new StringBuilder();
for (int i = 1; i <= columns; i++) {
    column.setLength(0);
    if (i > 1) {
        sb.append(" | ");
...

Object obj = cls.newInstance();
Field[] fs = cls.getDeclaredFields();
for (Field field : fs) {
    String name = field.getName();
    String value = rs.getString(rs.findColumn(name));
    field.set(obj, value);
return obj;
...