src/org/cacert/gigi/User.java

   1 package org.cacert.gigi;
   2
   3 import java.sql.PreparedStatement;
   4 import java.sql.ResultSet;
   5 import java.sql.SQLException;
   6 import java.util.Date;
   7
   8 import org.cacert.gigi.database.DatabaseConnection;
   9
  10 public class User {
  11
  12         private int id;
  13         String fname;
  14         String mname;
  15         String lname;
  16         String suffix;
  17         Date dob;
  18         String email;
  19
  20         public User(int id) {
  21                 this.id = id;
  22                 try {
  23                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  24                                         "SELECT `fname`, `lname` FROM `users` WHERE id=?");
  25                         ps.setInt(1, id);
  26                         ResultSet rs = ps.executeQuery();
  27                         if (rs.next()) {
  28                                 fname = rs.getString(1);
  29                                 lname = rs.getString(2);
  30                         }
  31                         rs.close();
  32                 } catch (SQLException e) {
  33                         e.printStackTrace();
  34                 }
  35         }
  36         public User() {
  37         }
  38         public int getId() {
  39                 return id;
  40         }
  41         public String getFname() {
  42                 return fname;
  43         }
  44         public String getLname() {
  45                 return lname;
  46         }
  47         public String getMname() {
  48                 return mname;
  49         }
  50         public void setMname(String mname) {
  51                 this.mname = mname;
  52         }
  53         public String getSuffix() {
  54                 return suffix;
  55         }
  56         public void setSuffix(String suffix) {
  57                 this.suffix = suffix;
  58         }
  59         public Date getDob() {
  60                 return dob;
  61         }
  62         public void setDob(Date dob) {
  63                 this.dob = dob;
  64         }
  65         public String getEmail() {
  66                 return email;
  67         }
  68         public void setEmail(String email) {
  69                 this.email = email;
  70         }
  71         public void setId(int id) {
  72                 this.id = id;
  73         }
  74         public void setFname(String fname) {
  75                 this.fname = fname;
  76         }
  77         public void setLname(String lname) {
  78                 this.lname = lname;
  79         }
  80
  81 }