- try( PreparedStatement ps2 = conn.prepareStatement(SELECT_SQL2)) {\r
- ps2.setLong(1, from);\r
- ps2.setLong(2, to);\r
- try(ResultSet rs2 = ps2.executeQuery()) {\r
- while (rs2.next()) {\r
- String date = rs2.getString("DATE");\r
- int sub = rs2.getInt("DELIVERY_SUBID");\r
- int count = rs2.getInt("COUNT");\r
- String key = date + "," + sub;\r
- Counters c = map.get(key);\r
- if (c == null) {\r
- c = new Counters(date, sub);\r
- map.put(key, c);\r
- }\r
- c.addDlxCount(count);\r
- }\r
- }\r
- }\r
-\r
- db.release(conn);\r
+ try( PreparedStatement ps2 = conn.prepareStatement(SELECT_SQL2)) {\r
+ ps2.setLong(1, from);\r
+ ps2.setLong(2, to);\r
+ try (ResultSet rs2 = ps2.executeQuery()) {\r
+ while (rs2.next()) {\r
+ String date = rs2.getString("DATE");\r
+ int sub = rs2.getInt("DELIVERY_SUBID");\r
+ int count = rs2.getInt("COUNT");\r
+ String key = date + "," + sub;\r
+ Counters c = map.get(key);\r
+ if (c == null) {\r
+ c = new Counters(date, sub);\r
+ map.put(key, c);\r
+ }\r
+ c.addDlxCount(count);\r
+ }\r
+ }\r
+ }\r