rendered paste body try {
PreparedStatement statement2 = con.prepareStatement("SELECT mobId, itemId, min, max, sweep, chance FROM raid_droplist ORDER BY mobId,chance DESC");
ResultSet dropData = statement2.executeQuery();
L2DropData dropDat = null;
L2NpcTemplate npcDat = null;
while (dropData.next())
{
int mobId = dropData.getInt("mobId");
npcDat = _npcs.get(mobId);
dropDat = new L2DropData();
dropDat.setItemId(dropData.getInt("itemId"));
dropDat.setMinDrop(dropData.getInt("min"));
dropDat.setMaxDrop(dropData.getInt("max"));
dropDat.setSweep(dropData.getInt("sweep") == 1);
dropDat.setChance(dropData.getInt("chance"));
npcDat.addDropData(dropDat);
}
dropData.close();
statement2.close();
} catch (Exception e) {
_log.log(Level.SEVERE, "error reading raidboss drops ", e);
}