/** * * Method Name : resultSetToArrayList * Description : ResultSet 객체를 한개의 Row가 HashMap인 ArrayList로 변환합니다. * * @author rian_susukang * @param resultSet * @return * @throws SQLException Collection * */ private Collection resultSetToArrayList(ResultSet resultSet) throws SQLException{ ResultSetMetaData metaData = resultSet.getMetaData(); int sizeOfColumn = metaData.getColumnCount(); String[]columnName = new String[metaData.getColumnCount()]; for(int indexOfColumn = 0 ; indexOfColumn < sizeOfColumn ; indexOfColumn++){ columnName[indexOfColumn] = metaData.getColumnName(indexOfColumn + 1); } ArrayList resultList = new ArrayList(); HashMap currentHashMap; while(resultSet.next()){ currentHashMap = new HashMap(); for(int indexOfColumn=0 ; indexOfColumn < sizeOfColumn ; indexOfColumn++){ currentHashMap.put(columnName[indexOfColumn], resultSet.getString(columnName[indexOfColumn])); } resultList.add(currentHashMap); } System.out.println("resultArrayList="+resultList); return resultList; }
Java/[Servlet/JSP]