Added mailOverview (form dummy)

[gigi.git] / src / org / cacert / gigi / pages / account / MailOverview.java

diff --git a/src/org/cacert/gigi/pages/account/MailOverview.java b/src/org/cacert/gigi/pages/account/MailOverview.java
index f165cc10b09b1de21b259066883170824809f2e9..edc88c9477b18fb3cdd49abd7577dcd529219ec6 100644 (file)
--- 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);
 
        }