- int id;
- int serial;
- String dn;
- String md;
- String csrName;
- String crtName;
-
- // created, modified, revoked, expire
+ private int id;
+ private int serial;
+ private String dn;
+ private String md;
+ private String csrName;
+ private String crtName;
+ private String csr = null;
+
+ public Certificate(String dn, String md, String csr) {
+ this.dn = dn;
+ this.md = md;
+ this.csr = csr;
+ }
+
+ public Certificate(int id) {
+ try {
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "SELECT subject, md, csr_name, crt_name FROM `emailcerts` WHERE id=?");
+ ps.setInt(1, id);
+ ResultSet rs = ps.executeQuery();
+ if (!rs.next()) {
+ throw new IllegalArgumentException("Invalid mid " + id);
+ }
+ this.id = id;
+ dn = rs.getString(1);
+ md = rs.getString(2);
+ csrName = rs.getString(3);
+ crtName = rs.getString(4);
+ rs.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+