- public static void reload() {\r
- Map<String, Integer> m = new HashMap<String, Integer>();\r
- PreparedStatement ps = null;\r
-\r
- try {\r
- DB db = new DB();\r
- @SuppressWarnings("resource")\r
- Connection conn = db.getConnection();\r
- String sql = "select NODEID, NAME from NODES";\r
- ps = conn.prepareStatement(sql);\r
- try(ResultSet rs = ps.executeQuery()) {\r
+ private static void insertNodesToTable(int nextid, String node) {\r
+ DB db = new DB();\r
+ try (Connection conn = db.getConnection()) {\r
+ try (PreparedStatement ps = conn\r
+ .prepareStatement("insert into NODES (NODEID, NAME, ACTIVE) values (?, ?, 1)")) {\r
+ ps.setInt(1, nextid);\r
+ ps.setString(2, node);\r
+ ps.execute();\r
+ } finally {\r
+ db.release(conn);\r
+ }\r
+ } catch (SQLException e) {\r
+ intLogger.error(PROV_0005_DO_INSERT + e.getMessage(), e);\r
+ }\r
+ }\r
+\r
+ private static void reload() {\r
+ Map<String, Integer> hmap = new HashMap<>();\r
+ String sql = "select NODEID, NAME from NODES";\r
+ DB db = new DB();\r
+ try (Connection conn = db.getConnection();\r
+ PreparedStatement ps = conn.prepareStatement(sql)) {\r
+ try (ResultSet rs = ps.executeQuery()) {\r