X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FEmailAddress.java;h=646b09550b78d089b5b86756018815fe3366053f;hb=422b2fc3524eb992cc639937cfdabf9eb8d1067a;hp=fda01ed06b69de28005be3555b2760b283a199e7;hpb=5725fc461f2f5d3d767a9d2d445eff96857287a5;p=gigi.git diff --git a/src/org/cacert/gigi/EmailAddress.java b/src/org/cacert/gigi/EmailAddress.java index fda01ed0..646b0955 100644 --- a/src/org/cacert/gigi/EmailAddress.java +++ b/src/org/cacert/gigi/EmailAddress.java @@ -3,14 +3,13 @@ package org.cacert.gigi; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; - import org.cacert.gigi.database.DatabaseConnection; public class EmailAddress { - String address; - int id; - User owner; - String hash = null; + private String address; + private int id; + private User owner; + private String hash = null; private EmailAddress(int id) throws SQLException { PreparedStatement ps = DatabaseConnection.getInstance().prepare( @@ -28,6 +27,29 @@ public class EmailAddress { rs.close(); } + public EmailAddress(String address, User owner, String hash) { + this.address = address; + this.owner = owner; + this.hash = hash; + } + + public void insert() { + if (id != 0) { + throw new IllegalStateException("already inserted."); + } + try { + PreparedStatement ps = DatabaseConnection.getInstance().prepare( + "INSERT INTO `email` SET memid=?, hash=?, email=?"); + ps.setInt(1, owner.getId()); + ps.setString(2, hash); + ps.setString(3, address); + ps.execute(); + id = DatabaseConnection.lastInsertId(ps); + } catch (SQLException e) { + e.printStackTrace(); + } + } + public int getId() { return id; }