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.CertificateTable;
15 import org.cacert.gigi.pages.LoginPage;
16 import org.cacert.gigi.pages.Page;
18 public class MailCertificates extends Page {
19 CertificateTable myTable = new CertificateTable("mailcerts");
20 public static final String PATH = "/account/certs/email";
22 public MailCertificates() {
23 super("Email Certificates");
27 public void doGet(HttpServletRequest req, HttpServletResponse resp)
29 HashMap<String, Object> vars = new HashMap<String, Object>();
30 User us = LoginPage.getUser(req);
32 PreparedStatement ps = DatabaseConnection
35 "SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
36 ps.setInt(1, us.getId());
37 ResultSet rs = ps.executeQuery();
38 vars.put("mailcerts", rs);
39 myTable.output(resp.getWriter(), getLanguage(req), vars);
41 } catch (SQLException e) {