1 package org.cacert.gigi.pages.account;
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;
10 import javax.servlet.http.HttpServletRequest;
11 import javax.servlet.http.HttpServletResponse;
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;
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) {
28 public void doGet(HttpServletRequest req, HttpServletResponse resp)
30 HashMap<String, Object> vars = new HashMap<String, Object>();
31 User us = LoginPage.getUser(req);
34 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
35 "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
37 ResultSet rs = ps.executeQuery();
38 vars.put("mails", rs);
39 vars.put("userMail", us.getEmail());
41 } catch (SQLException e) {
44 Language language = getLanguage(req);
45 table.output(resp.getWriter(), language, vars);
46 PrintWriter wri = resp.getWriter();
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."));