+ }
+
+ static ArrayList<Object> getNotices() {
+ ArrayList<Object> notices = new ArrayList<>();
+ try {
+ Connection conn = DriverManager.getConnection("jdbc:sqlite:" + connectionURL);
+ Statement st = conn.createStatement();
+ ResultSet rs = st.executeQuery("SELECT id, ReferenceNumber, Description "
+ + "FROM legalnotices;");
+ while (rs.next()) {
+ notices.add(rs.getInt("id"));
+ notices.add(rs.getString("ReferenceNumber"));
+ notices.add(rs.getString("Description"));
+ }
+ conn.close();
+ return notices;
+ } catch (SQLException ex) {
+ Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+ return null;
+ }
+