Implement prititive "show email certificates"

[gigi.git] / src / org / cacert / gigi / pages / account / MailCertificates.java

diff --git a/src/org/cacert/gigi/pages/account/MailCertificates.java b/src/org/cacert/gigi/pages/account/MailCertificates.java
new file mode 100644 (file)
index 0000000..72952d4
--- /dev/null
+++ b/src/org/cacert/gigi/pages/account/MailCertificates.java
@@ -0,0 +1,46 @@
+package org.cacert.gigi.pages.account;
+
+import java.io.IOException;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.HashMap;
+
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.cacert.gigi.User;
+import org.cacert.gigi.database.DatabaseConnection;
+import org.cacert.gigi.output.CertificateTable;
+import org.cacert.gigi.pages.LoginPage;
+import org.cacert.gigi.pages.Page;
+
+public class MailCertificates extends Page {
+       CertificateTable myTable = new CertificateTable("mailcerts");
+       public static final String PATH = "/account/certs/email";
+
+       public MailCertificates() {
+               super("Email Certificates");
+       }
+
+       @Override
+       public void doGet(HttpServletRequest req, HttpServletResponse resp)
+                       throws IOException {
+               HashMap<String, Object> vars = new HashMap<String, Object>();
+               User us = LoginPage.getUser(req);
+               try {
+                       PreparedStatement ps = DatabaseConnection
+                                       .getInstance()
+                                       .prepare(
+                                                       "SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
+                       ps.setInt(1, us.getId());
+                       ResultSet rs = ps.executeQuery();
+                       vars.put("mailcerts", rs);
+                       myTable.output(resp.getWriter(), getLanguage(req), vars);
+                       rs.close();
+               } catch (SQLException e) {
+                       e.printStackTrace();
+               }
+       }
+
+}