1 package org.cacert.gigi.dbObjects;
3 import org.cacert.gigi.database.DatabaseConnection;
4 import org.cacert.gigi.database.GigiPreparedStatement;
5 import org.cacert.gigi.database.GigiResultSet;
7 public class Organisation extends CertificateOwner {
9 private final String name;
11 private final String state;
13 private final String province;
15 private final String city;
17 public Organisation(String name, String state, String province, String city, User creator) {
20 this.province = province;
22 int id = super.insert();
23 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("INSERT INTO organisations SET id=?, name=?, state=?, province=?, city=?, creator=?");
25 ps.setString(2, name);
26 ps.setString(3, state);
27 ps.setString(4, province);
28 ps.setString(5, city);
29 ps.setInt(6, creator.getId());
30 synchronized (Organisation.class) {
36 protected Organisation(GigiResultSet rs) {
37 name = rs.getString("name");
38 state = rs.getString("state");
39 province = rs.getString("province");
40 city = rs.getString("city");
43 public String getName() {
47 public String getState() {
51 public String getProvince() {
55 public String getCity() {
59 public static synchronized Organisation getById(int id) {
60 CertificateOwner co = CertificateOwner.getById(id);
61 if (co instanceof Organisation) {
62 return (Organisation) co;