Adding serial checking of certificate login against Database.

[gigi.git] / src / org / cacert / gigi / User.java

diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java
index 4e366ba577e43beaa8fc516356c7313cdbe3d240..8c4b1f9dab466b7d6531e0d4d3b70cbf3becf7b0 100644 (file)
--- a/src/org/cacert/gigi/User.java
+++ b/src/org/cacert/gigi/User.java
@@ -1,14 +1,41 @@
 package org.cacert.gigi;
 
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+
+import org.cacert.gigi.database.DatabaseConnection;
+
 public class User {
 
        private int id;
+       String fname;
+       String lname;
 
        public User(int id) {
                this.id = id;
+               try {
+                       PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+                                       "SELECT `fname`, `lname` FROM `users` WHERE id=?");
+                       ps.setInt(1, id);
+                       ResultSet rs = ps.executeQuery();
+                       if (rs.next()) {
+                               fname = rs.getString(1);
+                               lname = rs.getString(2);
+                       }
+                       rs.close();
+               } catch (SQLException e) {
+                       e.printStackTrace();
+               }
        }
        public int getId() {
                return id;
        }
+       public String getFname() {
+               return fname;
+       }
+       public String getLname() {
+               return lname;
+       }
 
 }