Changeset 378

Timestamp:

08/12/12 13:12:55 (13 years ago)

Author:

mcichenski

Message:

list application property types

File:

• gssim/trunk/db/gssim/db/mysql/ApplicationPropertyDAO.java (modified) (1 diff)

gssim/trunk/db/gssim/db/mysql/ApplicationPropertyDAO.java

@@ -113 +113 @@
         }
 
+        public List<String> getTypes() throws SQLException {
+
+                String sql = "SELECT * FROM application_property ap GROUP BY ap.key";
+                PreparedStatementAdapter stmt = new PreparedStatementAdapter(this
+                        .getConnection().prepareStatement(sql));
+                
+                List<String> list = new ArrayList<String>();
+
+                ResultSetAdapter result = new ResultSetAdapter(stmt.executeQuery());
+
+                while (result.next()) {
+                        list.add(result.getString("key"));
+                }
+
+                return list;
+        }
+        
         @Override
         public int insert(ApplicationProperty obj, boolean commit) throws SQLException {