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