Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeUpdate()

815
816
817
818
819
820
821
822
823
824
825
          statement.setInt(4, _augmentation.getSkill().getLevel());
        }
      }
      statement.setByte(5, _enchantAttributeElement);
      statement.setInt(6, _enchantAttributeValue);
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.info("Could not remove elemental enchant for item: " + getObjectId() + " from DB:");
      e.printStackTrace();
View Full Code Here
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
      statement.setInt(5, getEnchantLevel());
      statement.setInt(6, _lifeTimeRemaining);
      statement.setInt(7, getItemId());
      statement.setInt(8, _customFlags);
      statement.setInt(9, getObjectId());
      statement.executeUpdate();
      _existsInDb = true;
      _storedInDb = true;
    }
    catch(Exception e)
    {
View Full Code Here
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
      statement.setInt(9, _type2);
      statement.setInt(10, _lifeTimeRemaining);
      statement.setString(11, getName());
      statement.setString(12, getItemClass().name());
      statement.setInt(13, _customFlags);
      statement.executeUpdate();
      _existsInDb = true;
      _storedInDb = true;
      Stat.increaseInsertItemCount();
    }
    catch(Exception e)
View Full Code Here
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM items WHERE object_id = ? LIMIT 1");
      statement.setInt(1, _objectId);
      statement.executeUpdate();
      _existsInDb = false;
      _storedInDb = false;
      Stat.increaseDeleteItemCount();
    }
    catch(Exception e)
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
      statement = con.prepareStatement("UPDATE residence_functions SET endTime=?, inDebt=? WHERE type=? AND id=?");
      statement.setInt(1, (int) (getEndTimeInMillis() / 1000));
      statement.setInt(2, inDebt ? 1 : 0);
      statement.setInt(3, getType());
      statement.setInt(4, getResidenceId());
      statement.executeUpdate();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: ResidenceFunction.updateRentTime(boolean inDebt): " + e.getMessage(), e);
    }
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
      stmnt.setString(4, letter.body);
      stmnt.setInt(5, attachments == null ? 0 : attachments.length);
      stmnt.setLong(6, letter.price);
      stmnt.setLong(7, letter.validtime);
      stmnt.setInt(8, letter.system);
      stmnt.executeUpdate();
      DatabaseUtils.closeStatement(stmnt);
      stmnt = con.prepareStatement("SELECT LAST_INSERT_ID()");
      rs = stmnt.executeQuery();
      if(rs.next())
      {
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
          item.setLocation(ItemLocation.LEASE);
          item.updateDatabase(true, false);
          letter.attached.add(new TradeItem(item));
          stmnt.setInt(1, letter.id);
          stmnt.setInt(2, item.getObjectId());
          stmnt.executeUpdate();
        }
        letter.attachments = letter.attached.size();
      }
    }
    catch(Exception e)
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
            lettersByReceiverCache.remove(letter.receiverId);
          }
        }
        removed.add(letter);
        stmnt.setInt(1, id);
        stmnt.executeUpdate();
      }
      DatabaseUtils.closeStatement(stmnt);
      stmnt = con.prepareStatement("DELETE FROM mail_attachments WHERE messageId=? LIMIT ?");
      for(Letter letter : removed)
      {
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
      stmnt = con.prepareStatement("DELETE FROM mail_attachments WHERE messageId=? LIMIT ?");
      for(Letter letter : removed)
      {
        stmnt.setInt(1, letter.id);
        stmnt.setInt(2, letter.attachments);
        stmnt.executeUpdate();
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
View Full Code Here
502
503
504
505
506
507
508
509
510
511
512
          int id = rs.getInt("object_id");
          DatabaseUtils.closeStatement(statement);
          statement = con.prepareStatement("UPDATE items SET count=count+? WHERE object_id = ? LIMIT 1"); // если нашли увеличиваем ее количество
          statement.setLong(1, count);
          statement.setInt(2, id);
          statement.executeUpdate();
        }
        else
        {
          DatabaseUtils.closeStatement(statement);
          statement = con.prepareStatement("INSERT INTO items_delayed (owner_id,item_id,`count`,description) VALUES (?,?,?,'mail')"); // иначе используем items_delayed
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.