1 package org.cacert.gigi.pages.account;
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;
9 import javax.servlet.http.HttpServletRequest;
10 import javax.servlet.http.HttpServletResponse;
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;
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) {
26 public void doGet(HttpServletRequest req, HttpServletResponse resp)
28 HashMap<String, Object> vars = new HashMap<String, Object>();
29 User us = LoginPage.getUser(req);
32 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
33 "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
35 ResultSet rs = ps.executeQuery();
36 vars.put("mails", rs);
37 vars.put("userMail", us.getEmail());
39 } catch (SQLException e) {
42 table.output(resp.getWriter(), getLanguage(req), vars);