Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

109
110
111
112
113
114
115
116
117
118
119
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM siege_clans WHERE unit_id=? and type=?");
      statement.setInt(1, _siege.getSiegeUnit().getId());
      statement.setInt(2, type.getId());
      statement.execute();
      _siege.getSiegeClans(type).clear();
    }
    catch(Exception e)
    {
      _log.warning("Exception: clearSiegeWaitingClan(): " + e);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM siege_clans WHERE unit_id=? and clan_id=?");
      statement.setInt(1, unit_id);
      statement.setInt(2, clanId);
      statement.execute();
      loadSiegeClan();
    }
    catch(Exception e)
    {
      _log.warning("Exception: removeSiegeClan(): " + e);
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("REPLACE INTO siege_clans (clan_id,unit_id,type) VALUES (?,?,?)");
      statement.setInt(1, clan.getClanId());
      statement.setInt(2, _siege.getSiegeUnit().getId());
      statement.setInt(3, typeId);
      statement.execute();
      _siege.addSiegeClan(clan.getClanId(), SiegeClanType.getById(typeId));
    }
    catch(Exception e)
    {
      _log.warning("Exception: saveSiegeClan: " + e);
View Full Code Here
735
736
737
738
739
740
741
742
743
744
745
        _signsDuskSealTotals.put(SEAL_STRIFE, rset.getInt("strife_dusk_score"));
      }
      DatabaseUtils.closeDatabaseSR(statement, rset);
      statement = con.prepareStatement("UPDATE seven_signs_status SET date=?");
      statement.setInt(1, Calendar.getInstance().get(Calendar.DAY_OF_WEEK));
      statement.execute();
    }
    catch(SQLException e)
    {
      _log.severe("Unable to load Seven Signs Data: " + e);
    }
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
      statement.setString(4, _auction.getSellerClanName());
      statement.setString(5, _auction.getItemName());
      statement.setLong(6, _auction.getStartingBid());
      statement.setLong(7, _auction.getCurrentBid());
      statement.setLong(8, _auction.getEndDate().getTimeInMillis());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: Auction.confirmAuction(): " + e.getMessage(), e);
    }
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE auction SET endDate = ? WHERE id = ?");
      statement.setLong(1, _auction.getEndDate().getTimeInMillis());
      statement.setInt(2, _auction.getId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: saveAuctionDate(): " + e.getMessage(), e);
    }
View Full Code Here
330
331
332
333
334
335
336
337
338
339
340
          statement2.setInt(3, festivalCycle);
          statement2.setLong(4, Long.valueOf(festivalDat.getString("date")));
          statement2.setInt(5, festivalDat.getInteger("score"));
          statement2.setString(6, festivalDat.getString("members"));
          statement2.setString(7, festivalDat.getString("names", ""));
          statement2.execute();
          DatabaseUtils.closeStatement(statement2);
        }
      }
    }
    catch(SQLException e)
View Full Code Here
954
955
956
957
958
959
960
961
962
963
964
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("INSERT INTO seven_signs (char_obj_id, cabal, seal) VALUES (?,?,?)");
        statement.setInt(1, charObjId);
        statement.setString(2, getCabalShortName(chosenCabal));
        statement.setInt(3, chosenSeal);
        statement.execute();
      }
      catch(SQLException e)
      {
        _log.severe("SevenSigns: Failed to save data: " + e);
      }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
      statement.setInt(2, _player1Id);
      statement.setInt(3, _player2Id);
      statement.setBoolean(4, _maried);
      statement.setLong(5, _affiancedDate);
      statement.setLong(6, _weddingDate);
      statement.execute();
    }
    catch(SQLException e)
    {
      e.printStackTrace();
    }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
          sb.append(',').append(cmd.cmd);
        }
        sb.append(';');
      }
      statement.setString(7, sb.toString());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.WARNING, "could not store macro: " + macro.toString(), e);
    }
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.