Changeset 3057

Timestamp:

07/08/08 14:52:47 (5 years ago)

Author:

awwalter

Message:

added method to get list of application name strings from the db applications table

File:

• PP/trunk/jungle/src/org/trinet/jasi/JasiDbReader.java (modified) (1 diff)

PP/trunk/jungle/src/org/trinet/jasi/JasiDbReader.java

@@ -205 +205 @@
         return count;
     }
+
+    /**
+     * Return a list of program application names known by DataSource.
+     * Empty list if none
+     */
+    public static java.util.List getApplicationNames(Connection conn) {
+      Statement sm = null;
+      ResultSet rs = null;
+      ArrayList aList = new ArrayList();
+      try {
+        if ( conn == null || conn.isClosed() ) {
+          System.err.println ("JasiDbReader getBySQL(c,s) connection c is closed");
+          return null;
+        }
+        sm = conn.createStatement();
+        // NOTE: if ExecuteSQL.setSelectForUpdate(true) was set in DataSource
+        // this will lock the selected rows until commit() or close() are called
+        String sql = "SELECT DISTINCT name FROM applications ORDER BY name";
+        ResultSetDb rsdb = new ResultSetDb(ExecuteSQL.rowQuery(sm, sql));
+        rs = rsdb.getResultSet();
+        if (rs != null) {
+          String name = null;
+          while ( rs.next() ) {
+            name = rs.getString(1);
+            if (name != null) aList.add(rs.getString(1));
+          }
+        }
+      }
+      catch (SQLException ex) {
+        System.err.println(ex);
+        ex.printStackTrace();
+      }
+      finally {
+          try {
+            if (rs != null) rs.close();
+            if (sm != null) sm.close();
+          }
+          catch (SQLException ex) {}
+      }
+      return aList;
+    }
+
 
     /**