rendered paste body@EventHandler
public void checkforExplosion(EntityExplodeEvent event) throws SQLException{
if(event.isCancelled()) return;
List<Block> 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();
}
}
}