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