jondinham jondinham - 1 year ago 112
SQL Question

How to fetch entire row as array of objects with JDBC

I have to make a 'query' method for my class which accesses MySQL thru' JDBC.

The input parameter to the method is a full SQL command (with values included), so I don't know the names of columns to fetch out.

Some of the columns are strings, some others are integers, etc.

The method needs to return the value of type


where each HashMap is 1 row, and the ArrayList contains all rows of result.

I'm thinking of using
to get the number of columns then fetch cell by cell out of the current row, but is this the only solution? any better ones?

Answer Source

I have the example code here, just in case anybody need it. ('Con' in the code is the standard JDBC connection).

//query a full sql command
public static ArrayList<HashMap<String,Object>> 
rawQuery(String fullCommand) {
  try {

    //create statement
    Statement stm = null;
    stm = con.createStatement();

    ResultSet result = null;
    boolean returningRows = stm.execute(fullCommand);
    if (returningRows)
      result = stm.getResultSet();
      return new ArrayList<HashMap<String,Object>>();

    //get metadata
    ResultSetMetaData meta = null;
    meta = result.getMetaData();

    //get column names
    int colCount = meta.getColumnCount();
    ArrayList<String> cols = new ArrayList<String>();
    for (int index=1; index<=Col_Count; index++)

    //fetch out rows
    ArrayList<HashMap<String,Object>> rows = 
    new ArrayList<HashMap<String,Object>>();

    while ( {
      HashMap<String,Object> row = new HashMap<String,Object>();
      for (String colName:cols) {
        Object val = Result.getObject(colName);

    //close statement

    //pass back rows
    return tows;
  catch (Exception ex) {
    return new ArrayList<HashMap<String,Object>>();
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download