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

   1 package org.cacert.gigi.pages.account;
   2
   3 import java.io.IOException;
   4 import java.sql.PreparedStatement;
   5 import java.sql.ResultSet;
   6 import java.sql.SQLException;
   7 import java.util.HashMap;
   8
   9 import javax.servlet.http.HttpServletRequest;
  10 import javax.servlet.http.HttpServletResponse;
  11
  12 import org.cacert.gigi.User;
  13 import org.cacert.gigi.database.DatabaseConnection;
  14 import org.cacert.gigi.output.CertificateTable;
  15 import org.cacert.gigi.pages.LoginPage;
  16 import org.cacert.gigi.pages.Page;
  17
  18 public class MailCertificates extends Page {
  19         CertificateTable myTable = new CertificateTable("mailcerts");
  20         public static final String PATH = "/account/certs/email";
  21
  22         public MailCertificates() {
  23                 super("Email Certificates");
  24         }
  25
  26         @Override
  27         public void doGet(HttpServletRequest req, HttpServletResponse resp)
  28                         throws IOException {
  29                 HashMap<String, Object> vars = new HashMap<String, Object>();
  30                 User us = LoginPage.getUser(req);
  31                 try {
  32                         PreparedStatement ps = DatabaseConnection
  33                                         .getInstance()
  34                                         .prepare(
  35                                                         "SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
  36                         ps.setInt(1, us.getId());
  37                         ResultSet rs = ps.executeQuery();
  38                         vars.put("mailcerts", rs);
  39                         myTable.output(resp.getWriter(), getLanguage(req), vars);
  40                         rs.close();
  41                 } catch (SQLException e) {
  42                         e.printStackTrace();
  43                 }
  44         }
  45
  46 }