src/org/cacert/gigi/util/Notary.java

   1 package org.cacert.gigi.util;
   2
   3 import java.sql.PreparedStatement;
   4 import java.sql.SQLException;
   5
   6 import org.cacert.gigi.database.DatabaseConnection;
   7
   8 public class Notary {
   9         public static void writeUserAgreement(int memid, String document,
  10                         String method, String comment, boolean active, int secmemid)
  11                         throws SQLException {
  12                 PreparedStatement q = DatabaseConnection
  13                                 .getInstance()
  14                                 .prepare(
  15                                                 "insert into `user_agreements` set `memid`=?, `secmemid`=?,"
  16                                                                 + " `document`=?,`date`=NOW(), `active`=?,`method`=?,`comment`=?");
  17                 q.setInt(1, memid);
  18                 q.setInt(2, secmemid);
  19                 q.setString(3, document);
  20                 q.setInt(4, active ? 1 : 0);
  21                 q.setString(5, method);
  22                 q.setString(6, comment);
  23                 q.execute();
  24         }
  25 }