Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

167
168
169
170
171
172
173
174
175
176
177
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM character_macroses WHERE char_obj_id=? AND id=?");
      statement.setInt(1, player.getObjectId());
      statement.setInt(2, macro.id);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.WARNING, "could not delete macro:", e);
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("UPDATE characters SET title=? WHERE obj_Id=?");
        statement.setString(1, title);
        statement.setInt(2, getObjectId());
        statement.execute();
      }
      catch(Exception e)
      {
      }
      finally
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE characters SET pledge_type=? WHERE obj_Id=?");
      statement.setInt(1, _pledgeType);
      statement.setInt(2, getObjectId());
      statement.execute();
    }
    catch(Exception e)
    {
    }
    finally
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE characters SET pledge_rank=? WHERE obj_Id=?");
      statement.setInt(1, _powerGrade);
      statement.setInt(2, getObjectId());
      statement.execute();
    }
    catch(Exception e)
    {
    }
    finally
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE characters SET apprentice=? WHERE obj_Id=?");
      statement.setInt(1, _apprentice);
      statement.setInt(2, getObjectId());
      statement.execute();
    }
    catch(Exception e)
    {
    }
    finally
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
        statement.setString(2, bidder.getClan().getLeaderName());
        statement.setLong(3, bid);
        statement.setLong(4, Calendar.getInstance().getTimeInMillis());
        statement.setInt(5, _auction.getId());
        statement.setInt(6, bidder.getClanId());
        statement.execute();
      }
      else
      {
        statement = con.prepareStatement("INSERT INTO auction_bid (id, auctionId, bidderId, bidderName, maxBid, clan_name, time_bid) VALUES (?, ?, ?, ?, ?, ?, ?)");
        statement.setInt(1, IdFactory.getInstance().getNextId());
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
        statement.setInt(3, bidder.getClanId());
        statement.setString(4, bidder.getName());
        statement.setLong(5, bid);
        statement.setString(6, bidder.getClan().getName());
        statement.setLong(7, Calendar.getInstance().getTimeInMillis());
        statement.execute();
      }
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: Auction.updateInDB(L2Player bidder, int bid): " + e.getMessage());
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM auction_bid WHERE auctionId=? AND bidderId=?");
      statement.setInt(1, _auction.getId());
      statement.setInt(2, bidder);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: Auction.cancelBid(String bidder): " + e.getMessage(), e);
    }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM auction_bid WHERE auctionId=?");
      statement.setInt(1, _auction.getId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: Auction.deleteFromDB(): " + e.getMessage(), e);
    }
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE clan_data SET auction_bid_at=? WHERE clan_id=?");
      statement.setInt(1, bid_at);
      statement.setInt(2, clanId);
      statement.execute();
    }
    catch(Exception e)
    {
      _log.warning("Could not store auction for clan: " + 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.