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 // TODO check ownership
41 } catch (GeneralSecurityException e) {
43 } catch (SQLException e) {
46 out.println("</pre>");
50 HashMap<String, Object> vars = new HashMap<String, Object>();
51 User us = LoginPage.getUser(req);
53 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
54 "SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
55 ps.setInt(1, us.getId());
56 ResultSet rs = ps.executeQuery();
57 vars.put("mailcerts", rs);
58 myTable.output(out, getLanguage(req), vars);
60 } catch (SQLException e) {