WeaponSkillTable.java :  » Game » l1j-tw-99nets » l1j » server » server » datatables » Java Open Source

/**
 *                            License
 * THE WORK (AS DEFINED BELOW) IS PROVIDED UNDER THE TERMS OF THIS  
 * CREATIVE COMMONS PUBLIC LICENSE ("CCPL" OR "LICENSE"). 
 * THE WORK IS PROTECTED BY COPYRIGHT AND/OR OTHER APPLICABLE LAW.  
 * ANY USE OF THE WORK OTHER THAN AS AUTHORIZED UNDER THIS LICENSE OR  
 * COPYRIGHT LAW IS PROHIBITED.
 * 
 * BY EXERCISING ANY RIGHTS TO THE WORK PROVIDED HERE, YOU ACCEPT AND  
 * AGREE TO BE BOUND BY THE TERMS OF THIS LICENSE. TO THE EXTENT THIS LICENSE  
 * MAY BE CONSIDERED TO BE A CONTRACT, THE LICENSOR GRANTS YOU THE RIGHTS CONTAINED 
 * HERE IN CONSIDERATION OF YOUR ACCEPTANCE OF SUCH TERMS AND CONDITIONS.
 * 
 */
package l1j.server.server.datatables;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;
import java.util.logging.Level;
import java.util.logging.Logger;

import l1j.server.L1DatabaseFactory;
import l1j.server.server.model.L1WeaponSkill;
import l1j.server.server.utils.SQLUtil;
import l1j.server.server.utils.collections.Maps;

public class WeaponSkillTable {
  private static Logger _log = Logger.getLogger(WeaponSkillTable.class.getName());

  private static WeaponSkillTable _instance;

  private final Map<Integer, L1WeaponSkill> _weaponIdIndex = Maps.newMap();

  public static WeaponSkillTable getInstance() {
    if (_instance == null) {
      _instance = new WeaponSkillTable();
    }
    return _instance;
  }

  private WeaponSkillTable() {
    loadWeaponSkill();
  }

  private void loadWeaponSkill() {
    Connection con = null;
    PreparedStatement pstm = null;
    ResultSet rs = null;
    try {

      con = L1DatabaseFactory.getInstance().getConnection();
      pstm = con.prepareStatement("SELECT * FROM weapon_skill");
      rs = pstm.executeQuery();
      fillWeaponSkillTable(rs);
    }
    catch (SQLException e) {
      _log.log(Level.SEVERE, "error while creating weapon_skill table", e);
    }
    finally {
      SQLUtil.close(rs);
      SQLUtil.close(pstm);
      SQLUtil.close(con);
    }
  }

  private void fillWeaponSkillTable(ResultSet rs) throws SQLException {
    while (rs.next()) {
      int weaponId = rs.getInt("weapon_id");
      int probability = rs.getInt("probability");
      int fixDamage = rs.getInt("fix_damage");
      int randomDamage = rs.getInt("random_damage");
      int area = rs.getInt("area");
      int skillId = rs.getInt("skill_id");
      int skillTime = rs.getInt("skill_time");
      int effectId = rs.getInt("effect_id");
      int effectTarget = rs.getInt("effect_target");
      boolean isArrowType = rs.getBoolean("arrow_type");
      int attr = rs.getInt("attr");
      L1WeaponSkill weaponSkill = new L1WeaponSkill(weaponId, probability, fixDamage, randomDamage, area, skillId, skillTime, effectId,
          effectTarget, isArrowType, attr);
      _weaponIdIndex.put(weaponId, weaponSkill);
    }
    _log.config(" " + _weaponIdIndex.size() + "");
  }

  public L1WeaponSkill getTemplate(int weaponId) {
    return _weaponIdIndex.get(weaponId);
  }

}