From: Felix Dörre <felix@dogcraft.de>
Date: Wed, 23 Jul 2014 01:04:23 +0000 (+0200)
Subject: Add api for adding email addresses.
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=422b2fc3524eb992cc639937cfdabf9eb8d1067a

Add api for adding email addresses.
---

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;
 	}