X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fpages%2Faccount%2FMailOverview.java;h=edc88c9477b18fb3cdd49abd7577dcd529219ec6;hp=f165cc10b09b1de21b259066883170824809f2e9;hb=7dec4cb4c324be3a48072b615ab0e30d6fd62ec2;hpb=6dd543c2f2c7e585a1e97f9db6b933fac46406eb

diff --git a/src/org/cacert/gigi/pages/account/MailOverview.java b/src/org/cacert/gigi/pages/account/MailOverview.java
index f165cc10..edc88c94 100644
--- a/src/org/cacert/gigi/pages/account/MailOverview.java
+++ b/src/org/cacert/gigi/pages/account/MailOverview.java
@@ -1,17 +1,23 @@
 package org.cacert.gigi.pages.account;
 
 import java.io.IOException;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
 import java.util.HashMap;
 
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 
+import org.cacert.gigi.User;
+import org.cacert.gigi.database.DatabaseConnection;
 import org.cacert.gigi.output.MailTable;
+import org.cacert.gigi.pages.LoginPage;
 import org.cacert.gigi.pages.Page;
 
 public class MailOverview extends Page {
 	public static final String DEFAULT_PATH = "/account/mails";
-
+	private MailTable table = new MailTable("mails", "userMail");
 	public MailOverview(String title) {
 		super(title);
 	}
@@ -20,8 +26,20 @@ public class MailOverview extends Page {
 	public void doGet(HttpServletRequest req, HttpServletResponse resp)
 			throws IOException {
 		HashMap<String, Object> vars = new HashMap<String, Object>();
-
-		new MailTable().output(resp.getWriter(), getLanguage(req), vars);
+		User us = LoginPage.getUser(req);
+		int id = us.getId();
+		try {
+			PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+					"SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
+			ps.setInt(1, id);
+			ResultSet rs = ps.executeQuery();
+			vars.put("mails", rs);
+			vars.put("userMail", us.getEmail());
+
+		} catch (SQLException e) {
+			e.printStackTrace();
+		}
+		table.output(resp.getWriter(), getLanguage(req), vars);
 
 	}