From 110a2354cff010f88b59dbb302192fce0cc6a9ac Mon Sep 17 00:00:00 2001
From: cirakg <ciraboxkg@gmail.com>
Date: Fri, 30 Dec 2022 04:32:03 +0100
Subject: Omogucen prikaz online korisnika.

---
 src/main/java/database/Database.java | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'src/main/java/database/Database.java')

diff --git a/src/main/java/database/Database.java b/src/main/java/database/Database.java
index e5e52e6..80d195c 100644
--- a/src/main/java/database/Database.java
+++ b/src/main/java/database/Database.java
@@ -301,5 +301,31 @@ public class Database {
 			e.printStackTrace();
 		}
 	}
+	public User getUserById(long id){
+		User user=null;
+		try {
+			String sql="SELECT * FROM user WHERE id=?";
+			PreparedStatement statement = conn.prepareStatement(sql);
+			statement.setLong(1, id);
+			ResultSet res=statement.executeQuery();
+			if(res.next()) {
+				user=new User();
+				user.setId(res.getLong("id"));
+				user.setAdmin(res.getBoolean("admin"));
+				user.setUsername(res.getString("username"));
+				if(res.getObject("pokemonId")!=null)
+					user.setmonsterId(res.getLong("pokemonId"));
+				else 
+					user.setmonsterId(-1);
+			}
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return user;
+		
+	}
 
 }
-- 
cgit v1.2.3