Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

266
267
268
269
270
271
272
273
274
275
276
        query.append("accumulated_bonus" + String.valueOf(i) + ", ");
      }
      query.append("accumulated_bonus" + String.valueOf(FESTIVAL_COUNT - 1) + " ");
      query.append("FROM seven_signs_status");
      statement = con.prepareStatement(query.toString());
      rset = statement.executeQuery();
      while(rset.next())
      {
        for(int i = 0; i < FESTIVAL_COUNT; i++)
        {
          _accumulatedBonuses[i] = rset.getInt("accumulated_bonus" + String.valueOf(i));
View Full Code Here
394
395
396
397
398
399
400
401
402
403
404
      try
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("SELECT char_name, clanid FROM characters WHERE obj_Id = ?");
        statement.setString(1, playerId);
        ResultSet rset = statement.executeQuery();
        if(rset.next())
        {
          int clanId = rset.getInt("clanid");
          if(clanId > 0)
          {
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT char_obj_id, id, icon, name, descr, acronym, commands FROM character_macroses WHERE char_obj_id=?");
      statement.setInt(1, player.getObjectId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        try
        {
          int id = rset.getInt("id");
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM auction WHERE id = ?");
      statement.setInt(1, _auction.getId());
      rs = statement.executeQuery();
      while(rs.next())
      {
        _auction.setCurrentBid(rs.getLong("currentBid"));
        _auction.setEndDate(Calendar.getInstance());
        _auction.getEndDate().setTimeInMillis(rs.getLong("endDate"));
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT bidderId, bidderName, maxBid, clan_name, time_bid FROM auction_bid WHERE auctionId = ? ORDER BY maxBid DESC");
      statement.setInt(1, _auction.getId());
      rs = statement.executeQuery();
      while(rs.next())
      {
        if(rs.isFirst())
        {
          _auction.setHighestBidderId(rs.getInt("bidderId"));
View Full Code Here
690
691
692
693
694
695
696
697
698
699
700
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT char_obj_id, cabal, seal, dawn_red_stones, dawn_green_stones, dawn_blue_stones, dawn_ancient_adena_amount, dawn_contribution_score, dusk_red_stones, dusk_green_stones, dusk_blue_stones, dusk_ancient_adena_amount, dusk_contribution_score FROM seven_signs");
      rset = statement.executeQuery();
      while(rset.next())
      {
        int charObjId = rset.getInt("char_obj_id");
        StatsSet sevenDat = new StatsSet();
        sevenDat.set("char_obj_id", charObjId);
View Full Code Here
712
713
714
715
716
717
718
719
720
721
722
        sevenDat.set("dusk_contribution_score", rset.getInt("dusk_contribution_score"));
        _signsPlayerData.put(charObjId, sevenDat);
      }
      DatabaseUtils.closeDatabaseSR(statement, rset);
      statement = con.prepareStatement("SELECT * FROM seven_signs_status");
      rset = statement.executeQuery();
      while(rset.next())
      {
        _currentCycle = rset.getInt("current_cycle");
        _activePeriod = rset.getInt("active_period");
        _previousWinner = rset.getInt("previous_winner");
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
      rset = statement.executeQuery();
      while(rset.next())
      {
        numLoaded++;
        statement2.setInt(1, rset.getInt("groupId"));
        rset2 = statement2.executeQuery();
        GArray<String> list = new GArray<String>();
        while(rset2.next())
        {
          list.add(rset2.getString("chatText"));
        }
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT id FROM siege_door WHERE unitId = ?");
      statement.setInt(1, getId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        id = rset.getInt("id");
        L2DoorInstance door = DoorTable.getInstance().getDoor(rset.getInt("id"));
        door.setSiegeUnit(this);
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM siege_doorupgrade WHERE doorId IN (SELECT id FROM siege_door WHERE unitId = ?)");
      statement.setInt(1, getId());
      rset = statement.executeQuery();
      while(rset.next())
      {
        upgradeDoor(rset.getInt("doorId"), rset.getInt("hp"), false);
      }
    }
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.