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                 try {
  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                 } catch (SQLException e) {
  25                         e.printStackTrace();
  26                 }
  27         }
  28 }