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

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