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.LinkedList;
   7 import java.util.Map;
   8
   9 import org.cacert.gigi.Language;
  10 import org.cacert.gigi.output.DataTable.Cell;
  11
  12 public class CertificateTable implements Outputable {
  13         String resultSet;
  14         public CertificateTable(String resultSet) {
  15                 this.resultSet = resultSet;
  16         }
  17
  18         @Override
  19         public void output(PrintWriter out, Language l, Map<String, Object> vars) {
  20                 ResultSet rs = (ResultSet) vars.get(resultSet);
  21                 try {
  22                         out.println("<form method=\"post\" action=\"account.php\">");
  23                         final LinkedList<Cell> cells = new LinkedList<>();
  24                         cells.add(new Cell("Renew/Revoke/Delete", true));
  25                         cells.add(new Cell("Status", true));
  26                         cells.add(new Cell("Email Address", true));
  27                         cells.add(new Cell("SerialNumber", true));
  28                         cells.add(new Cell("Revoked", true));
  29                         cells.add(new Cell("Expires", true));
  30                         cells.add(new Cell("Login", true));
  31                         cells.add(new Cell("Comment *", true, 2));
  32                         rs.beforeFirst();
  33                         while (rs.next()) {
  34                                 // out.println(rs.getString("id"));
  35                                 cells.add(new Cell());
  36                                 cells.add(new Cell("State", false));
  37                                 cells.add(new Cell(rs.getString("CN"), false));
  38                                 cells.add(new Cell(rs.getString("serial"), false));
  39                                 if (rs.getString("revoked") == null) {
  40                                         cells.add(new Cell("N/A", false));
  41                                 } else {
  42                                         cells.add(new Cell(rs.getString("revoked"), false));
  43                                 }
  44                                 cells.add(new Cell(rs.getString("expire"), false));
  45                                 cells.add(new Cell(rs.getString("a"), false));
  46                                 cells.add(new Cell(rs.getString("a"), false));
  47                         }
  48                         DataTable t = new DataTable(9, cells);
  49                         t.output(out, l, vars);
  50                         out.println("</form>");
  51                 } catch (SQLException e) {
  52                         e.printStackTrace();
  53                 }
  54
  55         }
  56 }