1 package org.cacert.gigi.util;
3 import java.sql.PreparedStatement;
4 import java.sql.SQLException;
6 import org.cacert.gigi.database.DatabaseConnection;
9 public static void writeUserAgreement(int memid, String document,
10 String method, String comment, boolean active, int secmemid) {
12 PreparedStatement q = DatabaseConnection
15 "insert into `user_agreements` set `memid`=?, `secmemid`=?,"
16 + " `document`=?,`date`=NOW(), `active`=?,`method`=?,`comment`=?");
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);
24 } catch (SQLException e) {