From cd694d64cf1a9be635df6b15168a5950644e5ce2 Mon Sep 17 00:00:00 2001 From: cirakg Date: Mon, 2 Jan 2023 17:00:24 +0100 Subject: Omogucen prikaz istorije korisnika. --- src/main/java/database/Database.java | 25 +++++++++++++++++++++++++ 1 file changed, 25 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 f6e18b3..587dc0e 100644 --- a/src/main/java/database/Database.java +++ b/src/main/java/database/Database.java @@ -14,6 +14,7 @@ import java.util.List; import models.Ability; import models.AbilityType; import models.GameStatus; +import models.History; import models.Monster; import models.MonsterViewModel; import models.User; @@ -356,5 +357,29 @@ public class Database { } return ps.executeUpdate(); } + public ArrayList getUserHistory(long id){ + ArrayList history=new ArrayList<>(); + String sql="SELECT * FROM history where player=? "; + try { + PreparedStatement ps=conn.prepareStatement(sql); + ps.setLong(1, id); + ResultSet res=ps.executeQuery(); + while(res.next()) { + History h=new History(); + h.pokemon=getMonsterViewModel(res.getLong("pokemon")); + h.time=res.getDate("time"); + h.result=res.getInt("result"); + history.add(h); + } + + } catch (SQLException e) { + // TODO Auto-generated catch block + e.printStackTrace(); + } + + + return history; + + } } -- cgit v1.2.3