Package l2p.database

Examples of l2p.database.FiltredPreparedStatement.execute()

217
218
219
220
221
222
223
224
225
226
227
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("DELETE FROM auction WHERE id=?");
      statement.setInt(1, _auction.getId());
      statement.execute();
    }
    catch(Exception e)
    {
      _log.log(Level.SEVERE, "Exception: Auction.deleteFromDB(): " + e.getMessage(), e);
    }
View Full Code Here
760
761
762
763
764
765
766
767
768
769
770
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(CASTLE_MANOR_DELETE_PROCURE);
      statement.setInt(1, getId());
      statement.execute();
      statement.close();
      if(_procure != null)
      {
        int count = 0;
        String query = "INSERT INTO castle_manor_procure VALUES ";
View Full Code Here
780
781
782
783
784
785
786
787
788
789
790
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      if(_procureNext != null)
      {
View Full Code Here
802
803
804
805
806
807
808
809
810
811
812
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      DatabaseUtils.closeDatabaseCS(con, statement);
    }
View Full Code Here
829
830
831
832
833
834
835
836
837
838
839
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement(CASTLE_MANOR_DELETE_PROCURE_PERIOD);
      statement.setInt(1, getId());
      statement.setInt(2, period);
      statement.execute();
      statement.close();
      GArray<CropProcure> proc = null;
      proc = getCropProcure(period);
      if(proc != null)
      {
View Full Code Here
851
852
853
854
855
856
857
858
859
860
861
          for(int i = 1; i < values.length; i++)
          {
            query += "," + values[i];
          }
          statement = con.prepareStatement(query);
          statement.execute();
          statement.close();
        }
      }
      DatabaseUtils.closeDatabaseCS(con, statement);
    }
View Full Code Here
879
880
881
882
883
884
885
886
887
888
889
      statement = con.prepareStatement(CASTLE_UPDATE_CROP);
      statement.setLong(1, amount);
      statement.setInt(2, cropId);
      statement.setInt(3, getId());
      statement.setInt(4, period);
      statement.execute();
      statement.close();
    }
    catch(Exception e)
    {
      _log.info("Error adding crop data for castle " + getName() + ": " + e.getMessage());
View Full Code Here
904
905
906
907
908
909
910
911
912
913
914
      statement = con.prepareStatement(CASTLE_UPDATE_SEED);
      statement.setLong(1, amount);
      statement.setInt(2, seedId);
      statement.setInt(3, getId());
      statement.setInt(4, period);
      statement.execute();
      statement.close();
    }
    catch(Exception e)
    {
      _log.info("Error adding seed production data for castle " + getName() + ": " + e.getMessage());
View Full Code Here
938
939
940
941
942
943
944
945
946
947
948
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE castle SET ownDate = ? WHERE id = ?");
      statement.setInt(1, getOwnerId() != 0 ? getOwnDate() : 0);
      statement.setInt(2, getId());
      statement.execute();
    }
    catch(Exception e)
    {
      System.out.println("Exception: saveOwnDate(): " + e.getMessage());
      e.printStackTrace();
View Full Code Here
973
974
975
976
977
978
979
980
981
982
983
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.prepareStatement("UPDATE castle SET flags = ? WHERE id = ?");
      statement.setString(1, flags);
      statement.setInt(2, getId());
      statement.execute();
    }
    catch(Exception e)
    {
      System.out.println("Exception: saveFlags(): " + e.getMessage());
      e.printStackTrace();
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.