Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

59
60
61
62
63
64
65
66
67
68
69
        npcId = petlist.getInt("id");
        try
        {
          statement2 = con.prepareStatement("SELECT minLvl, skillId, skillLvl FROM pets_skills where templateId=? ORDER BY skillId, skillLvl");
          statement2.setInt(1, npcId);
          skilltree = statement2.executeQuery();
          while(skilltree.next())
          {
            id = skilltree.getInt("skillId");
            lvl = skilltree.getInt("skillLvl");
            minLvl = skilltree.getInt("minLvl");
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT id, MAX(level) AS level FROM skills WHERE level < 100 GROUP BY id");
      rset = statement.executeQuery();
      while(rset.next())
      {
        _baseLevels[rset.getInt("id")] = rset.getInt("level");
      }
      DatabaseUtils.closeDatabaseSR(statement, rset);
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
      {
        _baseLevels[rset.getInt("id")] = rset.getInt("level");
      }
      DatabaseUtils.closeDatabaseSR(statement, rset);
      statement = con.prepareStatement("SELECT id, MAX(level) AS level FROM skills GROUP BY id");
      rset = statement.executeQuery();
      while(rset.next())
      {
        _maxSQLLevels[rset.getInt("id")] = rset.getInt("level");
      }
    }
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM skills ORDER BY id, level ASC");
      rset = statement.executeQuery();
      int lastid = 0, lastmaxlearn = 0;
      while(rset.next())
      {
        int id = rset.getInt("id");
        int display_level = rset.getInt("level");
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
      }
      else
      {
        statement.setInt(2, 0);
      }
      rset = statement.executeQuery();
      L2Spawn spawn1;
      L2NpcTemplate template;
      while(rset.next())
      {
        template = NpcTable.getTemplate(rset.getInt("npcId"));
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM spawnlist ORDER by npc_templateid");
      //TODO возможно в будущем понадобится условие: WHERE npc_templateid NOT IN (SELECT bossId FROM epic_boss_spawn)
      rset = statement.executeQuery();
      L2Spawn spawnDat;
      L2NpcTemplate template1;
      while(rset.next())
      {
        template1 = NpcTable.getTemplate(rset.getInt("npc_templateid"));
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT owner_id, object_id, item_id, count, enchant_level FROM items WHERE loc = 'MONSTER'");
      rset = statement.executeQuery();
      while(rset.next())
      {
        count++;
        temp = L2ObjectsStorage.getAllByNpcId(rset.getInt("owner_id"), false);
        try
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT friend_id, char_name FROM character_friends LEFT JOIN characters ON ( character_friends.friend_id = characters.obj_Id ) WHERE char_id=?");
      statement.setInt(1, _cha.getObjectId());
      rset = statement.executeQuery();
      if(_message)
      {
        _cha.sendPacket(Msg._FRIENDS_LIST_);
      }
      while(rset.next())
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
        GArray<CropProcure> procure = new GArray<CropProcure>();
        GArray<CropProcure> procureNext = new GArray<CropProcure>();
        // restore seed production info
        statement = con.prepareStatement(CASTLE_MANOR_LOAD_PRODUCTION);
        statement.setInt(1, castle.getId());
        rs = statement.executeQuery();
        while(rs.next())
        {
          int seedId = rs.getInt("seed_id");
          long canProduce = rs.getLong("can_produce");
          long startProduce = rs.getLong("start_produce");
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
        castle.setSeedProduction(production, PERIOD_CURRENT);
        castle.setSeedProduction(productionNext, PERIOD_NEXT);
        // restore procure info
        statement = con.prepareStatement(CASTLE_MANOR_LOAD_PROCURE);
        statement.setInt(1, castle.getId());
        rs = statement.executeQuery();
        while(rs.next())
        {
          int cropId = rs.getInt("crop_id");
          long canBuy = rs.getLong("can_buy");
          long startBuy = rs.getLong("start_buy");
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.