@EventHandler public void checkforExplosion(EntityExplodeEvent event) throws SQLException{ if(event.isCancelled()) return; List blocks = event.blockList(); for(int i=0; i< blocks.size();i++){ Block block = blocks.get(i); System.out.println(block); PreparedStatement ask = this.conn.prepareStatement( "SELECT DURABILITY FROM REENFORCEMENTS WHERE x=? AND y=? AND z=? AND world=?"); ask.setInt(1, block.getX()); ask.setInt(2, block.getY()); ask.setInt(3, block.getZ()); ask.setString(4, block.getWorld().getName()); ask.execute(); ResultSet answer = ask.getResultSet(); if (!answer.next()) { answer.close(); ask.close(); return; } int durability = answer.getInt(1); durability--; ask.close(); answer.close(); if (durability <= 0) { System.out.println("if durability is <= 0"); PreparedStatement delete = this.conn.prepareStatement( "DELETE FROM REENFORCEMENTS WHERE x=? AND y=? AND z=? AND world=?"); delete.setInt(1, block.getX()); delete.setInt(2, block.getY()); delete.setInt(3, block.getZ()); delete.setString(4, block.getWorld().getName()); delete.execute(); delete.close(); } else { System.out.println("else if durability is > 0"); event.blockList().remove(block); PreparedStatement update = this.conn.prepareStatement( "UPDATE REENFORCEMENTS SET DURABILITY=? WHERE x=? AND y=? AND z=? AND world=?"); update.setInt(1, durability); update.setInt(2, block.getX()); update.setInt(3, block.getY()); update.setInt(4, block.getZ()); update.setString(5, block.getWorld().getName()); update.execute(); update.close(); } } }