From 4c3ff8c0c1bd5f19f9b813acbd127e6975a587ac Mon Sep 17 00:00:00 2001
From: Ognjen Cirkovic <ciraboxkg@gmail.com>
Date: Thu, 22 Dec 2022 04:31:20 +0100
Subject: Omoguceno brisanje pokemona.

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

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

diff --git a/src/main/java/database/Database.java b/src/main/java/database/Database.java
index ee07fac..e5e52e6 100644
--- a/src/main/java/database/Database.java
+++ b/src/main/java/database/Database.java
@@ -278,5 +278,28 @@ public class Database {
 			e.printStackTrace();
 		}
 	}
+	public void deleteMonster(long id) {
+		try {
+			conn.setAutoCommit(false);
+			String sql="DELETE FROM ability WHERE monsterId=?";
+			PreparedStatement pre = conn.prepareStatement(sql);
+			pre.setLong(1, id);
+			pre.executeUpdate();
+			 sql="DELETE FROM monster WHERE id=?";
+			 pre = conn.prepareStatement(sql);
+			pre.setLong(1, id);
+			pre.executeUpdate();
+			conn.commit();
+
+		} catch (SQLException  e) {
+			try {
+				conn.rollback();
+			} catch (SQLException e1) {
+				// TODO Auto-generated catch block
+				e1.printStackTrace();
+			}
+			e.printStackTrace();
+		}
+	}
 
 }
-- 
cgit v1.2.3