Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

245
246
247
248
249
250
251
252
253
254
255
        }
        if(id.level() == 3)
        {
          statement = con.prepareStatement(id.getId() == 132 ? Olympiad.OLYMPIAD_GET_HEROS_SOULHOUND : Olympiad.OLYMPIAD_GET_HEROS);
          statement.setInt(1, id.getId());
          rset = statement.executeQuery();
          if(rset.next())
          {
            hero = new StatsSet();
            hero.set(Olympiad.CLASS_ID, id.getId());
            hero.set(Olympiad.CHAR_ID, rset.getInt(Olympiad.CHAR_ID));
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT clan_id FROM clan_data WHERE hasCastle = ? LIMIT 1");
      statement.setInt(1, getId());
      rset = statement.executeQuery();
      if(rset.next())
      {
        _ownerId = rset.getInt("clan_id");
      }
      statement = con.prepareStatement("SELECT * FROM castle WHERE id=? LIMIT 1");
View Full Code Here
270
271
272
273
274
275
276
277
278
279
280
      {
        _ownerId = rset.getInt("clan_id");
      }
      statement = con.prepareStatement("SELECT * FROM castle WHERE id=? LIMIT 1");
      statement.setInt(1, getId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        _name = rset.getString("name");
        _SiegeDayOfWeek = rset.getInt("siegeDayOfWeek");
        if(_SiegeDayOfWeek < 1 || _SiegeDayOfWeek > 7)
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
      statement.setString(2, getLocationType().name());
      if(clss != ItemClass.ALL)
      {
        statement.setString(3, clss.name());
      }
      rset = statement.executeQuery();
      L2ItemInstance item;
      while(rset.next())
      {
        if((item = L2ItemInstance.restoreFromDb(rset, con, false)) != null)
        {
View Full Code Here
214
215
216
217
218
219
220
221
222
223
224
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT object_id FROM items WHERE owner_id=? AND loc=? AND item_id=?");
      statement.setInt(1, getOwnerId());
      statement.setString(2, getLocationType().name());
      statement.setInt(3, itemId);
      rset = statement.executeQuery();
      if(rset.next())
      {
        foundItem = L2ItemInstance.restoreFromDb(rset.getInt(1), false);
      }
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(GET_HEROES);
      rset = statement.executeQuery();
      while(rset.next())
      {
        StatsSet hero = new StatsSet();
        int charId = rset.getInt(Olympiad.CHAR_ID);
        hero.set(Olympiad.CHAR_NAME, Olympiad.getNobleName(charId));
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
        HeroSetClanAndAlly(charId, hero);
        _heroes.put(charId, hero);
      }
      DatabaseUtils.closeDatabaseSR(statement, rset);
      statement = con.prepareStatement(GET_ALL_HEROES);
      rset = statement.executeQuery();
      while(rset.next())
      {
        StatsSet hero = new StatsSet();
        int charId = rset.getInt(Olympiad.CHAR_ID);
        hero.set(Olympiad.CHAR_NAME, Olympiad.getNobleName(charId));
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
      statement.setInt(1, clan.getClanId());
      if(unitid != 0)
      {
        statement.setInt(2, unitid);
      }
      rset = statement.executeQuery();
      if(rset.next())
      {
        register = true;
      }
    }
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
        _siege.addSiegeClan(_siege.getSiegeUnit().getOwnerId(), SiegeClanType.OWNER);
      }
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT clan_id, type FROM siege_clans where unit_id = ?");
      statement.setInt(1, _siege.getSiegeUnit().getId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        _siege.addSiegeClan(rset.getInt("clan_id"), SiegeClanType.getById(rset.getInt("type")));
      }
    }
View Full Code Here
231
232
233
234
235
236
237
238
239
240
241
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT festivalId, cabal, cycle, date, score, members, names FROM seven_signs_festival");
      rset = statement.executeQuery();
      while(rset.next())
      {
        int cycle = _signsInstance.getCurrentCycle();
        int festivalId = rset.getInt("festivalId");
        int cabal = SevenSigns.getCabalNumber(rset.getString("cabal"));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.