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
   7 import org.cacert.gigi.database.DatabaseConnection;
   8
   9 public class User {
  10
  11         private int id;
  12         String fname;
  13         String lname;
  14
  15         public User(int id) {
  16                 this.id = id;
  17                 try {
  18                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  19                                         "SELECT `fname`, `lname` FROM `users` WHERE id=?");
  20                         ps.setInt(1, id);
  21                         ResultSet rs = ps.executeQuery();
  22                         if (rs.next()) {
  23                                 fname = rs.getString(1);
  24                                 lname = rs.getString(2);
  25                         }
  26                         rs.close();
  27                 } catch (SQLException e) {
  28                         e.printStackTrace();
  29                 }
  30         }
  31         public int getId() {
  32                 return id;
  33         }
  34         public String getFname() {
  35                 return fname;
  36         }
  37         public String getLname() {
  38                 return lname;
  39         }
  40
  41 }