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) throws IOException {
31 PrintWriter out = resp.getWriter();
32 String pi = req.getPathInfo().substring(PATH.length());
33 if (pi.length() != 0) {
35 int id = Integer.parseInt(pi);
36 Certificate c = new Certificate(id);
37 if (LoginPage.getUser(req).getId() != c.getOwnerId()) {
38 out.println(translate(req, "You do not own this certificate."));
44 } catch (GeneralSecurityException e) {
46 } catch (SQLException e) {
49 out.println("</pre>");
53 HashMap<String, Object> vars = new HashMap<String, Object>();
54 User us = LoginPage.getUser(req);
56 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
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) {