JDBC records retrieve in primitive type as 2D array to be store in excel
I am coding an application to export data from database to excel file using JExcelAPI.
Using the ResultSetMetaData class I am able to get the java.sql.Types of the columns. I used switch statement to convert the data to Objects.
example:
switch (type)
case Types.INTEGER// Wrap with Integer class
// al other types...
than store as Object[][] to be written to excel for convenience as excel use columns, row for their cells value.
Is there any other way I can detect the column type and wrap it with the appropriate class?

