src/org/cacert/gigi/pages/account/MailOverview.java

   1 package org.cacert.gigi.pages.account;
   2
   3 import java.io.IOException;
   4 import java.sql.PreparedStatement;
   5 import java.sql.ResultSet;
   6 import java.sql.SQLException;
   7 import java.util.HashMap;
   8
   9 import javax.servlet.http.HttpServletRequest;
  10 import javax.servlet.http.HttpServletResponse;
  11
  12 import org.cacert.gigi.User;
  13 import org.cacert.gigi.database.DatabaseConnection;
  14 import org.cacert.gigi.output.MailTable;
  15 import org.cacert.gigi.pages.LoginPage;
  16 import org.cacert.gigi.pages.Page;
  17
  18 public class MailOverview extends Page {
  19         public static final String DEFAULT_PATH = "/account/mails";
  20         private MailTable table = new MailTable("mails", "userMail");
  21         public MailOverview(String title) {
  22                 super(title);
  23         }
  24
  25         @Override
  26         public void doGet(HttpServletRequest req, HttpServletResponse resp)
  27                         throws IOException {
  28                 HashMap<String, Object> vars = new HashMap<String, Object>();
  29                 User us = LoginPage.getUser(req);
  30                 int id = us.getId();
  31                 try {
  32                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  33                                         "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
  34                         ps.setInt(1, id);
  35                         ResultSet rs = ps.executeQuery();
  36                         vars.put("mails", rs);
  37                         vars.put("userMail", us.getEmail());
  38
  39                 } catch (SQLException e) {
  40                         e.printStackTrace();
  41                 }
  42                 table.output(resp.getWriter(), getLanguage(req), vars);
  43
  44         }
  45
  46 }