src/org/cacert/gigi/output/CertificateTable.java

   1 package org.cacert.gigi.output;
   2
   3 import java.io.PrintWriter;
   4 import java.sql.ResultSet;
   5 import java.sql.SQLException;
   6 import java.util.Map;
   7
   8 import org.cacert.gigi.Language;
   9 import org.cacert.gigi.pages.account.MailCertificates;
  10
  11 public class CertificateTable implements Outputable {
  12         String resultSet;
  13
  14         public CertificateTable(String resultSet) {
  15                 this.resultSet = resultSet;
  16         }
  17
  18         private static final String[] columnNames = new String[] { "Renew/Revoke/Delete", "Status", "Email Address",
  19                         "SerialNumber", "Revoked", "Expires", "Login" };
  20
  21         @Override
  22         public void output(PrintWriter out, Language l, Map<String, Object> vars) {
  23                 ResultSet rs = (ResultSet) vars.get(resultSet);
  24                 try {
  25                         out.println("<form method=\"post\">");
  26                         out.println("<table class=\"wrapper dataTable\">");
  27                         out.println("<thead><tr>");
  28                         for (String column : columnNames) {
  29                                 out.print("<td>");
  30                                 out.print(l.getTranslation(column));
  31                                 out.println("</td>");
  32                         }
  33                         out.print("<td colspan=\"2\">");
  34                         out.print(l.getTranslation("Comment *"));
  35                         out.println("</td></tr></thead><tbody>");
  36
  37                         rs.beforeFirst();
  38                         while (rs.next()) {
  39                                 // out.println(rs.getString("id"));
  40                                 out.print("<tr><td>&nbsp;</td><td>State</td><td>");
  41                                 out.println(rs.getString("CN"));
  42                                 out.print("</td><td><a href='");
  43                                 out.print(MailCertificates.PATH);
  44                                 out.print("/");
  45                                 out.print(rs.getString("serial"));
  46                                 out.print("'>");
  47                                 out.println(rs.getString("serial"));
  48                                 out.print("</a></td><td>");
  49                                 if (rs.getString("revoked") == null) {
  50                                         out.println("N/A");
  51                                 } else {
  52                                         out.println(rs.getString("revoked"));
  53                                 }
  54                                 out.print("</td><td>");
  55                                 out.println(rs.getString("expire"));
  56                                 out.println("</td><td>a</td><td>a</td></tr>");
  57                         }
  58                         out.println("</tbody></table>");
  59                 } catch (SQLException e) {
  60                         e.printStackTrace();
  61                 }
  62
  63         }
  64 }