X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FSupportedUser.java;fp=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FSupportedUser.java;h=e957aa082faef1a5b1af048e8dea69cb0d73ad50;hp=decf55274047b5eab4e13400c7f2c3530cf66742;hb=a0232b6e40e7e09767f0444d24e18bf12dafc362;hpb=851b2db2211e0f7770065dc4558cc0de74a39df4 diff --git a/src/org/cacert/gigi/dbObjects/SupportedUser.java b/src/org/cacert/gigi/dbObjects/SupportedUser.java index decf5527..e957aa08 100644 --- a/src/org/cacert/gigi/dbObjects/SupportedUser.java +++ b/src/org/cacert/gigi/dbObjects/SupportedUser.java @@ -3,7 +3,6 @@ package org.cacert.gigi.dbObjects; import java.sql.Date; import org.cacert.gigi.GigiApiException; -import org.cacert.gigi.database.DatabaseConnection; import org.cacert.gigi.database.GigiPreparedStatement; import org.cacert.gigi.dbObjects.Certificate.CertificateStatus; @@ -54,12 +53,13 @@ public class SupportedUser { if (ticket == null) { throw new GigiApiException("No ticket set!"); } - GigiPreparedStatement prep = DatabaseConnection.getInstance().prepare("INSERT INTO `adminLog` SET uid=?, admin=?, type=?, information=?"); - prep.setInt(1, target.getId()); - prep.setInt(2, supporter.getId()); - prep.setString(3, type); - prep.setString(4, ticket); - prep.executeUpdate(); + try (GigiPreparedStatement prep = new GigiPreparedStatement("INSERT INTO `adminLog` SET uid=?, admin=?, type=?, information=?")) { + prep.setInt(1, target.getId()); + prep.setInt(2, supporter.getId()); + prep.setString(3, type); + prep.setString(4, ticket); + prep.executeUpdate(); + } } public int getId() {