[mego4el]

Здравствуйте. Подскажите как можно дернуть значение из базы(проверить) жив или мертв РБ?

Сборка: Scoria

Сделал так, но не робит(

con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement;
				statement = con.prepareStatement("SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name FROM raidboss_spawnlist LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id ORDER BY npc.level DESC, npc.name ASC;");
				ResultSet rset = statement.executeQuery();

				while(rset.next())
				{
					String name = rset.getString("name");
					int level = rset.getInt("level");
					String status = "";
					
					long respawn_time = rset.getLong("respawn_time");
					
					switch(respawn_time)
					{
						case 0 : status = "Жив"; break;
							default : status = "Мертв"; break;
					}

Аналогично и тут

con = L2DatabaseFactory.getInstance().getConnection();
				PreparedStatement statement;
				statement = con.prepareStatement("SELECT `grandboss_data`.`boss_id`, `grandboss_data`.`respawn_time`, npc.level, npc.name FROM `grandboss_data` LEFT JOIN `npc` ON `grandboss_data`.`boss_id` = `npc`.`id` ORDER BY `grandboss_data`.`status` ASC , `npc`.`level` DESC;");
				ResultSet rset = statement.executeQuery();

				while(rset.next())
				{
					String name = rset.getString("name");
					String level = rset.getString("level");
					String status = "";
					
					long respawn_time = rset.getLong("respawn_time");
					
					switch(respawn_time)
					{
						case 0 : status = "Жив"; break;
							default : status = "Мертв"; break;
					}