All pastes #2129751 Raw Edit

Someone

public text v1 · immutable
#2129751 ·published 2012-03-18 23:35 UTC
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();
				}
			} 	
		
		
	}