1 package org.cacert.gigi.pages.account;
3 import java.io.IOException;
4 import java.io.PrintWriter;
5 import java.security.GeneralSecurityException;
6 import java.sql.PreparedStatement;
7 import java.sql.ResultSet;
8 import java.sql.SQLException;
9 import java.util.HashMap;
11 import javax.servlet.http.HttpServletRequest;
12 import javax.servlet.http.HttpServletResponse;
14 import org.cacert.gigi.Certificate;
15 import org.cacert.gigi.User;
16 import org.cacert.gigi.database.DatabaseConnection;
17 import org.cacert.gigi.output.CertificateTable;
18 import org.cacert.gigi.pages.LoginPage;
19 import org.cacert.gigi.pages.Page;
21 public class MailCertificates extends Page {
22 CertificateTable myTable = new CertificateTable("mailcerts");
23 public static final String PATH = "/account/certs/email";
25 public MailCertificates() {
26 super("Email Certificates");
30 public void doGet(HttpServletRequest req, HttpServletResponse resp)
32 PrintWriter out = resp.getWriter();
33 String pi = req.getPathInfo().substring(PATH.length());
34 if (pi.length() != 0) {
36 int id = Integer.parseInt(pi);
37 Certificate c = new Certificate(id);
38 // TODO check ownership
42 } catch (GeneralSecurityException e) {
44 } catch (SQLException e) {
47 out.println("</pre>");
51 HashMap<String, Object> vars = new HashMap<String, Object>();
52 User us = LoginPage.getUser(req);
54 PreparedStatement ps = DatabaseConnection
57 "SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
58 ps.setInt(1, us.getId());
59 ResultSet rs = ps.executeQuery();
60 vars.put("mailcerts", rs);
61 myTable.output(out, getLanguage(req), vars);
63 } catch (SQLException e) {