X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FUser.java;h=bf47552ac56a7b3e7285eefe20588f895e8aa984;hb=79e4e5abf2c48fdf6dd07c7278e99f93cde5f59d;hp=50e13ac044e14b9e187117b44ac72a4ea533939f;hpb=06c5d96d7dc2df71a1658e1c7c9e34ad065d10d7;p=gigi.git diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java index 50e13ac0..bf47552a 100644 --- a/src/org/cacert/gigi/User.java +++ b/src/org/cacert/gigi/User.java @@ -6,6 +6,7 @@ import java.sql.SQLException; import java.util.Date; import org.cacert.gigi.database.DatabaseConnection; +import org.cacert.gigi.util.PasswordHash; public class User { @@ -77,5 +78,24 @@ public class User { public void setLname(String lname) { this.lname = lname; } + public void insert(String password) throws SQLException { + if (id != 0) { + throw new Error("refusing to insert"); + } + PreparedStatement query = DatabaseConnection.getInstance().prepare( + "insert into `users` set `email`=?, `password`=?, " + + "`fname`=?, `mname`=?, `lname`=?, " + + "`suffix`=?, `dob`=?, `created`=NOW(), locked=0"); + query.setString(1, email); + query.setString(2, PasswordHash.hash(password)); + query.setString(3, fname); + query.setString(4, mname); + query.setString(5, lname); + query.setString(6, suffix); + query.setDate(7, new java.sql.Date(dob.getTime())); + query.execute(); + id = DatabaseConnection.lastInsertId(query); + System.out.println("Inserted: " + id); + } }