src/org/cacert/gigi/pages/account/MailCertificates.java

   1 package org.cacert.gigi.pages.account;
   2
   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;
  10
  11 import javax.servlet.http.HttpServletRequest;
  12 import javax.servlet.http.HttpServletResponse;
  13
  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;
  20
  21 public class MailCertificates extends Page {
  22         CertificateTable myTable = new CertificateTable("mailcerts");
  23         public static final String PATH = "/account/certs/email";
  24
  25         public MailCertificates() {
  26                 super("Email Certificates");
  27         }
  28
  29         @Override
  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) {
  34                         pi = pi.substring(1);
  35                         int id = Integer.parseInt(pi);
  36                         Certificate c = new Certificate(id);
  37                         // TODO check ownership
  38                         out.println("<pre>");
  39                         try {
  40                                 out.print(c.cert());
  41                         } catch (GeneralSecurityException e) {
  42                                 e.printStackTrace();
  43                         } catch (SQLException e) {
  44                                 e.printStackTrace();
  45                         }
  46                         out.println("</pre>");
  47                         return;
  48                 }
  49
  50                 HashMap<String, Object> vars = new HashMap<String, Object>();
  51                 User us = LoginPage.getUser(req);
  52                 try {
  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);
  59                         rs.close();
  60                 } catch (SQLException e) {
  61                         e.printStackTrace();
  62                 }
  63         }
  64
  65 }