ArrayList<Object> notice = new ArrayList<>();
try {
Connection conn = DriverManager.getConnection(JDBC + connectionURL);
- PreparedStatement st = conn.prepareStatement("SELECT * FROM legalnotices WHERE id=?;");
+ PreparedStatement st = conn.prepareStatement("SELECT legalnotices.*, clients.ClientName "
+ + "FROM legalnotices "
+ + "INNER JOIN clients WHERE ClientId=clients.id AND legalnotices.id=?;");
st.setInt(1, selid);
ResultSet rs = st.executeQuery();
while (rs.next()) {
notice.add (getValidDate (rs, "BillDate"));
notice.add (rs.getBoolean ("ClarificationPending"));
notice.add (rs.getString("ClarificationRemarks"));
+ notice.add (rs.getString("ClientName"));
}
return notice;
} catch (SQLException ex) {
return false;
}
+ }
+
+ static boolean deleteNotice(int r) {
+ try {
+ Connection conn = DriverManager.getConnection(JDBC + connectionURL);
+ PreparedStatement st = conn.prepareStatement("DELETE FROM legalnotices"
+ + " WHERE id=?;");
+ st.setInt(1, r);
+ st.execute();
+ conn.close();
+ return true;
+ } catch (SQLException ex) {
+ Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+ return false;
+ }
+
}
public Utility () {