[ACCEPTED]-How to convert ResultSet into Object[] and retrieve the data-jdbc
Accepted answer
For whatever weird reasons you need this. Here 8 is how:
List<object[]> records=new ArrayList<object[]>();
while(resultSet.next()){
int cols = resultSet.getMetaData().getColumnCount();
Object[] arr = new Object[cols];
for(int i=0; i<cols; i++){
arr[i] = resultSet.getObject(i+1);
}
records.add(arr);
}
My 2 cents:
Ideally, you will have an proper 7 object that maps Table columns to Java object 6 fields. Instead of using an array of objects, you 5 will set the properties to the POJO or Value 4 Object (VO) and return the list of object. That 3 is much simpler and makes more sense. You 2 may want to revisit your design if you have 1 to live on list of Object array!
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.