본문 바로가기

Java/[Servlet/JSP]

ResultSet to ArrayList

 /**
  *
  * 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;
 }