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)
  31                         throws IOException {
  32                 PrintWriter out = resp.getWriter();
  33                 String pi = req.getPathInfo().substring(PATH.length());
  34                 if (pi.length() != 0) {
  35                         pi = pi.substring(1);
  36                         int id = Integer.parseInt(pi);
  37                         Certificate c = new Certificate(id);
  38                         // TODO check ownership
  39                         out.println("<pre>");
  40                         try {
  41                                 out.print(c.cert());
  42                         } catch (GeneralSecurityException e) {
  43                                 e.printStackTrace();
  44                         } catch (SQLException e) {
  45                                 e.printStackTrace();
  46                         }
  47                         out.println("</pre>");
  48                         return;
  49                 }
  50
  51                 HashMap<String, Object> vars = new HashMap<String, Object>();
  52                 User us = LoginPage.getUser(req);
  53                 try {
  54                         PreparedStatement ps = DatabaseConnection
  55                                         .getInstance()
  56                                         .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);
  62                         rs.close();
  63                 } catch (SQLException e) {
  64                         e.printStackTrace();
  65                 }
  66         }
  67
  68 }