import java.util.Calendar;
import org.cacert.gigi.database.DatabaseConnection;
-import org.cacert.gigi.util.Notary;
import org.cacert.gigi.localisation.Language;
+import org.cacert.gigi.util.Notary;
import org.cacert.gigi.util.PasswordHash;
import org.cacert.gigi.util.PasswordStrengthChecker;
public Language getPrefferedLanguage() {
return Language.getInstance("de");
}
+
+ public boolean wantsDirectoryListing() throws SQLException {
+ PreparedStatement get = DatabaseConnection.getInstance().prepare("SELECT listme FROM users WHERE id=?");
+ get.setInt(1, getId());
+ ResultSet exec = get.executeQuery();
+ exec.next();
+ return exec.getBoolean("listme");
+ }
+
+ public String getContactInformation() throws SQLException {
+ PreparedStatement get = DatabaseConnection.getInstance().prepare("SELECT contactinfo FROM users WHERE id=?");
+ get.setInt(1, getId());
+ ResultSet exec = get.executeQuery();
+ exec.next();
+ return exec.getString("contactinfo");
+ }
+
+ public void setDirectoryListing(boolean on) throws SQLException {
+ PreparedStatement update = DatabaseConnection.getInstance().prepare("UPDATE users SET listme = ? WHERE id = ?");
+ update.setBoolean(1, on);
+ update.setInt(2, getId());
+ update.executeUpdate();
+ }
+
+ public void setContactInformation(String contactInfo) throws SQLException {
+ PreparedStatement update = DatabaseConnection.getInstance().prepare("UPDATE users SET contactinfo = ? WHERE id = ?");
+ update.setString(1, contactInfo);
+ update.setInt(2, getId());
+ update.executeUpdate();
+ }
}