1 package org.cacert.gigi;
3 import java.sql.PreparedStatement;
4 import java.sql.ResultSet;
5 import java.sql.SQLException;
8 import org.cacert.gigi.database.DatabaseConnection;
9 import org.cacert.gigi.util.PasswordHash;
24 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
25 "SELECT `fname`, `lname` FROM `users` WHERE id=?");
27 ResultSet rs = ps.executeQuery();
29 fname = rs.getString(1);
30 lname = rs.getString(2);
33 } catch (SQLException e) {
42 public String getFname() {
45 public String getLname() {
48 public String getMname() {
51 public void setMname(String mname) {
54 public String getSuffix() {
57 public void setSuffix(String suffix) {
60 public Date getDob() {
63 public void setDob(Date dob) {
66 public String getEmail() {
69 public void setEmail(String email) {
72 public void setId(int id) {
75 public void setFname(String fname) {
78 public void setLname(String lname) {
81 public void insert(String password) throws SQLException {
83 throw new Error("refusing to insert");
85 PreparedStatement query = DatabaseConnection.getInstance().prepare(
86 "insert into `users` set `email`=?, `password`=?, "
87 + "`fname`=?, `mname`=?, `lname`=?, "
88 + "`suffix`=?, `dob`=?, `created`=NOW(), locked=0");
89 query.setString(1, email);
90 query.setString(2, PasswordHash.hash(password));
91 query.setString(3, fname);
92 query.setString(4, mname);
93 query.setString(5, lname);
94 query.setString(6, suffix);
95 query.setDate(7, new java.sql.Date(dob.getTime()));
97 id = DatabaseConnection.lastInsertId(query);
98 System.out.println("Inserted: " + id);