Package l2p.database

Examples of l2p.database.ThreadConnection.prepareStatement()

25
26
27
28
29
30
31
32
33
34
35
    FiltredPreparedStatement statement = null;
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT MAX(endban) AS endban FROM bans WHERE obj_Id=? AND endban IS NOT NULL");
      statement.setInt(1, ObjectId);
      rset = statement.executeQuery();
      if(rset.next())
      {
        Long endban = rset.getLong("endban") * 1000L;
 
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
      {
        _log.warning("Negative ban period | From " + date + " to " + enddate);
        return;
      }
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("INSERT INTO bans (account_name, obj_id, baned, unban, reason, GM, endban) VALUES(?,?,?,?,?,?,?)");
      statement.setString(1, actor.getAccountName());
      statement.setInt(2, actor.getObjectId());
      statement.setString(3, date);
      statement.setString(4, enddate);
      statement.setString(5, msg);
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
    if(res)
    {
      try
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("UPDATE characters SET accesslevel=? WHERE obj_Id=?");
        statement.setInt(1, acc_level);
        statement.setInt(2, obj_id);
        statement.executeUpdate();
        DatabaseUtils.closeStatement(statement);
        if(acc_level < 0)
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
          if(endban * 1000L <= Calendar.getInstance().getTimeInMillis())
          {
            _log.warning("Negative ban period | From " + date + " to " + enddate);
            return false;
          }
          statement = con.prepareStatement("INSERT INTO bans (obj_id, baned, unban, reason, GM, endban) VALUES(?,?,?,?,?,?)");
          statement.setInt(1, obj_id);
          statement.setString(2, date);
          statement.setString(3, enddate);
          statement.setString(4, msg);
          statement.setString(5, GM);
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
          statement.setLong(6, endban);
          statement.execute();
        }
        else
        {
          statement = con.prepareStatement("DELETE FROM bans WHERE obj_id=?");
          statement.setInt(1, obj_id);
          statement.execute();
        }
      }
      catch(Exception e)
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
    try
    {
      String date = new SimpleDateFormat("yy.MM.dd H:mm:ss").format(new Date());
      msg = "Add karma(" + karma + ") " + msg;
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("INSERT INTO bans (account_name, obj_id, baned, reason, GM) VALUES(?,?,?,?,?)");
      statement.setString(1, actor.getAccountName());
      statement.setInt(2, actor.getObjectId());
      statement.setString(3, date);
      statement.setString(4, msg);
      statement.setString(5, GM);
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
    if(res)
    {
      try
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("update characters set karma=karma + ? where obj_Id=?");
        statement.setInt(1, karma);
        statement.setInt(2, obj_id);
        statement.execute();
        DatabaseUtils.closeStatement(statement);
        String date = new SimpleDateFormat("yy.MM.dd H:mm:ss").format(new Date());
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
        statement.setInt(2, obj_id);
        statement.execute();
        DatabaseUtils.closeStatement(statement);
        String date = new SimpleDateFormat("yy.MM.dd H:mm:ss").format(new Date());
        msg = "Add karma(" + karma + ") " + msg;
        statement = con.prepareStatement("INSERT INTO bans (obj_id, baned, reason, GM) VALUES(?,?,?,?)");
        statement.setInt(1, obj_id);
        statement.setString(2, date);
        statement.setString(3, msg);
        statement.setString(4, GM);
        statement.execute();
View Full Code Here
262
263
264
265
266
267
268
269
270
271
272
    else
    {
      try
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("UPDATE characters SET nochannel = ? WHERE obj_Id=?");
        statement.setLong(1, NoChannel > 0 ? NoChannel / 1000 : NoChannel);
        statement.setInt(2, obj_id);
        statement.executeUpdate();
      }
      catch(Exception e)
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
    else
    {
      try
      {
        con = L2DatabaseFactory.getInstance().getConnection();
        statement = con.prepareStatement("UPDATE characters SET nochannel = ? WHERE obj_Id=?");
        statement.setLong(1, 0);
        statement.setInt(2, obj_id);
        statement.executeUpdate();
      }
      catch(Exception 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.