Examples of l2p.database.FiltredPreparedStatement.executeQuery()

Class l2p.database.FiltredPreparedStatement

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

l2p.database.FiltredPreparedStatement.executeQuery()

    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT `skill_id`,`skill_level`,`effect_count`,`effect_cur_time`,`duration` FROM `character_effects_save` WHERE `char_obj_id`=? AND `class_index`=? ORDER BY `order` ASC");
      statement.setInt(1, getObjectId());
      statement.setInt(2, getActiveClassId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        int skillId = rset.getInt("skill_id");
        int skillLvl = rset.getInt("skill_level");
        int effectCount = rset.getInt("effect_count");

View Full Code Here

    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("select slot, symbol_id from character_hennas where char_obj_id=? AND class_index=?");
      statement.setInt(1, getObjectId());
      statement.setInt(2, getActiveClassId());
      rset = statement.executeQuery();
      for(int i = 0; i < 3; i++)
      {
        _henna[i] = null;
      }
      while(rset.next())

View Full Code Here

    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT id FROM character_recipebook WHERE char_id=?");
      statement.setInt(1, getObjectId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        int id = rset.getInt("id");
        L2Recipe recipe = RecipeController.getInstance().getRecipeByRecipeId(id);
        registerRecipe(recipe, false);

View Full Code Here

    ResultSet rs = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      offline = con.prepareStatement("SELECT * FROM tournament_teams");
      rs = offline.executeQuery();
      while(rs.next())
      {
        Integer team_id = rs.getInt("team_id");
        Team team = teams.get(team_id);
        if(team == null)

View Full Code Here

    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      offline = con.prepareStatement(sql);
      offline.setInt(1, obj_id);
      rs = offline.executeQuery();
      if(rs.next())
      {
        if(rs.getInt("online") == 1)
        {
          info.online = true;

View Full Code Here

    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      offline = con.prepareStatement("SELECT B.type FROM character_subclasses AS A LEFT JOIN tournament_class_list AS B ON (A.class_id = B.class_id) WHERE A.active = 1 AND A.char_obj_id = ?");
      offline.setInt(1, obj_id);
      rs = offline.executeQuery();
      if(rs.next())
      {
        return rs.getInt("type");
      }
    }

View Full Code Here

    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      offline = con.prepareStatement("SELECT char_name FROM characters WHERE obj_Id = ?");
      offline.setInt(1, obj_id);
      rs = offline.executeQuery();
      if(rs.next())
      {
        return rs.getString("char_name");
      }
    }

View Full Code Here

    {
      con1 = L2DatabaseFactory.getInstance().getConnection();
      con2 = L2DatabaseFactory.getInstance().getConnection();
      statement1 = con1.prepareStatement("select * from tournament_teams where leader = 1 and category = ? and status = 1");
      statement1.setInt(1, category);
      rs = statement1.executeQuery();
      int i = 0;
      while(rs.next())
      {
        i++;
      }

View Full Code Here

    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      offline = con.prepareStatement("SELECT * FROM tournament_table WHERE category = ?");
      offline.setInt(1, category);
      rs = offline.executeQuery();
      while(rs.next())
      {
        int team1id = rs.getInt("team1id");
        int team2id = rs.getInt("team2id");
        String team1name = rs.getString("team1name");

View Full Code Here

        try
        {
          stmt = con.prepareStatement("SELECT obj_Id, char_name FROM characters WHERE account_name=? AND obj_Id!=?");
          stmt.setString(1, player._accountName);
          stmt.setInt(2, objectId);
          chars = stmt.executeQuery();
          while(chars.next())
          {
            final Integer charId = chars.getInt("obj_Id");
            final String charName = chars.getString("char_name");
            player._chars.put(charId, charName);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.