Changeset 166

Timestamp:

11/23/07 09:01:47 (1 year ago)

Author:

chris

Message:

Add getColumnAsArray and getColumnAsList convenience methods.

Files:

• lex/trunk/src/com/qwirx/db/sql/SqlDatabase.java (modified) (2 diffs)

lex/trunk/src/com/qwirx/db/sql/SqlDatabase.java

@@ -12 +12 @@
-import java.sql.SQLException;
-import java.util.ArrayList;
+import java.util.Iterator;
-import java.util.List;
-
@@ -224 +225 @@
-            return results;
-        }
+
+    /**
+     * Returns the first column of the results of a query as an array of Strings.
+     * @param query the SQL query whose results will be returned in the List
+     * @return a List of Strings from the first columns of the results.
+     * @throws DatabaseException
+     * @throws SQLException
+     */
+    public String [] getColumnAsArray(String query)
+    throws DatabaseException, SQLException
+    {
+        List list = getColumnAsList(query);
+        String [] array = new String [list.size()];
+        
+        int index = 0;
+        for (Iterator it = list.iterator(); it.hasNext();)
+        {
+            array[index++] = (String)it.next();
+        }
+        
+        return array;
+    }
-    
+    /**
+     * Returns the first column of the results of a query as a List of Strings.
+     * @param query the SQL query whose results will be returned in the List
+     * @return a List of Strings from the first columns of the results.
+     * @throws DatabaseException
+     * @throws SQLException
+     */
+    public List getColumnAsList(String query)
+    throws DatabaseException, SQLException
+    {
+        List results = new ArrayList();
+        prepareSelect(query);
+        ResultSet rs = select();
+        
+        while (rs.next())
+        {
+            results.add(rs.getString(1));
+        }
+        
+        finish();
+        return results;
+    }
+
-    /**
-     * Ugly hack replacement for ResultSet.getString() because