Skip to main content

How to convert a Java Object List into csv.

Wrote a general method to convert a List into a CSV file.



package com.biplav.utils



import java.lang.reflect.Field;

import java.lang.reflect.Modifier;

import java.util.ArrayList;

import java.util.List;



import org.apache.log4j.Logger;



public class ObjectListToCSV {



private static final Logger logger = Logger.getLogger(ObjectListToCSV.class);

private static final String CSV_SEPARATOR = ",";



public static  String convertListToCSV(List objectList) {
  if(objectList.size() < 1) {
   logger.info("No data in the list to convert to CDR!");
   return "";
  }
  String csv = "";
  T t = objectList.get(0);
  Field[] declaredFields = t.getClass().getDeclaredFields();
  ArrayList useableFields = getUseableFields(declaredFields);
  csv = getCSVHeader(csv, useableFields,null);
  csv=csv.concat("\n");
  for(T object : objectList) {
   csv = addObjectValue(csv, useableFields, object);
   csv=csv.concat("\n");
  }
  return csv;
 }

 private static  String addObjectValue(String csv,
   ArrayList useableFields, T object) {
  for(Field field : useableFields) {
   try {
    if(canFieldUsedDirectly(field)) {
     if(object != null) {
      field.setAccessible(true);
      Object value = field.get(object);
      csv=csv.concat(value +"");
      field.setAccessible(false);
     }
    } else {
     if(object != null) {
      field.setAccessible(true);
      Object value = field.get(object);
      field.setAccessible(false);
      csv = addObjectValue(csv, getUseableFields(field.getType().getDeclaredFields()), value);
     }
    }
   } catch (IllegalArgumentException e) {
    logger.error(e);
   } catch (SecurityException e) {
    logger.error(e);
   } catch (IllegalAccessException e) {
    logger.error(e);
   }
   csv=csv.concat(CSV_SEPARATOR);
  }
  return csv;
 }

 private static boolean canFieldUsedDirectly(Field field) {
  return !field.getType().toString().contains("biplav");
 }

 private static ArrayList getUseableFields(Field[] declaredFields) {
  ArrayList useableFields = new ArrayList();
  for(Field field: declaredFields) {
   if(!Modifier.isStatic(field.getModifiers())) {
     useableFields.add(field);
   }
  }
  return useableFields;
 }

 private static String getCSVHeader(String csv, ArrayList useableFields,String prefix) {
  prefix = (prefix == null) ?  "": prefix;
  for(Field field : useableFields) {
   if(canFieldUsedDirectly(field)) {
    csv=csv.concat(prefix+field.getName());
    csv=csv.concat(CSV_SEPARATOR);
   } else {
    csv = getCSVHeader(csv, getUseableFields(field.getType().getDeclaredFields()),field.getName()+"_");
   }
  }
  return csv;
 }
}

Popular posts from this blog

Watch Live cam on Google!!!!!

Ahhh!!! type certain string in google search bar above and it would bring up the network live cam into your browser. These can be anything from CCTV or webcams... There are lots of string.. i suggest a few down below use them to begin with.. And do come up with your own.. and leave a comment to the post... And ya.. if u come up with something interesting then don forget to share it.. Strings::: Axis cameras: "adding live video to one of your own pages a very easy task with an AXIS 2100 Network Camera" ' google ' intile:"Live view - / - AXIS" ' google ' "Your browser has JavaScript turned off.For the user interface to work effectively" ' google ' inurl:indexFrame.html axis ' google ' "Live web imaging unleashed" ' google ' MOBOTIX cameras: (intext:"MOBOTIX M1" | intext:"MOBOTIX M10") intext:"Open Menu" Shift-Reload ' google ' JVC cameras: "(c)copyright 199...

Problems with mysql.sock

Sometimes while working on Linux, mysql.sock may get deleted by mistake due to some softwares.. in such cases any access to mysql wont be possible as the sock file defines the socket connection for mysql. It will give an error of the following type: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In such cases follow these steps to reconfigure mysql: Delete the log files with the names: ib_logfile0, ib_logfile1 and ibdata1 in the /var/lib/mysql directory Then type: "mysqld_safe --user=mysql &" This will automatically create mysql.sock file and even the new logs files. This is a very simple solution which I used recently and decided to share with you people.

Universal Xp serial key

The key given below is the universal serial key for Windows Xp.. It can by pass any windows xp cd and make your copy genuine. Do try it!!! V2C47-MK7JD-3R89F-D2KXW-VPK3J