Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.executeQuery()

241
242
243
244
245
246
247
248
249
250
251
                                {
                                        // Clan Leader
                                        // Get Clan Name
                                        subStatement = con.prepareStatement("SELECT clan_name FROM clan_data WHERE leader_id=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subRset = subStatement.executeQuery();
                                        String clanName = null;
                                        if(subRset.next())
                                        {
                                                clanName = subRset.getString("clan_name");
                                        }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM lastimperialtomb_spawnlist");
      rset = statement.executeQuery();
      int npcTemplateId;
      L2Spawn spawnDat;
      L2NpcTemplate npcTemplate;
      while(rset.next())
      {
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT * FROM characters ORDER BY pvpkills DESC LIMIT 20;");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>ТОП 20 PVP");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT * FROM characters ORDER BY pkkills DESC LIMIT 20;");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>ТОП 20 PK");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT cha.char_name, cha.sex, cha.onlinetime, cha.pkkills, cha.pvpkills, cha.online FROM characters cha, olympiad_nobles oly WHERE cha.obj_Id = oly.char_id ORDER BY cha.pvpkills DESC LIMIT 20");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>ТОП 20 Дворян");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
375
376
377
378
379
380
381
382
383
384
385
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT * FROM castle ORDER BY id DESC LIMIT 10;");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>Статистика Замков");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
437
438
439
440
441
442
443
444
445
446
447
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT * FROM clan_data c WHERE c.clan_level > 0 ORDER BY c.clan_level DESC LIMIT 10;");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>Топ 10 Кланов");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
494
495
496
497
498
499
500
501
502
503
504
    ResultSet rs = null;
    try
    {
      tc = L2DatabaseFactory.getInstance().getConnection();
      fps = tc.prepareStatement("SELECT * FROM characters ORDER BY fame DESC LIMIT 20;");
      rs = fps.executeQuery();
      StringBuilder sb = new StringBuilder();
      sb.append("<table width=650>");
      sb.append("<tr><td><center>ТОП 20 Славы");
      sb.append("<img src=L2UI.SquareWhite width=450 height=1>");
      sb.append("<table width=450 bgcolor=CCCCCC>");
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
      statement.setString(1, wordList[1]);
      statement.execute();
      DatabaseUtils.closeStatement(statement);
      statement = con.prepareStatement("SELECT obj_id FROM characters where char_name=?");
      statement.setString(1, wordList[1]);
      rset = statement.executeQuery();
      int objId = 0;
      if(rset.next())
      {
        objId = rset.getInt(1);
      }
View Full Code Here
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("SELECT * FROM items WHERE owner_id=? AND (loc=? OR loc=?) ORDER BY object_id DESC");
      statement.setInt(1, OWNER);
      statement.setString(2, getBaseLocation().name());
      statement.setString(3, getEquipLocation().name());
      rset = statement.executeQuery();
      L2ItemInstance item, newItem;
      while(rset.next())
      {
        if((item = L2ItemInstance.restoreFromDb(rset, con, true)) == null)
        {
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.