import java.util.ArrayList;
import java.util.prefs.Preferences;
import java.sql.*;
-import java.util.Dictionary;
-import java.util.HashMap;
import java.util.logging.Level;
import java.util.logging.Logger;
-import javax.swing.JOptionPane;
/**
*
}
+ }
+
+ static boolean addLegalNotice(String reference_number,
+ String description, java.util.Date entrustment_date, DBItem client) {
+ if ("".equals(reference_number) || "".equals(description) ||
+ entrustment_date == null)
+ return false;
+ try {
+ Connection conn = DriverManager.getConnection("jdbc:sqlite:" + connectionURL);
+ PreparedStatement st = conn.prepareStatement("INSERT INTO legalnotices"
+ + " (ReferenceNumber, Description, EntrustmentDate, ClientId) "
+ + "VALUES (?, ?, ?, ?);");
+ st.setString(1, reference_number);
+ st.setString(2, description);
+ st.setLong(3, entrustment_date.getTime()/1000);
+ st.setInt (4, client.getKey());
+ st.execute();
+ conn.close();
+ return true;
+
+ } catch (SQLException ex) {
+ Logger.getLogger(Utility.class.getName()).log(Level.SEVERE, null, ex);
+ return false;
+ }
+
}
public Utility () {