+ /**\r
+ * Get a set of all Network Routes in the DB. The set is sorted according to the natural sorting order of the\r
+ * routes (based on the from and to node names in each route).\r
+ *\r
+ * @return the sorted set\r
+ */\r
+ public static SortedSet<NetworkRoute> getAllNetworkRoutes() {\r
+ SortedSet<NetworkRoute> set = new TreeSet<>();\r
+ try {\r
+ DB db = new DB();\r
+ @SuppressWarnings("resource")\r
+ Connection conn = db.getConnection();\r
+ try (Statement stmt = conn.createStatement()) {\r
+ try (ResultSet rs = stmt.executeQuery("select FROMNODE, TONODE, VIANODE from NETWORK_ROUTES")) {\r
+ addNetworkRouteToSet(set, rs);\r
+ }\r
+ } finally {\r
+ db.release(conn);\r
+ }\r
+ } catch (SQLException e) {\r
+ intlogger.error(SQLEXCEPTION + e.getMessage(), e);\r
+ }\r
+ return set;\r
+ }\r
+\r
+ private static void addNetworkRouteToSet(SortedSet<NetworkRoute> set, ResultSet rs) throws SQLException {\r
+ while (rs.next()) {\r
+ int fromnode = rs.getInt("FROMNODE");\r
+ int tonode = rs.getInt("TONODE");\r
+ int vianode = rs.getInt("VIANODE");\r
+ set.add(new NetworkRoute(fromnode, tonode, vianode));\r
+ }\r
+ }\r
+\r