/**
*
* 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]