1 package org.cacert.gigi.dbObjects;
3 import java.util.HashMap;
5 import org.cacert.gigi.database.DatabaseConnection;
6 import org.cacert.gigi.database.GigiPreparedStatement;
7 import org.cacert.gigi.database.GigiResultSet;
9 public class CertificateProfile {
13 private final String keyName;
15 private final String visibleName;
17 private static HashMap<String, CertificateProfile> byName = new HashMap<>();
19 private static HashMap<Integer, CertificateProfile> byId = new HashMap<>();
21 private CertificateProfile(int id, String keyName, String visibleName) {
23 this.keyName = keyName;
24 this.visibleName = visibleName;
31 public String getKeyName() {
35 public String getVisibleName() {
40 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT id, keyname, name FROM `profiles`");
41 GigiResultSet rs = ps.executeQuery();
43 CertificateProfile cp = new CertificateProfile(rs.getInt("id"), rs.getString("keyName"), rs.getString("name"));
44 byId.put(cp.getId(), cp);
45 byName.put(cp.getKeyName(), cp);
50 public static CertificateProfile getById(int id) {
54 public static CertificateProfile getByName(String name) {
55 return byName.get(name);