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